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

Area chart

An area chart is essentially a line chart with the section below the line shaded or color-filled. This can be very useful when you want to emphasize both the absolute value of a time series and the trend pattern. The distinct fill below the line gives it a peak-and-trough design that makes it easy for users to recognize the absolute performance alongside the trend. The following screenshot shows an area chart for the same yearly sales data we plotted a line chart on earlier:

Figure 8.20 – Area chart of sales over a period

Figure 8.20 – Area chart of sales over a period

Things can be a bit tricky with using area charts for two or more metrics. See Figure 8.21 of the area chart of sales and expenses. Notice that the user could be confused about the actual value of sales and likely interpret it wrongly as it is stacked on the expense chart:

Figure 8.21 – Area chart of sales and expenses

Figure 8.21 – Area chart of sales and expenses

We will move on, now, to another chart.

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