Multiple charts
 

How can I display all of my charts on a work book on a single sheet? I have
seen several charts on one sheet and I am wondering how it is done.
Thank you
DR

When walking through the chart wizard, you have the option of inserting the
chart into a new worksheet or as an object in an existing worksheet. Check
the box to insert into an existing worksheet and choose the cell you would
like it to appear in. By doing this, you can display all charts in one book.

"Derrick Robinson" wrote:

How can I display all of my charts on a work book on a single sheet? I have
seen several charts on one sheet and I am wondering how it is done.
Thank you
DR

Thank you. I overlooked that option. My carelessness. Thanks again.
DR

"Paxton" wrote in message
...
When walking through the chart wizard, you have the option of inserting
the
chart into a new worksheet or as an object in an existing worksheet.
Check
the box to insert into an existing worksheet and choose the cell you would
like it to appear in. By doing this, you can display all charts in one
book.

"Derrick Robinson" wrote:

How can I display all of my charts on a work book on a single sheet? I
have
seen several charts on one sheet and I am wondering how it is done.
Thank you
DR

To move existing charts, right-click on the chart, and choose Location.
From the 'As object in' dropdown, select a sheet.

Derrick Robinson wrote:
Thank you. I overlooked that option. My carelessness. Thanks again.
DR

"Paxton" wrote in message
...

When walking through the chart wizard, you have the option of inserting
the
chart into a new worksheet or as an object in an existing worksheet.
Check
the box to insert into an existing worksheet and choose the cell you would
like it to appear in. By doing this, you can display all charts in one
book.

"Derrick Robinson" wrote:


How can I display all of my charts on a work book on a single sheet? I
have
seen several charts on one sheet and I am wondering how it is done.
Thank you
DR








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