ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Graphing past months (totals) and current month (weekly total) in (https://www.excelbanter.com/charts-charting-excel/37292-graphing-past-months-totals-current-month-weekly-total.html)

Davin

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.

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.

"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