Grand total line as a secondary axis to a clustered column

[auroraissccc]

Hello,



I need to make a combo chart for my table. Each week will have 5 clustered bars of Activity amount, then on the secondary axis, I want to show a line for the number of total activities per week.
I have tried to make a pivot table; Unit and Category under Filters, Discipline under Columns, Week under Rows, and Sum of Remain under Values. I have enabled the grand total for rows and columns as well.

But when I create the chart, I can't choose the Grand Total for the secondary line. Should I add a column, or make another helper table?

Also, if I want to make another chart to only show the difference amount of Activity done per Unit, Category, and Discipline each week what should i do?



Sorry if this sound trivial as I'm a beginner. Thank you!



here is a sample for my table.

 

[RoryA]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Grand total line as a secondary axis to a clustered column

Hello, I need to make a combo chart for my table. Each week will have 5 clustered bars of Activity amount, then on the secondary axis, I want to show a line for the number of total activities per week. I have tried to make a pivot table; Unit and Category under Filters, Discipline under...

www.excelforum.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[auroraissccc]

Welcome to the MrExcel Message Board!

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at:

Grand total line as a secondary axis to a clustered column

Hello, I need to make a combo chart for my table. Each week will have 5 clustered bars of Activity amount, then on the secondary axis, I want to show a line for the number of total activities per week. I have tried to make a pivot table; Unit and Category under Filters, Discipline under...

www.excelforum.com

There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

provide how?

the other link is this:

Grand total line as a secondary axis to a clustered column

Hello, I need to make a combo chart for my table. Each week will have 5 clustered bars of Activity amount, then on the secondary axis, I want to show a line..

techcommunity.microsoft.com