Here is a common problem that can occur with some charts.
This also shows a way to use scatter charts that you might not have thought of. These charts are usually used to plot two sets of data against each other.
However you can also use these charts to plot one set of data against a timeline, for example.
What is nice about a scatter chart in this case is that it can straighten out a timeline.
The exercise and result are in the Chart Scatterfix file.
Here is a simple sales chart
While it may look like the sales growth is slowing down, looking closer at the years we can see it is an illusion- the interval was changed with the last two bars.
To fix this, change the chart to a scatter chart.
The beauty of the scatter chart is that it keeps the interval constant. As a result, you get the correct picture that the sales growth is actually increasing slightly.