I've attached a few examples. I'm not sure why you had difficulty doing this if you were able to graph Target vs. Time.
In the first, the difference (Target - Actual) is displayed as a bar graph. However, since there are negative values, they overlay the horizontal axis and its labels.
In the second, this is helped somewhat by moving where horizontal axis crosses the vertical axis to -4. While the labels are no longer obscured by the bars, it is now a bit counterintuitive with "positive" bars representing some negative data.
Lastly, I changed the above to a line graph. Again, the labels are not obscured but in this the representation of negative data is less counterintuitive.
If you want to put them all on the same chart, it can be done by using a secondary axis.
|