Need help in creating dynamic graph

dibs

New Member
Joined
Sep 7, 2006
Messages
2
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
 

Some videos you may like

Excel Facts

Workdays for a market open Mon, Wed, Friday?
Yes! Use "0101011" for the weekend argument in NETWORKDAYS.INTL or WORKDAY.INTL. The 7 digits start on Monday. 1 means it is a weekend.

Watch MrExcel Video

Forum statistics

Threads
1,113,849
Messages
5,544,645
Members
410,627
Latest member
georgealice
Top