Gap Chart

[Gap from Target]

How do you make a chart that shows a gap from the target? In my graph the
Target is a solid line. My Actual is bar but I have it not shown, and my Gap
from Target is bar also. But I want to show an empty space between the Target
and Gap from Target

Example:

Name Target Actual Gap from Target
Alan 100 % 85% 15%
Bill 90% 90% 0%
Sue 80% 70% 10%

 

[Tushar Mehta]

What does "My Actual is bar but I have it not shown" mean? That you are not
plotting the actual value? That you have formatted the bar to be invisible?
Something else altogether?

Also, what does "I want to show an empty space between the Target and Gap
from Target" mean? Doesn't Actual + Gap-from-target = Target? So, if you
have actual and gap-from-target as a stacked column chart, they will, by
definition, touch the target!
--
Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-click to format may not work; right click and select
from the menu

 

[Gap from Target]

My Actual is graphed as a bar but it is invisible. The reason for an empty
space between Target and Gap from Target is to show how far off it from the
Target. Does this make sense?

 

[Tushar Mehta]

No, unfortunately, it's not clear what you want. As I mentioned in the
previous post 'Gap from target' when stacked on top of the actual will, by
definition, touch the target. There can be no empty space.

Maybe, what you want is to show the actual and make the 'gap from target'
invisible. Of course, in that case, you could just skip plotting that series.

--
Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-click to format may not work; right click and select
from the menu