G
Guest
How can I create a chart in a workbook then break the link between the cells and the chart
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
G
Guest
You could do this
Go to Chart|Source Data and choose the Series tab
Here you can enter actual numbers and the name of the information. Make sure you separate all numbers after the first one with a comma. Example: 1200,1500,4500,230
For a column chart, this would yield 4 columns
Replacing the worksheet references with actual numbers should give you a chart that wouldn't depend on the data
But, if you have the chart mostly formatted and the above seems too tedious, you could
Select the whole chart are
Press and hold the Shift Key and click on the Edit menu
This should give you the option to Copy Picture
As long as you don't choose to link the picture (you can choose Edit|Paste Special and make sure Link isn't selected), this should give you a picture of a chart that isn't linked to the source. You'll have to edit it as a picture, though
The first option wouldn't be very fast and second option isn't very flexible. Maybe someone else has another answer
tj
Go to Chart|Source Data and choose the Series tab
Here you can enter actual numbers and the name of the information. Make sure you separate all numbers after the first one with a comma. Example: 1200,1500,4500,230
For a column chart, this would yield 4 columns
Replacing the worksheet references with actual numbers should give you a chart that wouldn't depend on the data
But, if you have the chart mostly formatted and the above seems too tedious, you could
Select the whole chart are
Press and hold the Shift Key and click on the Edit menu
This should give you the option to Copy Picture
As long as you don't choose to link the picture (you can choose Edit|Paste Special and make sure Link isn't selected), this should give you a picture of a chart that isn't linked to the source. You'll have to edit it as a picture, though
The first option wouldn't be very fast and second option isn't very flexible. Maybe someone else has another answer
tj
G
Guest
One more workaround option, if the chart is not on the same sheet as the source data
Duplicate the sheet that has the source data on it. If the chart is already created it will be linked to the Original Source Data worksheet. Rename the Original something like "Chart Source." Then, Hide it. You might even want to protect the Chart Source sheet before you hide it. Then, rename the copy sheet to eliminate the (2) at the end
This will let you have the data in the chart stay the same until the source is uhidden (and unprotected) and eidted. You would also have the data the chart was based on in the duplicate sheet, and it could be edited without altering the chart
tj
Duplicate the sheet that has the source data on it. If the chart is already created it will be linked to the Original Source Data worksheet. Rename the Original something like "Chart Source." Then, Hide it. You might even want to protect the Chart Source sheet before you hide it. Then, rename the copy sheet to eliminate the (2) at the end
This will let you have the data in the chart stay the same until the source is uhidden (and unprotected) and eidted. You would also have the data the chart was based on in the duplicate sheet, and it could be edited without altering the chart
tj
D
Debra Dalgleish
Jon Peltier has instructions for delinking chart data:
www.peltiertech.com/Excel/ChartsHowTo/DelinkChartData.html
www.peltiertech.com/Excel/ChartsHowTo/DelinkChartData.html
link between the cells and the chart?-----Original Message-----
How can I create a chart in a workbook then break the