I'm having some trouble getting my charts to show up like I want them.
I'm graphing percentage increases and generally the numbers are between 60 and 150. However, sometimes there's numbers like 200, 300 and a small few numbers as high as 5000.
I want my graph to auto scale the y axis if the numbers are reasonably small (most of them are) but I'd like to set a cut off point at the high end if the data set being graphed includes one of the outliers. So I want it to auto scale but not any higher than, say, 300. Is there any way to do this?
I'm graphing percentage increases and generally the numbers are between 60 and 150. However, sometimes there's numbers like 200, 300 and a small few numbers as high as 5000.
I want my graph to auto scale the y axis if the numbers are reasonably small (most of them are) but I'd like to set a cut off point at the high end if the data set being graphed includes one of the outliers. So I want it to auto scale but not any higher than, say, 300. Is there any way to do this?