Excel only gives us the secondary vertical axis, and we really needed the secondary horizontal axis. So let’s assign the weekly data to the secondary axis (below left).
Show temperature in excel for mac series#
To get to Paste Special, on the Home tab, click on the Paste dropdown, select Paste Special, and make sure you’ve selected the settings below:Įxcel’s line charts use the same data for all series in the chart, or more precisely, for all series on a particular axis. 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. 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)
