Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
source data editor in Excel 2007 dont seem to allow copy and past.
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? |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
source data editor in Excel 2007 dont seem to allow copy and past.
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/200...in-excel-2007/ - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "Pieter" wrote in message ... 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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2007 change pivot data source | Excel Discussion (Misc queries) | |||
Macro: Insert, copy and past data from sheet | Excel Discussion (Misc queries) | |||
Excel 2007 change data source | Excel Discussion (Misc queries) | |||
How do you copy and past data from one spreadsheet to another? | Excel Discussion (Misc queries) | |||
Excel 2007 : Equation editor | Excel Discussion (Misc queries) |