Creating a Bar Chart with a Broken X-Axis

Is it possible to create a bar chart with a broken X-axis? I found Peltier's nifty broken Y-axis instructions and have created a column chart using it. I've seen it posted that the method can be used to create a broken x-axis as well, but have not been able to figure out how.

However, I think a bar chart would be better to display the info, but cannot get the markers that would allow me to break the axis to display on the x-axis. They just scatter straight to the y.

Any advice would be aprpeciated.

I'm really new to forums like this. How can I insert a picture?

Thanks!

Hi,

I actually figured it out. I couldn't see the scatter points on the x axis because the y axis points were set to 0. I changed one of them to 500 to find the rest and was able to get the technique to work.

Thanks so much!
Elizabeth

Could you please explain how you solved this to save me starting another new thread?

Does this post solve your issue?

Excel Chart: Broken bar chart to avoid browning from very large values

http://www.ucmapi.com/chart/broken-bar.php