Scale of report different from previous data
I'm working off a report for staffing ratio averages. 30-60-90 show the scale based on 20 as top, but then 120 moved the top to 50, making the bar shorter instead of fuller. How do I get the 120 scale the same as the others? These auto populated, I did not select what scale was basis.
Answers
-
There is currently no way to adjust scales manually. This is done automatically.
You are going to need to add another column to each chart. I usually just call it "." without the quotes so that it is small and not very noticeable.
This column would be populated with the same number for each of the graphs you have displayed (higher than the existing data). Add this to your graphs and change the series to white so that the column is hidden, and this should adjust your axis scaling so that they are all the same.
