Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Automation of Dynamic Chart Title and legend changes Boon8888 Charts and Charting in Excel 1 February 3rd 06 11:00 PM
Dynamic Range with unused formula messing up x axis on dynamic graph [email protected] Charts and Charting in Excel 2 February 2nd 06 08:02 PM
Dynamic bar chart, must ignore "n/a" data... paris3 Charts and Charting in Excel 4 June 26th 05 07:07 PM
dynamic end on chart Donna YaWanna Charts and Charting in Excel 1 June 17th 05 04:50 PM
how to change range for dynamic chart in excel 2000 with button? ivan Charts and Charting in Excel 2 April 24th 05 04:10 AM


All times are GMT +1. The time now is 02:34 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"