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]