Graphing past months (totals) and current month (weekly total) in

[Davin]

I am trying to put January thru June data in a line graph (no problem) but
the boss now wants to see the current month, by week, on the same chart.
Is this possible?

Any help would be greatly appreciated.

 

[bj]

Add the weekly data to your chart.
Select it and change axis to secondary
<chart><chart options><axis> and select show second x axis.
format your chart as you want.