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:
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:
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 :-(
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:
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:
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 :-(