Graphing past months (totals) and current month (weekly total) in
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. |
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. "Davin" wrote: 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. |
All times are GMT +1. The time now is 06:23 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com