ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   how do i create 4 pie charts (https://www.excelbanter.com/charts-charting-excel/72713-how-do-i-create-4-pie-charts.html)

Mike Kim

how do i create 4 pie charts
 
Hi,

Could I enquire if someone could show me the steps to create 4 pie charts in
diagram (1 pie chart representing one calendar year)? How do I modify the
different size of the pie chart?

Thanks a lot.

Andy Pope

how do i create 4 pie charts
 
Hi,

A chart can only contain a single Pie chart so you will need to create 4
charts. If you create chartobjects these can be embedded in a worksheet
or a blank chart sheet.

To adjust the size you can alter the plot area.
You don't mention what you are using to determine the size of the pie
but this page may be of use.
http://www.andypope.info/charts/piesizer.htm

Cheers
Andy

Mike Kim wrote:
Hi,

Could I enquire if someone could show me the steps to create 4 pie charts in
diagram (1 pie chart representing one calendar year)? How do I modify the
different size of the pie chart?

Thanks a lot.


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info


All times are GMT +1. The time now is 03:04 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com