#1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 41
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.charting
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

  #3   Report Post  
Posted to microsoft.public.excel.charting
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



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
How to draw chart: log scale on X axis, natural scale on y axis? Pratap D. chavan Charts and Charting in Excel 1 November 16th 06 08:03 AM
How do I reference x-axis or y-axis scale values to a worksheet ce retro5726 Excel Discussion (Misc queries) 0 August 10th 06 01:46 AM
How to make Primary axis and Secondary X-axis have the same scale AdamCPTD Excel Discussion (Misc queries) 0 July 14th 06 02:14 PM
Format Axis; Scale Tab; "Value Axis Crosses At" ends with preposit Pedant Charts and Charting in Excel 1 August 29th 05 03:50 AM
How to insert X axis scale values next to axis and X axis grid lin vp23larry Charts and Charting in Excel 2 June 23rd 05 03:45 PM


All times are GMT +1. The time now is 05:11 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"