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

Hi

Use dynamic ranges as data series sources.


--
Arvi Laanemets
( My real mail address: arvi.laanemets<attarkon.ee )



"Prakash" wrote in message
...
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