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.

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

Ken wrote:
> 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?

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

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
>
>Ken wrote:
>> 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?
>
>--
>Debra Dalgleish
>Excel FAQ, Tips & Book List
>http://www.contextures.com/tiptech.html
>
>.
>