ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   How do I create a doughnut chart with different sizes for each ser (https://www.excelbanter.com/charts-charting-excel/217655-how-do-i-create-doughnut-chart-different-sizes-each-ser.html)

Nuno

How do I create a doughnut chart with different sizes for each ser
 
I want to make a doughnut chart that has a size proportional to the total
value for each serie. Let's say the outter doughnut have a greaterthickness
than the inner one.

Jon Peltier

How do I create a doughnut chart with different sizes for each ser
 
Even if you could get the areas to be proportional (you can't in Excel),
nobody will realize it, because human perception of areas is far less
accurate than of lengths. You should use a bar chart instead.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Nuno" wrote in message
...
I want to make a doughnut chart that has a size proportional to the total
value for each serie. Let's say the outter doughnut have a
greaterthickness
than the inner one.




Nuno

How do I create a doughnut chart with different sizes for each
 
Thank you.
I was expecting an answer like that.
Well I will use a bar chart as you recommend.

Thank you once again


"Jon Peltier" wrote:

Even if you could get the areas to be proportional (you can't in Excel),
nobody will realize it, because human perception of areas is far less
accurate than of lengths. You should use a bar chart instead.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.
http://PeltierTech.com/WordPress/
_______


"Nuno" wrote in message
...
I want to make a doughnut chart that has a size proportional to the total
value for each serie. Let's say the outter doughnut have a
greaterthickness
than the inner one.






All times are GMT +1. The time now is 12:44 PM.

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