source data editor in Excel 2007 dont seem to allow copy and past.

[Pieter]

The new source data editor dont allow copy and paste of other series data
followed by a manual edit to get the correct range of cells.
The new editor also dont diplay a preview of the chart.

Is there another way to accomplish these atsks in Excel 2007?

 

[Jon Peltier]

There's no preview because things are changed on the live chart as you make
changes.

It's awkward as all get out, but you can in fact copy and paste. You need to
select an existing series, click the Edit button, the select and copy the
reference in one of the edit boxes. Then clear the small dialog, click add,
and paste into the new small dialog and make your changes. It was much
easier when the edit boxes were located on the same dialog as the series
list. They sure didn't pay much attention to usability in Excel 2007, did
they?

Here's more of my experience with Excel 2007 Charts:

http://peltiertech.com/WordPress/2008/05/06/changes-to-charting-in-excel-2007/

- Jon