Updating a chart as a worksheet is updated

[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!

[Bryan Hessey]

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
---

[broro183]

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.

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

[psheridan050]

thanks guys for the info. ill look into these suggestions and incorporate them into my charts