Hi,

Now Jon has sorted you error bar problem I will try with the offset one :)

Add a secondary data series and change the chart type to xy scatter.
Try the following values for the X-values
1.2
2.2
3.2
4.2
5.2
6.2
7.2

You may find turning off the Log scale while you do this makes it clearer.

Cheers
Andy

NTE wrote:
Jon,
thank you ever so much for your reply. I tried it and it
works..........

I now have points with error bars representing the max and mins. Looks
just like what we wanted!

I have a second question, and I've spent most of the day on your web
page and this group trying to figure out if there is an answer (if you
prefer a sepearate posting, let me know).

The data represented above is from a natural source. We also want to
plot data for a man made source--so for each category (e.g. Na) there
is going to be another median, min, max. We want this to appear BESIDE
the natural data, not in line with it (and hence overlapping). I've
read in this group about offsetting a series, but there seems to be no
easy way to do it. I'm guessing with the categorical x axis that this
will be hard to accomplish?

Many thanks again for the solution.
Nicole


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info