How To Create Stacked Bar Chart In Excel For Multiple Variant Values?

Asked By ChesterBSeverance 0 points N/A Posted on - 10/23/2017

Hello everyone,

Please help me through the process of creating a stacked bar chart in Excel. I have records of sales of every month of different years, and I’m little confused in comparing, so I thought of creating it, and the best chart I found was stacked bar graph, but I’m having some issues. So please guide me through the steps.

• Status: Open
• Question Views: 654
• Answer Count: 1
• Vote Up 0 Vote Down

• Answer Accepted: No
• Question Category: MS Excel
• Question Tags: bar chart | Excel

Answered By Hannah Bowman 0 points N/A #305091

How To Create Stacked Bar Chart In Excel For Multiple Variant Values?

Step1. Select the data of your Excel sheet.

Step2. Once you have highlighted the entire data click insert and in the chart, section chose the stacked chart.

Step3. Select the stacked chart under the bar category. Once you hit stacked chart, the chart will appear representing the comparison between the values.

Step4. You can change the color combination also by selecting it, and performing you required changes from the chart tools.

About Hannah Bowman

Questions
2

Answers
4

Best Answers
0

• Vote Up 0 Vote Down

• Posted on - 10/23/2017
• Question Category: MS Excel