Bar Chart - Handling big variance of values [message #903360] |
Thu, 23 August 2012 10:41  |
Ricardo Rodrigues Messages: 15 Registered: July 2012 Location: Ireland |
Junior Member |
|
|
For big variances of values (see example attached) using a bar chart, the bars with lower value are for some chart sizes not displayed or almost not visible.
Is there any solution for this, like set minimum bar height or introduce a squiggly line in the middle of the Y axis so that the majority of the values can be looked properly, regarding the example attached we could have <500 items completed and >9000 items completed
Thanks
[Updated on: Thu, 23 August 2012 10:42] Report message to a moderator
|
|
|
Re: Bar Chart - Handling big variance of values [message #903438 is a reply to message #903360] |
Thu, 23 August 2012 15:53   |
|
Ricardo
Currently we do not have a tear style chart, but have you looked at
using a logarithmic scale? Select the y-axis on the third tab of the
chart wizard and change the type from linear to logarithmic.
Jason
On 8/23/2012 6:41 AM, Ricardo Rodrigues wrote:
> For big variances of values (see example attached) using a bar chart, the bars with lower value are for some chart sizes not displayed or almost not visible.
>
> Is there any solution for this, like set minimum bar height or introduce a squiggly line in the middle of the Y axis so that the majority of the values can be looked properly, regarding the example attached we could have <500 items completed and >9000 items completed
>
> Thanks
>
|
|
|
|
Powered by
FUDForum. Page generated in 0.31248 seconds