Data Source for excel graph

[Prakash]

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

 

[Arvi Laanemets]

Hi

Use dynamic ranges as data series sources.