Improve axes format in Excel
1. Hide some points
Sometimes you need to omit some points of the chart axis, e.g., the zero point:
See How to hide points on the chart axis for more details.
2. Format value ranges differently
Another powerful trick to attain the attention of the audience and improve the effectiveness of your presentation is to use axis label formatting customized for the specific value ranges:
See Conditional formatting of chart axes for more details.
3. Format data ranges differently along the horizontal axis
Most reports and presentations contain a lot of boring charts that describe the state before and after some event, action, etc. However, using simple visual tricks, you can shake up the audience and draw attention to the essence of your presentation:
See How to add Dividers to the chart for more details.
4. Format data ranges differently along horizontal and vertical axes
Periodical processes like the volume of support service calls often have critical zones that indicate a severe problem that needs to be investigated and mitigated. The following tip shows how to reveal and emphasize those critical zones for analysis:
See Creating a chart with critical zones for more details.