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" wrote:

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%