Need help in creating dynamic graph

[dibs]

Hello All,

Could you please help me to create a Dynamic Graph where the series will automatically get selected based on the cells that have data.

For example if I am trying to pull up pricing graph based on the dates then the same graph should work for 10 years price history as well as 1 years price history. The series will select only the datas for one year or 10 years depending on the data available in the cells, i.e. Series will go upto where the data cell doesn't have any values.

Thank you in advance
Dibs

 

[Andrew Poulsom]

See Example 1 here:

http://www.tushar-mehta.com/excel/newsgroups/dynamic_charts/index.html

 

[dibs]

Thank you very much Mr.Andrew for your help

Regards
Dibs