| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
is there a way to create multiple pies in one chart (comparison)?
|
|
#2
|
|||
|
|||
|
Hi,
Quick answer is no. Create multiple chart objects and arrange then to appear as 1 chart. So only display the legend on one of the chartobjects and either use cells to draw a border around the charts or add a rectangle. If you need to you can then change there location to embed the chart objects within a blank chart sheet. A quick way to create a blank chart sheet is to press F11 making sure the active and surrounding cells are empty. Cheers Andy Jim W wrote: -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do i auto create multiple files from 1 with multiple sheets | Excel Worksheet Functions | |||
| create multiple worksheets in workbook from one csv file | Excel Discussion (Misc queries) | |||
| How to create Multiple Conditional Formulas in a single cell? | Excel Discussion (Misc queries) | |||
| Create a total based on multiple conditions is not giving correct. | Excel Worksheet Functions | |||
| HOW DO I CREATE MULTIPLE CURRENCY | Excel Worksheet Functions | |||
Linear Mode
