Suppose you have data across a time period to represent graphically, confiding each data point to a defined interval. As an instance, you might have to present customer survey results of a product from different regions. Band chart is suitable for this purpose.
A Band chart is a Line chart with added shaded areas to display the upper and lower boundaries of the defined data ranges. The shaded areas are the Bands.
Band chart is also referred to as Range chart, High-Low Line chart or Corridor chart.
Band chart is used in the following scenarios −
You need to prepare the data that can be used to create a Band chart from the given input data.
Step 1 − Consider the following data that you have from the customer survey for two regions – East and West across the financial year April - March.
Suppose you want to compare this data across three intervals −
Step 2 − Add three columns to the above table as shown below.
As you can observe, the values in the column Low are 50%, denoting the band 0% - 50% and the values in the column Medium are 30%, denoting the bandwidth of Medium above the band Low. further the values in the column high are 20%, denoting the band width of high above the band Low.
Use this data to create a Band chart.
Follow the steps given below to create a Band chart −
Step 1 − Select the data in the above table.
Step 2 − Insert a Combo chart.
Step 3 − Click on Change Chart Type. Change the chart types for the data series as follows −
Your chart looks as shown below.
Step 4 − Click one of the Columns.
Step 5 − Change Gap Width to 0% in the Format Data Series pane.
You will get Bands instead of Columns.
Step 6 − Make the chart appealing −
The result is a Band chart with defined boundaries depicted through bands. The survey results are represented across the bands. One can quickly and clearly make out from the chart whether the survey results are best or they need attention.
Your Band chart is ready.
Advanced Excel Charts Related Interview Questions
|MS Access Interview Questions||VBA For Excel Interview Questions|
|Microsoft Word Interview Questions||Microsoft Visual C++ Interview Questions|
|Excel Data Analysis Interview Questions||Excel pivot tables Interview Questions|
|Excel Power View Interview Questions||Microsoft Office 365 Interview Questions|
All rights reserved © 2020 Wisdom IT Services India Pvt. Ltd
Wisdomjobs.com is one of the best job search sites in India.