varying concentration levels 0.01-800

[cosmoherbs]

We are conducting a hair mineral analysis. The results are reported in ppm.
Certain products are present in higher ppm levels. For example calcium is in the range of 300-800 ppm. But certain minerals are present in trace levels. For example 0.02-0.08 rpm, in case of arsenic.
We want to show the concentration of all minerals using a single bar chart. In this case, since the arsenic is in low level, the bar chart will not show the arsenic concentration. Each and every mineral will have a varying concentration range. How to show all of them using the same bar chart

 

[VoG]

See if this helps http://www.tushar-mehta.com/excel/charts/plot_magnitude_differences.htm

 

[cosmoherbs]

Thanks for your help. The example you quoted is for 2 sets of variables namely ROI and turnover.

In my case. the element is plotted against concentration. The concentration of one element is 0.05 whereas anotehr element is 800.

When the y-axis values are taken acording to this vast range, the least value fails to show up in the graph.

Can u help me in this case

 

[northwolves]

In your case ,a Logarithmic or Semi-Logarithmic curve is helpful.