Change Worksheet to Chart

[Ken]

We have a workbook with some charts imbedded (if that is
the right word) in worksheets and we have a Data drop down
box on the menu bar. We have some charts that are
on "chart" worksheets and we have a Chart drop down box on
the menu bar.

How can we "convert" the imbedded worksheet charts to
chart-type worksheets?

TIA.

 

[Debra Dalgleish]

Right-click on an embedded chart.
Choose Location
Select 'As new sheet'
Use the default name, or type a different name
Click OK

 

[Ken]

That was easy.
Thanks a lot, Deb.

-----Original Message-----
Right-click on an embedded chart.
Choose Location
Select 'As new sheet'
Use the default name, or type a different name
Click OK


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

.