![]() Perhaps you have daily temperature readings you want to plot against historic monthly temperatures. While the data may span a similar range of dates, the different data sets may have varying intervals between recorded values. The usual problem here is that data comes from different places. ![]() Displaying Multiple Time Series in An Excel Chart I could write a book just on this subject. XY Scatter charts are different: X axes behave like Y axes. Any of the formatting described here applies to all of these chart types. Date Axis formatting is available for the X axis (the independent variable axis) in Excel’s Line, Area, Column, and Bar charts for all of these charts except the Bar chart, the X axis is the horizontal axis, but in Bar charts the X axis is the vertical axis. This discussion mostly concerns Excel Line Charts with Date Axis formatting. Displaying multiple time series in an Excel chart is not difficult if all the series use the same dates, but it becomes a problem if the dates are different, for example, if the series show monthly and weekly values over the same span of time. The current article describes a special case of this, in which the X values are dates. I recently showed several ways to display Multiple Series in One Excel Chart.
0 Comments
Leave a Reply. |