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] |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Update chart with new row - not working in 007
Hi Scott,
It is true that you can't drag data onto the chart anymore in 2007. However, you can stil use the copy and paste command. Select the new data in the spreadsheet and copy it. Right click on the chart and choose Paste. An additional suggestion - if you predefine the data range as a Table (Insert, Table) and then you build your chart from that, when you add a new set of data to the table the chart will update automatically. -- Cheers, Shane Devenshire "Scott McPhillips [MVP]" wrote: 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] |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Update chart with new row - not working in 007
ShaneDevenshire wrote:
Hi Scott, It is true that you can't drag data onto the chart anymore in 2007. However, you can stil use the copy and paste command. Select the new data in the spreadsheet and copy it. Right click on the chart and choose Paste. An additional suggestion - if you predefine the data range as a Table (Insert, Table) and then you build your chart from that, when you add a new set of data to the table the chart will update automatically. Thank you, Shane. The Paste new row didn't work right (the chart lost the series names) but the Table approach did the trick. -- Scott McPhillips [VC++ MVP] |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Update chart with new row - not working in 007
Hi Scott,
I prefer the Table/List method but just to try it, if the paste command doesn't work the first way, try this - do the copy as before and then click on the chart and choose the command Home, Paste, Paste Special. The dialog box that appears will probably let you solve the problem. -- Cheers, Shane Devenshire "Scott McPhillips [MVP]" wrote: ShaneDevenshire wrote: Hi Scott, It is true that you can't drag data onto the chart anymore in 2007. However, you can stil use the copy and paste command. Select the new data in the spreadsheet and copy it. Right click on the chart and choose Paste. An additional suggestion - if you predefine the data range as a Table (Insert, Table) and then you build your chart from that, when you add a new set of data to the table the chart will update automatically. Thank you, Shane. The Paste new row didn't work right (the chart lost the series names) but the Table approach did the trick. -- Scott McPhillips [VC++ MVP] |
Reply |
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 |