Graphs and VBA

  • Thread starter Interactive worksheet
  • Start date
I

Interactive worksheet

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
 
C

chillihawk

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

Duke Carey

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
 
I

Interactive worksheet

That worked beautifully, thank you!

Duke Carey said:
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
Click to expand...
 
Top