MrExcel Publishing
Your One Stop for Excel Tips & Solutions

two series, one chart


Posted by nmn on December 06, 2001 12:11 PM

I have two data series I wish to plot on the same
chart. One has 12 points, x values from 1 to 12 (months) and the
other has 365 points, x values from 1 to 365 (days). Is there any
way I can plot them together so that the months match
up with the corresponding days?


Posted by Mark W. on December 06, 2001 1:13 PM

Why don't you transform your Months and Days to
datevalues? Use =DATE(2001,'Month',1) for your
Months. Use ='Day'+DATE(2001,1,0) for your Days.
Plot the data for Months and Days as separate
series on an XY (Scatter) Chart.