off-setting points of different series b/c error bars overlap

G

Guest

I'm constructing a line chart with six series and categorical values on the
x-axis. I'm including y error bars that highly overlap and are very
difficult to read b/c all points within a given category are automatically
stacked vertically on top of one another. Is there a way to off-set the
series to make the error bars more visible? Hope this makes sense. Cheers.
 
A

Andy Pope

Hi,

I think you would have to use an xy scatter to get the offsets.
You should be able to combine Line and xy scatter to get the Category x
axis labels and the offsetting. If not you will need to construct the x
axis using a dummy data series.

Here is some info on constructing you own axis just in case.
http://peltiertech.com/Excel/Charts/ArbitraryAxis.html

Cheers
Andy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Removing overlap of bars when 2 Y axes are used 1
Adding a series to an existing Stacked Bar Chart 1
y-error bars on data points within a series 1
Excel Excel prob. with two series on one line chart 6
Change colour of bars/lines in charts when data in rows/colums 10
Problems Loading Large String Array into Array variable 6
Dump of perfection Test 1
OFF TOPIC:Censorship By Google Groups Of My Post About Gordon Sauck Being A Police Agent 1

Top