资讯

When you create a graph that includes dates, Excel 2013 automatically spaces the data in chronological order. This behavior potentially creates irregular spacing with unpredictable formatting.
Graphs in Microsoft Excel typically chart time on the horizontal axis. Time is the independent variable in most relationships and dependent variables appear on the vertical axis.
This article explains how to add a secondary axis to a chart in Excel so you can view unlike categories on the same graph. These instructions work in Excel in Microsoft 365, Excel 2021, Excel 2019 ...
If you have uneven distribution of data in your Excel chart, here is a better way to change the automatic axis settings.