View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Pete_UK Pete_UK is offline
external usenet poster
 
Posts: 8,856
Default Scale numbers for Y Axis.

A lot depends on if you want to show zero or not. What is the smallest
number you have?

Pete

On Nov 21, 4:41 pm, PayPaul wrote:
How do I know what numbers to put into the Major Unit, Minor Unit, minumum
and maximum fields to get the a visual result on a chart that isn't too
broad. My largest number in the data is something around 3000. I'm trying to
illustrate the number of users in a 3rd quarter report for multiple companies
in multiple regions. I also have different products but I would put those
products on different charts. Can someone help me figure out these figures?

Thanks,

Paul