DATA range is Series is not insync with the data range in asix range

[Sambiz]

I have Column Chart to represent the Actual data Range and I have a line chart for the Target Data range but the data for the Target range is not in ration and it falls flat on the Y Axis as if it is not to scale

it bugging me because it has not been a problem up until now

I can send you a copy of what it looks like but can't Send the work sheet

it might be glaringly obvious

[xlnitwit]

Hi,

Your target values appear to be 0.05 for each point which is why they are plotted very close to the bottom of the Y axis.

[Sambiz]

I think I did check but I will recheck again but the figures i am pulling through from the raw data states 5.0. So there maybe a hidden ratio that is mankind it 0.05. is There to eliminate the hidden calculation

[xlnitwit]

Without being able to see the actual workbook I cannot tell you why the values are not what you think. Perhaps they are formatted as percentages which is why you see 5 rather than 0.05?

[Sambiz]

No worries i see how the 0.05 came about because it was percentage and the X and Y axis was normal numbering

Thank for your help