LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #2   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 182
Default Minimize range on vertical axis with large data gaps

Molly wrote on Fri, 7 Jul 2006 05:54:02 -0700:

M I am tracking the percent of sales by product catagory for a
M company. They have low percents for everything but one
M area. I mean, most product areas are less than 10% while
M one is 60%. I want to remove the distance between the 60%
M product catagory and all the others but still showing
M accurate data.

M I would like to remove 20% - 50% since there is no data for
M that area. Is that possible?

Jon Peltier gave an answer a few weeks ago under "Showing a
break on the y-axis":


http://peltiertech.com/Excel/Charts/BrokenYAxis.html


James Silverton.

 
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
How to Match and Sort two range of data? Tan New Users to Excel 1 March 5th 06 10:30 PM
From several workbooks onto one excel worksheet steve Excel Discussion (Misc queries) 6 December 1st 05 08:03 AM
Dynamic Data Range dallin Excel Worksheet Functions 4 November 21st 05 07:21 PM
Data range properties baz Excel Discussion (Misc queries) 1 April 1st 05 09:37 AM
data range properties baz Excel Discussion (Misc queries) 0 April 1st 05 08:53 AM


All times are GMT +1. The time now is 07:12 PM.

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"