Thread: X Axis to Scale
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Shane Devenshire[_2_] Shane Devenshire[_2_] is offline
external usenet poster
 
Posts: 3,346
Default X Axis to Scale

Hi,

Try changing the chart type to Stacked Line which with your data could be
the 2nd, 3rd, 5th or 6th subtype under Line.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire


"Erin Searfoss" wrote:

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