View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Molly Molly is offline
external usenet poster
 
Posts: 25
Default Minimize range on vertical axis with large data gaps

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

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