How to Create a Graph with Two sets of Ranges

Question

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.

riny_van_eekelen · Answer

Atanu1000&nbsp;A very crude example in the attached file.&nbsp;

qaiser_j · Answer

Hi&nbsp;Atanu1000&nbsp;&nbsp;I attached a sample image of a double bar graph. Data refresh in chart automatically as you change your data selection.&nbsp;You can check here for&nbsp;Microsoft Excel &amp; Office 365.&nbsp;And if you are comfortable with Google Sheets, you can find&nbsp;it&nbsp;here.&nbsp;Thanks&nbsp;&nbsp;

Forum Discussion

How to Create a Graph with Two sets of Ranges

Share

Resources