 |
 |
 |
 |
 |
|
|
||||||||||||
|
#1
10-03-2005, 02:05 PM
|
|||
|
|||
|
stop chart series from updating
I have created a chart and now want to change the data it uses as the source,
BUT I do not want my original chart to update as I want to create a different chart. Does anyone know to freeze the chart so it is no longer linked to the cells? 
|
|
#2
10-03-2005, 05:05 PM
|
|||
|
|||
|
Re: stop chart series from updating
One way would be to take a picture of the chart as it is now.
Click the chart; hold Shift key down; use menu item Edit and select Copy Picture; use As displayed; then use Paste command to paste picture on worksheet or in a Word Doc, etc. Another way is to delink the chart. Click of a data series in the chart, look in Formula Bar and you see something like =SERIES(Sheet1!$E$13,Sheet1!$D$14:$D$19,Sheet1!$E$14:$E$19,1) Click anywhere in the Formula Bar and press F9 Formula bar has something like =SERIES("y",{1,2,3,4,5,6},{7,8,9,6,7,8},1) Note the cell references are replaced by values. Any help? -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "johnmoreland21" <johnmoreland21@discussions.microsoft.com> wrote in message news:73F7DA47-CA91-46F5-9450-24F617C51E94@microsoft.com... >I have created a chart and now want to change the data it uses as the >source, > BUT I do not want my original chart to update as I want to create a > different chart. Does anyone know to freeze the chart so it is no longer > linked to the cells?
|
 |
| Bookmarks |
New topics in Excel Charting
|
|
|
| Currently Active Users Viewing This Thread: 1 (0 members and 1 guests) | |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Linear Mode
