LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Stacked Column - format top line to be jagged KMiles Excel Discussion (Misc queries) 1 January 25th 07 05:21 AM
TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS vijaicbe Charts and Charting in Excel 4 November 9th 06 10:16 AM
Pivot Table, Line Chart with Secondary Y axis, Page Field selection destroys Y2 axis [email protected] Charts and Charting in Excel 0 July 13th 05 09:30 PM
Broken Y Axis in Line Chart raycyn.wright Charts and Charting in Excel 1 May 22nd 05 01:56 PM
"Broken" chart axis for data of different scales Charlie Charts and Charting in Excel 2 April 28th 05 12:23 AM


All times are GMT +1. The time now is 06:16 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"