Thread: Charting Actual vs. Plan

I am trying to show a chart that shows the percentage of an actual vs. a plan number, but it is not showing properly.

I have the following numbers:

Plan Actual
10900 10000

When I chart these two numbers I get Plan showing as 52% of the chart and Actual at 48%. I want it to show the actual at 92% (actual/plan).

How do I do this?

What kind of chart (bar, pie, column, line) are you using? I would think the best way would be to add a column C =B1/A1, then plot that column in your chart.

It's a pie chart. I tried adding the third column and it doens't work. I get a 0%

It appears you are trying to make the whole pie (100%) be planned. So you need to use actual to determine the "shortage" Try C1=A1-B1 and then use B1:C1 as your chart data series. Then the "actual" slice will show as 92% and the "shortage" slice will show as 8%.

Note that this kind of approach (pie chart in general) is going to have problems if actual is ever greater than planned.

If that doesn't help, you'll need to be more specific as to what you want to accomplish.