How to Create a Graph with Two sets of Ranges

[Atanu1000]

I want to create a graph in Excel where in I want plot a range of Prices from Jan to Dec 2020 and then also plot the range of the prices for the same item from Jan to Dec 2021 in the same Graph.

Kindly advise.

[#2]

@Atanu1000 A very crude example in the attached file.

[#3]

Hi @Atanu1000 

I attached a sample image of a double bar graph. Data refresh in chart automatically as you change your data selection.

You can check here for Microsoft Excel & Office 365.

And if you are comfortable with Google Sheets, you can find it here.

Thanks