chart help

[afdmello]

I have a column charts with month on x axis and percentage on Y axis

Now when I add the year to date average as a line chart in the select data tab and click edit series the real values can be seen but in the chart it is showing 100% horizontal line

Hope I was able to explain the phenomenom

I am using excel 2007

Afd