Secondary Vertical Axis Bar not in sync with Primary Vertical Axis

Hi!

I need to plot the Temp. range of a machine taken at different times and no. of readings, which are plotted on Primary Y & X Axis, respectively. The Temp. data is available in increments of 5 degrees celsius.

I also need to plot the current temperature of the machine which I plot on the Secondary Y Axis. The length of the Bar showing the current temperature is equal to the max. no. of readings at any temp. in the data range.

The problem is that even though I have mentioned the max. and min. of the Secondary Y axis similar to the max. and min. of the primary Y axis, the values in the two axes never seem to be in sync, and my bar for current temp. is always above or below the actual corresponding value in the primary axis.

Can someone please advise what I am missing here, OR is there a better way to plot this chart with current Temp Bar showing with a Different Colour.

Note: Image given below and Sample file attached.


Capture.PNG

Attachment 647491

Originally Posted by MrShorty

I'm not sure why you are using a logarithmic axis for the secondary vertical axis.

Hi Shorty,

I had selected Logarithmic scale out of frustration (just to show that I have tried all possible combinations). Seems I had not ;-)

Anyways, when I converted the Primary Y Axis to Date Axis, I immediately saw gaps in my chart (corresponding to the gaps in my data set, considering the 5 unit increments that I was trying to plot), which were not being shown by the earlier Chart, since the Category Axis was smoothing out the gaps. To elaborate, my data set was not 5, 10, 15, 20, 25... but more like 5, 10, 25...

This smoothing out was resulting in the wrong plotting of data on primary Y axis, and as pointed out by you, it was actually the Primary Y axis which was creating problem not the Secondary Axis.

On a trial basis, when I reset my Temp. data set for the Primary Y Axis with actual 5 unit increments (and without any gaps in the data set), the current Temp. bar was plotting in perfect sync on both Axis, without the need to change the primary Axis type to date Axis.

Thanks for pointing me in the right direction.