Raj Excel: December 2014

When the Chart values vary widely from data series to data series, or when you have mixed types of data (for example, units and volume), you can plot one or more data series on a secondary vertical (value) axis. The scale of the secondary vertical axis reflects the values for the associated data series.

After you add a secondary vertical axis to a Clustered column chart, you can also add a secondary horizontal (category) axis, which may be useful in an xy (Line) chart.

To help distinguish the data series that are plotted on the secondary axis, you can change their chart type. For example, in a column chart, you could change the data series on the secondary axis to a line chart.

Type your data as required

Select the data for making the primary chart

In Microsoft Excel 2013 have only smart tag for some new options, Select the smart tag and click the charts

Select the Clustered Column Chart

When you select he chart the new Chat tab appear on Tab panel go to Design tab and select the chat style as you like

One normal Primary chart is completed

Let’s start to add the Secondary chart

Select the chart anywhere

and right click and Click the Select Data

After the select Data the new dialog bar popup on screen as show in below figure>

Click the Add button

And select the Series name

In Series name select the Units

And the series values select the Units data Jan to May

And click OK

After the Add a new series the graph is too small because the value of this cart is low as alphabetically.

This second series chart is also part of Primary chat lets change it to Secondary chart

Select the second chat

In Microsoft Excel 2013 the new option of Graph design appear on Right side of Screen

Select the Series Option and Click the Secondary Chat

Now this chart is Secondary chart. Let’s change the chart Type.

Goto Layout Tab and select the Change Chart Type

After you click the Change Chart Type the new dialog box popup the screen. As same shown in picture below.

Drop down box and select the Line Chart

You can also change the Axis to make a secondary chart just click the check box

Now finally this chart have two type of Chart Primary and secondary.

In This chart you will see the two Axis on in Right side and another is on Left side.

In Right side is the Secondary and left side axis for Primary Chart