Understand Custom Axis Chart in Excel step by step example

Understand Custom Axis Chart in Excel step by step example

Dual Axis

Charts can be very useful while representing two different information on a single chart. Ideally these charts are represented with the help of Line Chart. In this article we will create a dual axis chart to represent Sales and Average Sale of each product.

Data Source

Steps to be performed

  1. Select above data
  2. Click on Insert tab
  3. Click on Line Chart under Charts group
  4. Select 2D Line chart as shown below
  5. Say OK

Format Axis

Select the axis that you would like to plot as secondary chart by clicking on the line and Right Click then select Format data series… from the popup as shown below:

A right panel will open to format the data series as shown below where you need to click on Series Options and select Secondary Axis as shown below:

Output

Next >> Remove Subtotal from Excel Sheet using code Excel Add-in

Leave a Reply

Your email address will not be published.