Reader small image

You're reading from  Building Interactive Dashboards in Microsoft 365 Excel

Product typeBook
Published inFeb 2024
PublisherPackt
ISBN-139781803237299
Edition1st Edition
Tools
Right arrow
Author (1)
Michael Olafusi
Michael Olafusi
author image
Michael Olafusi

Michael Olafusi is a 9x Microsoft Most Valuable Professional (MVP) and a business intelligence consultant. He is the lead consultant and founder of MHS Analytics Inc. in Canada and UrBizEdge Limited. He has been consulting for clients across North America, Europe, and Africa on data analysis, business intelligence, and financial modeling for the past 10 years. Outside of his consulting business, he is a member of Rotary and the Southern Cruisers Riding Club (SCRC) Chapter 373. He is a proud member of the Canadian Red Cross friendly calls volunteer team. He is also a faculty member at WorldQuant University, USA.
Read more about Michael Olafusi

Right arrow

Bar chart

A bar chart is a variant of a column chart – same use case and same design options. The main difference is that a bar chart has horizontal bars while a column chart has vertical bars. Bar charts can be a more user-friendly chart to use when you have long axis labels and making them show in the horizontal orientation is far better than having them slant at an angle. In Figure 8.9, you’ll see how a bar chart handles long axis labels compared to how a column chart handles the same in Figure 8.10:

Figure 8.9 – Good handling of long axis labels by a bar chart

Figure 8.9 – Good handling of long axis labels by a bar chart

The handling of the same long axis label by a column chart is shown as follows. Do, however, note that if the width of the column chart is made wider, it may eventually display the labels horizontally as preferred:

Figure 8.10 – Poor handling of long axis labels by a column chart

Figure 8.10 – Poor handling of long axis labels by a column chart

Another advantage of a bar chart is that for instances when...

lock icon
The rest of the page is locked
Previous PageNext Page
You have been reading a chapter from
Building Interactive Dashboards in Microsoft 365 Excel
Published in: Feb 2024Publisher: PacktISBN-13: 9781803237299

Author (1)

author image
Michael Olafusi

Michael Olafusi is a 9x Microsoft Most Valuable Professional (MVP) and a business intelligence consultant. He is the lead consultant and founder of MHS Analytics Inc. in Canada and UrBizEdge Limited. He has been consulting for clients across North America, Europe, and Africa on data analysis, business intelligence, and financial modeling for the past 10 years. Outside of his consulting business, he is a member of Rotary and the Southern Cruisers Riding Club (SCRC) Chapter 373. He is a proud member of the Canadian Red Cross friendly calls volunteer team. He is also a faculty member at WorldQuant University, USA.
Read more about Michael Olafusi