If you have two series of data and one of the series is on a different scale, it might be impossible to interpret the smaller series.

Primary data is hidden behind secondary data1

Data in series A on the excel chart above is really hard to compare and analyze. You can solve this by moving series B to a secondary axis.

Add a secondary axis

  1. Right click on series B
  2. Click "Format Data Series..."
    Primary data is hidden behind secondary data2
  3. Select "Secondary Axis"
  4. Click Close button

Primary data is hidden behind secondary data3

If you are unlucky, one of the data series is hidden. In this case, series A is totally hidden behind series B, see chart above. You can change the transparency for series B but in my opinion it makes the chart better but not great.

Primary data is hidden behind secondary data4

Yes, you can see both data series but it is still a mess and the colors in the legend and the columns don't match, see chart above. Don't add transparency, try separating the two series instead. Instructions, below.

Add two blank series

This is the data I am working with.

Primary data is hidden behind secondary data5

Here is how to add a blank series.

  1. Right click on chart
  2. Click on "Select Data..."
  3. Click "Add" button
    Primary data is hidden behind secondary data7
  4. Select a blank cell range, in this case D2:D7
    Primary data is hidden behind secondary data8
  5. Click OK

Repeat step 3 - 6 to add a fourth blank series, you can use the same cell range. Then click OK button. The chart now looks like this:

Primary data is hidden behind secondary data10

Add space between columns series

  1. Right click on series A on the chart
  2. Click "Format Data Series..."
  3. Add "Gap width" to 400%
  4. Click OK

Primary data is hidden behind secondary data11

Customize legend

  1. Click on the empty legend entry and delete
  2. Do the same with Series4
  3. Move the legend below
  4. Add more descriptive text
  5. Delete grid lines

Primary data is hidden behind secondary data13

Download excel *.xlsx file

Primary data is hidden behind secondary data.xlsx