Columns Charts Excel

[Misterchipper]

Does anyone know how to "break" a columns chart in excel so that the large sales of 1 column don't skew teh cart so much?

For example, 1 column of sales is 9 Billion and the other 15 columns are all <2B--ergo, the other 15 columns look minute in comparision to the 9b( which they are). However, visually I want to show this.

Additionally, is there anyway to resort the series of a chart without changing the order in excel?

Thanks

Christian

 

[njimack]

Take a look at http://peltiertech.com/Excel/Charts/BrokenYAxis.html or http://www.andypope.info/charts/brokencolumn.htm

 

[RoryA]

You can reverse the order without altering the data, but that's it.
You could set the axis scale to logarithmic, or you could plot the large series on another axis. Failing that, you need some trickery - see Jon's site here.