Break in X Axis

I don't believe this is possible but what the hell...

I am currently using a 2 axis chart to show revenue and advisors - is on the Y Axis there is revenue and on the second Y axis there are advisors - all hunky dory.

I have also calculated revenue per advisor but this would fall on the revenue axis (as it is cash) but the figures are too small to be noticed, i want to create a break in the axis so that from say £0 - £5,000 is in small denominations, then a break to £500,000.

Any thoughts?

Sure it's possible. http://www.peltiertech.com/Excel/Charts/axes.html

hey great website - thanks!

Please let me know how to break X axis