Share via

Excel Chart - Adjust Horizontal Range

Anonymous
2023-05-09T16:55:27+00:00

Hello,

Recently I tried copying and pasting an Excel chart - then manually moving (dragging) the series data to the appropriate spot in the spreadsheet. I did this to save a little time with formatting the chart. However, the horizontal axis range does not match the data. I have taken a screen capture and have annotated the screen capture to make more clear what I describe. In the screen capture the horizontal axis should start at 3.8 and continue to 4.8.

How could this be fixed?

Microsoft 365 and Office | Excel | For business | 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. HansV 462.4K Reputation points MVP Volunteer Moderator
    2023-05-09T17:08:53+00:00

    Double-click on any of the x-axis labels.

    This should activate the Format Axis task pane,

    Under Axis Options, you can specify the minimum and maximum values for the axis:

    0 comments