Select and copy the weekly data set, select the chart, and use Paste Special to add the data to the chart (below right). Excel has detected the dates and applied a Date Scale, with a spacing of 1 month and base units of 1 month (below left). Start by selecting the monthly data set, and inserting a line chart.
#Plot 2 graph in excel for mac series#
When plotted in separate Excel line charts, this is how it looks.ĭisplaying Multiple Time Series in A Line Chart Line Chart 1 – Plot by Month I’ve generated the following arbitrary monthly and weekly data for this exercise. 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 kommentar(er)
