Data Source for excel graph

G

Guest

Hello Experts,



1. I have a graph/chart object. Whose source data for a series is
say =Sheet2!$J$2:$J$27
2. How will I change the data source dynamically for the chart. So that for
a new set of data whose series value is upto 100 and I want the graph to
dynamically set the series value =Sheet2!$J$2:$J$100
as applicable.

Thank you in advance.

Regards
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Bizarre chart behaviour when changing axis cross at points 2
Can blank cells be omitted from graph? 7
Source data for a Chart 2
Excel Chart - Too many data points in Series? 1
Line charting the same series using data from multiple sheets? 1
Charting the Sum of Two, or More, Series of Data 6
Excel chart does not start at zero. 1
Naming the Series 1

Top