Thread: Updating a chart as a worksheet is updated

Originally Posted by psheridan050

Hi all, I have created a line chart using stock data from existing data within a worksheet. What I would like to do is add data to the worksheet and have the chart automatically include this data within the chart. Currently, I have to manually go into the chart and change the data range. As I have many charts to change this can take a lot of time. If I add blank cells to the data range within the chart then the chart includes this range makiing it a small chart with lots of space on the right side. I'm using Office 2007 and thanks for any suggestions!

Hi,

Until you become proficient enough in VBA programming to automatically adjust multiple charts, the easy way is probably to set your charts up to the maximum range of columns that will be required, and Hide those columns not yet used. Setting the chart to 'visible' figures only will reduce the display to those columns with figures.

To add new figures simply unhide the next column and enter your figures.

hth
---

hi,

Another option is the use of "dynamic named ranges" which I have used successfully, see the below link for some instructions involving the use of Offset & count functions which I found after entering the above phrase into Excel Online Help.

HTML Code:

http://office.microsoft.com/en-us/excel/HA011098011033.aspx?pid=CL100570551033

This works very well when maintained within the original workbook but the named ranges can cause problems if charts are copied from workbook to workbook.

Bryan/others, do you have any other negatives which may impact through the use of named ranges?

hth
Rob