Hello, how can I get a graph to simply visualize the current progress to the goal?
It seems to represent the total amount split between each cell.
I'm looking to get it to show 75% with 3/4 of the graph shaded to represent this
( 825/1100 = 0.75 )
I'm utterly confused, what am I missing here?
The donut calculates percentages automatically.
But if you want a "temperature" type chart then you can use a 2D Stacked Bar something like this:
Formula in E2:
=C2/B2
Formula in F2:
=100%−E2
To create the chart:
SG
The donut calculates percentages automatically.
But if you want a "temperature" type chart then you can use a 2D Stacked Bar something like this:
Formula in E2:
=C2/B2
Formula in F2:
=100%−E2
To create the chart:
SG
You need one more cell with the difference. For example, I added one more cell:
It simply calculates how much is left (goal - current), then plot those two values on your chart:
Visualize progress to goal as a shaded graph
