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! |
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! |
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! |
All times are GMT +1. The time now is 01:46 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com