Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Stacked Column - format top line to be jagged | Excel Discussion (Misc queries) | |||
TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS | Charts and Charting in Excel | |||
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis | Charts and Charting in Excel | |||
Broken Y Axis in Line Chart | Charts and Charting in Excel | |||
"Broken" chart axis for data of different scales | Charts and Charting in Excel |