Equal size cells in doughnut chart

Mich37

New member
Joined
Jun 5, 2017
Messages
1
Reaction score
0
Points
0
Hi Guys,

I have been trying to do this for days without luck, and surrendered to some online help.

Im trying to make a doughnut chart with equal size cells, so that I can make a calendar kinda similar to this one below:
025.jpg

When I create the pie chart from the selected cells, it uses the numbers in the cells to as values to change the size of the cells like this:
ex.jpg

I can make a doughnut chart with equal size cells by making all the values 1. But then how do I enter text into each cell and have the chart stay the same size? Ive been trying to see how to make the values of each cell the same etc but failed, and I still need to enter my own text into each cell. Not sure if my question makes sense but its difficult to explain.

Pls help :-(
 
After spending an hour changing this:
Capture3.JPG
to this:
Capture3.JPG
I find you've cross posted this here: https://www.excelforum.com/excel-ch...size-cells-in-doughnut-chart.html#post4671935 without links and got it solved.
So I've wasted my time. Utterly. Thank you.

Mich37, for your information, you should always provide links to your cross posts.
This is a requirement, not just a request.
If you have cross posted at other places, please add links to them too.
Why? Have a read of http://www.excelguru.ca/content.php?184

Grrr.
 
Back
Top