Hi,

I am making a bar graph on an Excel file, one bar is out of scale while the other is so tiny to see. For example, on bar 1 for this month sale of $100, bar 2 for last month sale of 50 cents. I try to show them in one graph as a comparison, then the 50-cent bar is so tiny if the 100-dollar bar is still in the graph.
Is there any way that I can make the 50-cent bar larger while the 100-dollar bar is still in scale?

Please help. Thank you very much.