ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Scale numbers for Y Axis. (https://www.excelbanter.com/excel-worksheet-functions/166964-scale-numbers-y-axis.html)

PayPaul

Scale numbers for Y Axis.
 
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

Pete_UK

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




All times are GMT +1. The time now is 11:10 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com