Adding Secondary Axis on Excel for Column chart

Pictures don't really help us help you, because they don't allow us to see what you have tried and where you are going wrong. Can you describe the steps you are taking to create this chart and what is going wrong when you use those steps? Can you upload a sample Excel file to the forum (go advanced -> Manage attachments)?

The key steps I would have expected:
1) How to add a secondary axis to a chart: https://support.office.com/en-us/art...rs=en-US&ad=US
2) Because that step will likely place one series in front of the other rather than alongside the other, you will need to add blank rows/columns to "stagger" the data.

Please Login or Register  to view this content.

What did you try? Does it work if you try these?

Step 4 from the help file:

Originally Posted by Excel help

4. Under Choose the chart type and axis for your data series, check the Secondary Axis box for each data series you want to plot on the secondary axis, and then change their chart type to Line.

will create a combination chart. However, you are not obligated to change the chart type to line, so you could just check the box for the series you want to be on the secondary axis. That and the adjustments to the data layout I proposed should give the result you show in your picture.

I won't have an opportunity to upload a file for about 24 hours.

I tried making both of them as column then the bar are overlapping over each other.

That sounds like you followed my step 1 from post #2, but ignored or neglected step 2. You need both parts to get the chart you show in your picture.

If it helps and does not add confusion, this tutorial illustrates the data layout I am envisioning https://peltiertech.com/clustered-st...mn-bar-charts/ If you can think of your chart as a "clustered and stacked column chart with only one stack per cluster and one of the stacks on the secondary axis", that should be a useful tutorial for you.