Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
x-axis value
good day!
my x-axis value are 12.4, 27, 35. it shows these values in equal distribution (or spacing). what i want the value to be like 5, 10, 15 up to 40 and the tick mark of 12.4 is somewhere inbetween 10 and 15. am using a line chart. thanks! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
x-axis value
benj -
Do not use a Line chart type. Use an XY (Scatter) chart type, which you can format to have lines connecting the markers. - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel "benj" wrote in message ... good day! my x-axis value are 12.4, 27, 35. it shows these values in equal distribution (or spacing). what i want the value to be like 5, 10, 15 up to 40 and the tick mark of 12.4 is somewhere inbetween 10 and 15. am using a line chart. thanks! |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
x-axis value
thanks Mike!
"Mike Middleton" wrote: benj - Do not use a Line chart type. Use an XY (Scatter) chart type, which you can format to have lines connecting the markers. - Mike Middleton http://www.DecisionToolworks.com Decision Analysis Add-ins for Excel "benj" wrote in message ... good day! my x-axis value are 12.4, 27, 35. it shows these values in equal distribution (or spacing). what i want the value to be like 5, 10, 15 up to 40 and the tick mark of 12.4 is somewhere inbetween 10 and 15. am using a line chart. thanks! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Need PivotChart x axis to cross Y axis at minimum Y axis value | Charts and Charting in Excel | |||
Excel 2003: Mapping rows (x-axis) vs multiple columns (y-axis) | Excel Discussion (Misc queries) | |||
Adding data on Axis Major Gridlines next to Category Axis Collums | New Users to Excel | |||
How to insert X axis scale values next to axis and X axis grid lin | Charts and Charting in Excel | |||
Secondary Axis Annual Units sold on 1 Y Axis - Dollar Volume on another | Charts and Charting in Excel |