Line Graph showing the difference between two lines

[jal0315]

Hi,

I am creating a line graph that will have two lines, the high being a contracted amount of hours and the low being the amount of hours actually worked. Is there any type of graph that can be used whether it be a line graph or something else that show graphically and numerically the difference in the two numbers?

 

[Derek Brown]

You have two series in your chart so you could try adding a third series which represents the difference between the two (just an extra column or row with a formula to calculate the value).

You could then move the third series to the 'secondary axis' and change the chart type to a column chart with the value inside the bottom of the column. You could then experiment with the formatting (for example the transparency) of the series, scaling etc.