If an Excel chart’s vertical axis is incremented by 20,000, and most of its data points are between 70,000 and 550,000, the chart will look somewhat crowded at the top if the horizontal axis crosses the vertical axis at zero. You can try to make the chart easier to read by resizing and enlarging the chart area, but there will still be a lot of white space at the bottom of the chart. Here is a better way to change the automatic axis settings:
- Open the Excel file containing the chart.
- Click a value in the chart’s vertical axis to select it.
- Right-click the selected vertical axis.
- Click Format Axis.
- Click the Fixed button for Minimum.
- Click the Fixed button for Maximum.
- Click the Fixed button for Major.
- Click the Fixed button for Minor.
- Click the Minimum text box and enter 20000.
- Press [Enter].
Now the horizontal axis crosses the vertical axis at 20,000, making it easier to compare data points and read the chart.
Miss an Excel tip?
Check out the Microsoft Excel archive, and catch up on other Excel tips.
Help users increase productivity by automatically signing up for TechRepublic’s free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.
Subscribe to the Developer Insider Newsletter
From the hottest programming languages to commentary on the Linux OS, get the developer and open source news and tips you need to know. Delivered Tuesdays and Thursdays