Graphs and VBA

[Guest]

Hello,

I am making a graph and would like to make a table below the graph that will
show the datapoints. I would like to pull the data series that the graph is
using to populate the table. Is this possible? Please help.

Alex

 

[chillihawk]

If you are using an excel chart then you can publish the DataTable by
selection this from the ChartOptions.

 

[Guest]

Create your graph, then right click on its border. Choose Chart Options from
the popup menu. On the right-most tab is the option to ahve Excel create the
data table

 

[Guest]

That worked beautifully, thank you!

Create your graph, then right click on its border. Choose Chart Options from
the popup menu. On the right-most tab is the option to ahve Excel create the
data table