ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Graphs and VBA (https://www.excelbanter.com/excel-discussion-misc-queries/79415-graphs-vba.html)

Interactive worksheet

Graphs and VBA
 
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

Duke Carey

Graphs and VBA
 
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


"Interactive worksheet" wrote:

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


Interactive worksheet

Graphs and VBA
 
That worked beautifully, thank you!

"Duke Carey" wrote:

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


"Interactive worksheet" wrote:

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



All times are GMT +1. The time now is 02:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com