Bar chart with broken or jagged line on Y-Axis
 

Hello All,

This is more complicated chart than I am used to working on, so any
assistance will be appreciated.

Here is my data:

Frequency of Drinks Heterosexual Bisexual Lesbian
None/<1/month 77.45 66.36 67.83
1-3/month 9.92 14.09 9.84
1/week 3.02 2.27 5.53
2-4/week 5.72 9.09 7.38
5-6/week 2.4 3.64 4.92
7-13/week 1.11 4.09 2.25
14-24/week 0.29 0.45 2.05
25-39/week 0.06 0 0
40+/week 0.03 0 0.2

I would like to change the y-axis scale so that it jumps from 20% to
60% and doesn’t show the in-between values. I think when graphs
usually do this the y-axis has a jagged or broken line in the middle
to show that those values are not displayed.

Thanks!
Kim

Bar chart with broken or jagged line on Y-Axis
 

Jon Peltier provides instructions on how to create this kind of chart on his
website:
http://peltiertech.com/Excel/Charts/BrokenYAxis.html

Hope this helps,

Hutch

" wrote:

Hello All,

This is more complicated chart than I am used to working on, so any
assistance will be appreciated.

Here is my data:

Frequency of Drinks Heterosexual Bisexual Lesbian
None/<1/month 77.45 66.36 67.83
1-3/month 9.92 14.09 9.84
1/week 3.02 2.27 5.53
2-4/week 5.72 9.09 7.38
5-6/week 2.4 3.64 4.92
7-13/week 1.11 4.09 2.25
14-24/week 0.29 0.45 2.05
25-39/week 0.06 0 0
40+/week 0.03 0 0.2

I would like to change the y-axis scale so that it jumps from 20% to
60% and doesnt show the in-between values. I think when graphs
usually do this the y-axis has a jagged or broken line in the middle
to show that those values are not displayed.

Thanks!
Kim

Bar chart with broken or jagged line on Y-Axis
 

On Jun 30, 1:05*pm, Tom Hutchins
wrote:
Jon Peltier provides instructions on how to create this kind of chart on his
website:http://peltiertech.com/Excel/Charts/BrokenYAxis.html

Hope this helps,

Hutch



" wrote:
Hello All,

This is more complicated chart than I am used to working on, so any
assistance will be appreciated.

Here is my data:

Frequency of Drinks * * * *Heterosexual * *Bisexual * * * *Lesbian
None/<1/month * 77.45 * 66.36 * 67.83
1-3/month *9.92 * *14.09 * 9.84
1/week * * 3.02 * *2.27 * *5.53
2-4/week * 5.72 * *9.09 * *7.38
5-6/week * 2.4 * * 3.64 * *4.92
7-13/week *1.11 * *4.09 * *2.25
14-24/week 0.29 * *0.45 * *2.05
25-39/week 0.06 * *0 * * * 0
40+/week * 0.03 * *0 * * * 0.2

I would like to change the y-axis scale so that it jumps from 20% to
60% and doesn’t show the in-between values. *I think when graphs
usually do this the y-axis has a jagged or broken line in the middle
to show that those values are not displayed.

Thanks!
Kim- Hide quoted text -

- Show quoted text -

Thanks Hutch. This is exactly what I'm looking for!