Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I display more than one pie chart on a sheet in Excel?
I'd like to have several pie charts on one sheet and I cannot figure out how
to do that! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How do I display more than one pie chart on a sheet in Excel?
Instead of a pie chart as a standalone chart sheet, make your pie chart as a
chart object in a worksheet. If you don't want it on a sheet with data on it, insert a blank worksheet first, then place your chart on this blank sheet. To do this, in step 4 of the Chart Wizard, select the As Object In option, and select the blank sheet from the dropdown. Fix up the pie chart the way you like it (size, colors, etc.), and move it to an appropriate position in the sheet. While moving and sizing the chart, you can make it stick to cell boundaries by holding ALT while dragging the mouse. Now, make a copy of the pie chart. One easy way is to hold CTRL, then drag the chart to the new location. CTRL leaves the original in place and moves a copy to the new position. Select the new chart, and use Source Data from the Chart menu to change the data displayed in the chart. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ "caw954s" wrote in message ... I'd like to have several pie charts on one sheet and I cannot figure out how to do that! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Display form from an VB application in Excel | Excel Discussion (Misc queries) | |||
How do I get my Excel time-line column chart to display in color? | Charts and Charting in Excel | |||
Excel: Can I display a chart when the mouse is over a cell? | Charts and Charting in Excel | |||
Getting Excel Data from One Sheet to Another.... | Excel Discussion (Misc queries) | |||
make an excel worksheet (sheet 2) open w/ the cursor located in t. | Excel Discussion (Misc queries) |