From: Doug on 27 May 2010 16:43 When I have the verticle axis set to automatic on the Min & Max range it usually shows a huge distance on the chart because it generally defaults to 0. If the data is 55-100, the chart will start at 0 at the bottom and the 55-100 will be toward the top scrunching the data. Seems like it should size up the data to best fit everything when on the auto setting. I don't want to use a fixed setting because if the data changes then I run into a similar problem. Is there a way to either change the default settings so the charts will automatically size themselves, or something else I can do to make this work for me? -- Thank you!
|
Pages: 1 Prev: Show zero value but hide NA Next: Ordering the chart by value |