[Reader Poll] Stacked, Seperated or Mirrored ?

Share

Facebook
Twitter
LinkedIn

Stacked bar(column) charts are a popular way to depict 2 more series of related data, like sales of 2 products.

But there are several ways to stack the bars in a bar chart. Here is a list of 6 ways to stack them

1. One on top of another

1. One on top of another

Advantages: Easy to create, takes less space

Drawbacks: Hard to compare, only first value starts at zero

2. Separated

2. Separated

Advantages: Easy to read and compare

Drawbacks: takes more space, needs extra calculation for the gap series

3. Mirrored:

3. Mirrored:

Advantages: looks fancy and takes less space, good for large data sets

Drawbacks: needs extra calculation

4. Partially Overlapped

4. Partially Overlapped

Advantages: Easy to compare, Easy to make

Drawbacks: One series dominates another, good where domination is needed (like this vs. last year)

5. Completely Overlapped

5. Completely Overlapped

Advantages: easy to compare

Drawbacks: Needs extra formatting, not always produces good results

6. Hanged from Top and Bottom

6. Hanged from Top and Bottom

Advantages: none

Drawbacks: difficult to compare, needs extra formula to calculate gap series

I like 2 and 5 and use them whenever I can.

What about you? How do you like your bars?

PS: for the purpose of discussion neglect other important chart elemets like labels, colors etc.

Facebook
Twitter
LinkedIn

Share this tip with your colleagues

Excel and Power BI tips - Chandoo.org Newsletter

Get FREE Excel + Power BI Tips

Simple, fun and useful emails, once per week.

Learn & be awesome.

Welcome to Chandoo.org

Thank you so much for visiting. My aim is to make you awesome in Excel & Power BI. I do this by sharing videos, tips, examples and downloads on this website. There are more than 1,000 pages with all things Excel, Power BI, Dashboards & VBA here. Go ahead and spend few minutes to be AWESOME.

Read my storyFREE Excel tips book

Overall I learned a lot and I thought you did a great job of explaining how to do things. This will definitely elevate my reporting in the future.
Rebekah S
Reporting Analyst
Excel formula list - 100+ examples and howto guide for you

From simple to complex, there is a formula for every occasion. Check out the list now.

Calendars, invoices, trackers and much more. All free, fun and fantastic.

Advanced Pivot Table tricks

Power Query, Data model, DAX, Filters, Slicers, Conditional formats and beautiful charts. It's all here.

Still on fence about Power BI? In this getting started guide, learn what is Power BI, how to get it and how to create your first report from scratch.

One Response to “Loan Amortization Schedule in Excel – FREE Template”

  1. Ag says:

    The balance formula as given doesnt seem to work on my excel

Leave a Reply