In ArcMap I have to represent water data that has extreme disrepencies between the figures, so when I create a bar graph one graph is much larger than the others. Even if I convert these figures to a percentage it is 99% versus the others which are less than 1%. The only thing I can think of is to use pie charts of the same size, but then this doesn't show the visual aspect of the differences between figures by looking at it (e.g that one uses more water than the others).
Does anyone have better ideas on how to represent this data using ArcGIS 10.1 for Desktop?
also is there a way to move the placement of the charts so they don't cover my reservoirs?
example data: reservoir a. 300,000 ML used 250,000 unused reservoir b. 700ML used 10ML unused
update - I cannot remove the outlier because I have 9 regions, all with outliers that have higher amounts of water than the others. The only thing I can do is change the size of the pie chart based on a field but this causes some pie charts to be tiny dots, so I have had to create a ratio based on a scale to represent my figures.
I would have liked if it there was more I could do with charts, I can't label them and I would have liked to use the thickness slider bar in 3d pie charts as a field - so the height of the pie charts would change based on a figure. I create a label based on my layer but these get covered by the pie charts, the only thing I can do is set an offset.