| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
Paste charts to reference new worksheet
When I copy and paste a chart between worksheets, the new chart plots the
data series from the old sheet. I want it to plot the values from the new sheet (of cells with the same references). How do I do it? |
|
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Paste charts to reference new worksheet
Copy the sheet with the data and the chart, then change the data on the
copied sheet. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "hmm" wrote in message ... When I copy and paste a chart between worksheets, the new chart plots the data series from the old sheet. I want it to plot the values from the new sheet (of cells with the same references). How do I do it? |
|
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
|
Paste charts to reference new worksheet
Copy the sheet with the data and the chart, then change the data on the
copied sheet. No, that does not work in Excel 2007! It did in 2003... It's probably a bug. Very frustrating, since I need to manually update hundreds of data series now. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Paste link for charts | Charts and Charting in Excel | |||
| Reference in charts | Charts and Charting in Excel | |||
| paste charts into powerpoint-misalignment | Charts and Charting in Excel | |||
| Can you paste formulas with no value so Charts don't registerthem | Excel Discussion (Misc queries) | |||
| Copy/Paste charts | Charts and Charting in Excel | |||
Linear Mode
