Need help on showing the difference between two series....

[ashwithonline]

Hi,


Attached excel sheet has a data for two processes which are to be compared for 2015 - 2016 along with the weeks...

the data is rolling correctly....but i wanted to show the difference in volumes for these two years for which i tried the high-low lines option ...but its showing only the lines...i also want to show the difference...

Thanks in advance for the help.....

 

[Hui]

Do you mean like :


I added a new series to the chart
The Red line is a plot of Column AE on the secondary axis
The secondary axis has the same scale as the primary

 

[ashwithonline]

I wanted to populate the difference between the volumes of 2015 and 2016 for a process, example: the volume for FIDO2 for week 2 is 1773 in 2015 and 2807 in 2016.

so the vertical line should reflect a difference of 1034.

Thanks again

 

[Nebu]

Hi:

Is this what you are looking for?

Thanks

 

[p45cal]

an alternative?:

 

[ashwithonline]

Thanks Nebu..this was something that i was looking for.....thanks a lotttttt......