From the course: Excel Quick Tips

Unlock this course with a free trial

Join today to access over 25,600 courses taught by industry experts.

Add totals to column charts using combo charts

Add totals to column charts using combo charts - Microsoft Excel Tutorial

From the course: Excel Quick Tips

Start my 1-month free trial Buy for my team

Add totals to column charts using combo charts

“

- [Instructor] Here, I created a regular column chart, but I can't find how to add the totals for my month, so I want to add these data labels on this chart right here. I will show you how. Click on your chart. You have this chart design tab that appears in the ribbon. Click on that. Then we're going to change the chart type. You can select the combo chart type down here, and as you can see at the bottom, I have my series name. I have January, February, and March, but I don't see the total, so let's fix that. Let's go back. Click cancel. I will first click on the switch row and column button and look at the chart while I click on this button, it's going to switch it up a little bit. Boom. Here we go. Now we have January, February, March, and we have this big blue total bar. That's not quite what we want. Let's go back in the chart design tab and click on change chart type, once again. Now in the combo menu, you can see that our series name have switch. We have all of our weeks, and we…

Contents