Multiple charts

  • Thread starter Derrick Robinson
  • Start date
D

Derrick Robinson

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
 
P

Paxton

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.
 
D

Derrick Robinson

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

Debra Dalgleish

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