Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Update chart with new row - not working in 007
I have a stacked area chart that I have been updating for years. The X
axis is date and I add a new date row weekly. In previous versions of Excel, to update the chart each week I could simply select the new row of data and then drag and drop it onto the chart. That doesn't work with Excel 2007 (it copies or moves the selected data). I also tried the 'Select Data' dialog, but it says "The data range is too complex to be displayed. If a new range is selected it will replace all of the series in the series panel." The chart date range in that dialog is blank. (I use a simple rectangular range, but it is pretty big (AZ x 508)). So I don't see a way to add the new row of data into the existing chart. Thanks for any suggestions. -- Scott McPhillips [VC++ MVP] |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Update 2nd Chart | Charts and Charting in Excel | |||
Do not update chart | Excel Discussion (Misc queries) | |||
Graph from a PIVOT table: update not working. Please Help! | Excel Discussion (Misc queries) | |||
Update Automatic Links Not Working in 2003 | Excel Discussion (Misc queries) | |||
excel links update not working in auto, calculations in auto | Excel Worksheet Functions |