Thread: X Axis to Scale
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default X Axis to Scale

If you want to treat the values as values, not as categories, use XY, not
line chart. The terminology is confusing.
--
David Biddulph

"Erin Searfoss" wrote in message
...
I am charting the following with a line graph.

10% 10.3
33% 9.6
35% 9.4
50% 7.3

I have the percentages on the x axis but they are showing up as four
distinct categories rather than as values so that 35% is the same distance
from 33% as 33% is from 10%. Is there a way for the y values to plot
against
a smooth x-axis from 0% to 100%?

Thanks.

Erin