ExcelBanter - Chart to new sheet

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Chart to new sheet (https://www.excelbanter.com/charts-charting-excel/155451-chart-new-sheet.html)

KBA

Chart to new sheet

How can I move a chart from one sheet to another without the series refer to
the first sheet?

Jon Peltier

Chart to new sheet

Copy the whole sheet that contains the chart, then copy the new data over
the original data on the copied sheet.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

"KBA" wrote in message
...
How can I move a chart from one sheet to another without the series refer
to
the first sheet?

KBA

Chart to new sheet

So simpel :-) Thanks!

"Jon Peltier" skrev:

Copy the whole sheet that contains the chart, then copy the new data over
the original data on the copied sheet.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

"KBA" wrote in message
...
How can I move a chart from one sheet to another without the series refer
to
the first sheet?

Jon Peltier

Chart to new sheet

Everything's simple, when you know how!

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

"KBA" wrote in message
...
So simpel :-) Thanks!

"Jon Peltier" skrev:

Copy the whole sheet that contains the chart, then copy the new data over
the original data on the copied sheet.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______

"KBA" wrote in message
...
How can I move a chart from one sheet to another without the series
refer
to
the first sheet?

All times are GMT +1. The time now is 05:34 PM.