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...

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.