How do I create a break in a bar chart?

[arodz17]

Hi, I would like to create a break in an excel bar chart. I have a two sets of data; however one set is very large compared to the other. They need to be graphed together and at the same time be legible.

Thank you.

 

[NARAYANK991]

Hi ,

Please go through this :

http://peltiertech.com/broken-y-axis-in-excel-chart/

Narayan

 

[NARAYANK991]

Hi ,

If you still wish to go ahead and develop a broken Y-axis , see this :

https://alesandrab.wordpress.com/2014/03/17/broken-column-and-bar-charts/

Narayan

 

[Hui]

My favorite technique is that shown:
https://sites.google.com/site/e90e50fx/home/broken-line-panel-charts
Except that it isn't a Column Chart