Hi all,
I recently added some charts on my dashboard. If you've tried using bar charts with a mix of small and large numbers, the chart might not show the small figures making your chart useless. To make them all show up, change the left axis to logarithmic. It will throw an error message if a number is zero/negative. To avoid this, add if(your formula=0,0.9,your formula). This basically replaces the zero but will show up only as a small thin line in your bar chart close to 1 but should stop the zero error without distorting your chart. Unless you do want to show negative figures then use regular axis.
I recently added some charts on my dashboard. If you've tried using bar charts with a mix of small and large numbers, the chart might not show the small figures making your chart useless. To make them all show up, change the left axis to logarithmic. It will throw an error message if a number is zero/negative. To avoid this, add if(your formula=0,0.9,your formula). This basically replaces the zero but will show up only as a small thin line in your bar chart close to 1 but should stop the zero error without distorting your chart. Unless you do want to show negative figures then use regular axis.
