Excel 2007 : Line Graphs percentage axis

Hi,

Apologies, I am not an excel expert and this may seem a silly question to ask.

I am creating a line graph for a team dashbaord, on the x axis I need it to display a percentage from 0-140, based upon my source data. However the axis is appearing as 0- 14% instead. I've tried a few ways of formatting it, but cannot seem to get it to change.

any help would be appreciated.

Many Thanks

What type of chart are you using, scatter (numeric x-axis) or line (category x axis)? What values are in the x axis series, 0-14? 0-0.14?
I exclusively use scatter plots for the data I plot, and the simple answer to your question in that case is to scale the x axis data (in the spreadsheet) so it ranges from 0 to 1.4