microsoft-excel-training - Two data series on one bar graph

Hello Paru

Thank you for your question regarding usingin two data axes on a chart in Microsoft Excel. The way to do this is pretty simple.

When the values in a 2-D chart vary widely from data series to data series in a 2-D chart, or when you have mixed types of data (such as price and volume), you can plot one or more data series on a secondary value (y) axis. The scale of the secondary axis reflects the values for the associated data series.

On the chart, click the data series that you want to plot along a secondary value axis.
On the Format menu, click Selected Data Series.
On the Axis tab, click Secondary axis.

I hope this resolves your question. If it has, please mark this question as resolved.
If you require further assistance, please reply to this post. Or perhaps you have another Microsoft Excel question?

Have a great day.
Regards,

Richard
Microsoft Office Specialist Trainer

Hello Paru

Add both series to the chart at the beginning of the chart.

Once you have both on the chart, then select the one you want to add the second axis for.

Regards,

Richard
Microsoft Office Specialist Trainer