Best practice to display a wide data range on a non-table view.

Question

Hi,

Currently, we are on 11.1.1.7.0.

I have developed a stacked vertical bar chart to display data by hour and various zones. The data range is wide (0.01 .. 500) and because of this, lower end stacks are not visible at all. I have tried zoom in along with scaling based on data, dynamic scaling and also specific scaling. There is no effect; the lower end stacks are still invisible at the highest zoom in. At times, horizontal stack bar seemed to have worked but that's too much work for the end user to go on zooming in and in. I have set canvas width to 1580 px and height to 480 px - that's the maximum I can set them to.

What could be the best approach for this scenario? Or, is there any system-wide parameter that can display the tiniest section on a chart?

Thank you.

Regards,

Manoj.

Manoj Dixit · Answer

Hi Christian,

Thank you for your reply. I referred to http://yangiiiyang.blogspot.co.uk/2012/05/chart-is-worth-thousand-words-only-when.html  to understand the logarithmic scaling. As per an example given, I changed my graph to line. This shows me a continuous line if there is any non-null value thereby indicating the user to zoom in if needed. Seems to be better than the bar graphs.

Thank you.

Regards,

Manoj.

Edit: The line graph and logarithmic scaling combination seems to be more appropriate.

[Deleted User] · Answer

Logarithmic scale ;-)

Manoj Dixit · Answer

Thanks Richard. I was also thinking something similar - 20/80 rule.