29 October, 2022

Excel Secrets: Dates in Charts

Something strange happens with Excel charts when you create a chart based on data that include column of dates in the selected data range. Here is an example of simple data set I'm using as basis for my charts:

This is my first selected type of chart. Everything looks OK, dates on X axis are displayed correctly:

Now, when I create (or switch to) some different types of my chart, here's what I'm getting:

The X axis presents here completely different dates in different steps from those listed in my table. Why is this happening? Does anybody know? Is this one of Excel tricks?

For now just be aware of this abnormality and examine your charts well before using/publishing them.