To add the bar chart with the top 10 customers by sales $ to the sheet, carry out these steps:
- Before adding the bar chart, resize the pie chart by reducing the width and making room for the new chart on the right-hand side of the screen:
- Click on the Charts button that lies on the asset panel, which is on the left-hand side of the screen, to open the chart selector panel.
- Click on Bar chart and drag and drop it into the empty space in the center of the sheet:
- Click on the Add dimension button and select the Customer option in the Dimensions section.
- Click on the Add measure button and select Sales $ in the Measures section.
- The bar chart will look like this:
To enhance the presentation of the chart, we will limit the number of customers that are depicted in the chart to 10, and add a title to the chart.
To limit the number of customers, do the following:
- Select Data in the properties panel on the right-hand side of the screen and expand the Customer dimension.
- Set the Limitation values as Fixed number, Top and type 11 in the limitation box:
We need to set the limit to 11. This will show the first 10 bars for the customer name, and the last will be the others bar, grouping all of the other customers.
- Click on the title of the chart and type Top 10 Customers by Sales $.
- Click on Done to enter the visualization mode. The bar chart will look like this:
Note that the gray bar depicts the values for others. You can eliminate the Others bar by deselecting the Show Others property in the Customer dimension.