Scale with a Break

[Tin Cup]

Hi All:

I am doing a bar chart that has individual data points and then a
cumulative. The data looks close to this

A = 10
B= 150
C= 120
D=.....

Total = 1000

So when I put all of them together the low values really get squished. I was
wondering if there is a way to show a scale on the axis for say 0- 200 and
then a break like two squiggly lines (~) on y axis and start scale at say
900. or even if I could do two scales.

 

[Andy Pope]

Hi,

Have a look at these examples,

(http://www.geocities.com/jonpeltier/Excel/Charts/BrokenYAxis.html)
(http://www.andypope.info/charts/brokencolumn.htm)

For line chart see,
(http://www.tushar-mehta.com/)

Hi All:

I am doing a bar chart that has individual data points and then a
cumulative. The data looks close to this

A = 10
B= 150
C= 120
D=.....

Total = 1000

So when I put all of them together the low values really get squished. I was
wondering if there is a way to show a scale on the axis for say 0- 200 and
then a break like two squiggly lines (~) on y axis and start scale at say
900. or even if I could do two scales.

--

Cheers
Andy

http://www.andypope.info