Scale with a Break

  • Thread starter Thread starter Tin Cup
  • Start date Start date
T

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.
 
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/)

Tin said:
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.
Click to expand...

--

Cheers
Andy

http://www.andypope.info
 
Back
Top