Share via

How to get Excel charts x-axis to scale with the data

Anonymous
2021-11-03T23:20:50+00:00

How do I scale the x-axis in a chart according to data values?

For example, if my x-axis values are .25, .5 and 1, I would like the space between .25 and .5 to be half the space between .5 and 1. Right now they're always the same space apart.

Microsoft 365 and Office | Excel | Other | Windows

Locked Question. This question was migrated from the Microsoft Support Community. You can vote on whether it's helpful, but you can't add comments or replies or follow the question.

0 comments

1 answer

Sort by: Most helpful
Most helpful Newest Oldest
  1. Anonymous
    2021-11-04T01:36:38+00:00

    Hi LeRoy!

    I'm Jen, and I'd be happy to help you out with this issue.

    Right click on the x-axis, select Format axis, go to the Number section, then select 'Number' in the drop down, select the number of places in the 'Decimal Places' then click OK.

    I hope this information helps. If you have any questions, please let me know and I'd be glad to assist you further.

    Best Regards!

    Jen :)

    3 people found this answer helpful.
    0 comments