Thread: Dynamic Chart
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Dave Y
 
Posts: n/a
Default Dynamic Chart

Hello,

I have a spreadsheet that has its data in the following format:

2003 2004 2005 2006
Company 1 1.5 1.63 2.1
Company 2 .75 .89 1.09

How can I create a dynamic chart so that when I input the data for 2006 (and
forward) the chart will automatically update. Thank you in advance for any
assistance provided.

Dave Y