ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   x-axis value (https://www.excelbanter.com/charts-charting-excel/192115-x-axis-value.html)

benj

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!

Mike Middleton

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!




benj

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