Using the combination chart
With the combination chart you are able to use both columns and lines to visualize data in one single chart.
Getting ready
Open a new Dashboard Design file and enter the data into the spreadsheet as shown in the following screenshot:
Use the Percent Style option to convert the market share values into percentages. You can find this option in the Number section of the Home tab of the toolbar.
How to do it...
- Drag a Combination Chart component to the canvas.
- Bind the Chart field to cell A1 and the Subtitle field to cell B2.
- Bind the By Range field to the spreadsheet range from A4 to E6.
- Select By Series and select the Market Share series. Select the option to Plot Series On: Secondary Axis.
How it works...
After binding the data to the component, we had to adjust the Market Share series to plot its data on the secondary axis. After doing this, a second y-axis appeared on the right-hand side of the chart, labeled with percentages.
There is more...
In the Series sub-tab within the Appearance tab of the properties pane, you can determine how each series should look—either a column or a line. Here, you can also set the series colors and Marker Shape, Size, and Transparency.
