Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.charting
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
How to draw chart: log scale on X axis, natural scale on y axis? | Charts and Charting in Excel | |||
How do I reference x-axis or y-axis scale values to a worksheet ce | Excel Discussion (Misc queries) | |||
How to make Primary axis and Secondary X-axis have the same scale | Excel Discussion (Misc queries) | |||
Format Axis; Scale Tab; "Value Axis Crosses At" ends with preposit | Charts and Charting in Excel | |||
How to insert X axis scale values next to axis and X axis grid lin | Charts and Charting in Excel |