X Axis to Scale
 

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

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

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