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]