View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
NTE
 
Posts: n/a
Default Custom error bars not working

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