This is how it would look if you added the market share data.

You can see that the axis have turned. The years are no longer on the X axis (horizontal). You could go to the Chart tools' Design tab and press the Switch Row/Column button to fix this. But there is another way to add data to a chart in Excel/2010.
Select the range of cells from A5 to D5.
Press on the keys CTRL and C.
Click on the chart.
Press on the keys CTRL and V.
As you can see, it's hard to interpret the Market share data series even when you try to compare it to values ranging from 15 to 40. Imagine, how hard it would be if the values where in the millions or more. In this case, adding a second axis from the Market share data is necessary. Here are the steps to activate it.

From the Chart tools' Layout or Format tabs, select the Series Market share.
Press the Format selection button.

From the Series Options category, select Secondary Axis.
Press the Close button.
 |
The secondary axis will appear on the right side of the chart. The values on it are in percentages compared to number on the axis on the left side of the chart. The problem in this present chart is that the Market share data series is now hiding the other values. The easiest way to settle this is to change the chart type for that data series. |
|