Forcing the scale on charts
I have 3 charts all showing sales for a specific salesperson.
I'm wondering if it's possible to force the scale on the Y axis of the charts so that i can see sales comparably.
Right now, the Y axis is set to their sales numbers. The problem is that all of the salespeople bring in completely different numbers.
So Tom brings in $600K a month, Bob brings in $200K a month and Sam brings in $20K per month. So right now, since the Y axis is showing their sales, Tom's range on the Y axis is $100K, $200K, $300K and so on...and Sam's range would be $10K, $20K, $30K and so on...
So when you just glance at the charts, it looks like they are almost doing to same number. You have to recongize that the scales are different in order to know that Tom brings in more sales.
Open Chart Setup, click format chart and select the Y-Axis. There's a setting where you can specify maximum and minimum scale values.