PC Review Forums Newsgroups Microsoft Excel Microsoft Excel Charting Re: Format Error Bars

Reply

Re: Format Error Bars

 
Thread Tools Rate Thread
Old 22-09-2003, 02:47 PM   #1
Andy Pope
Guest
 
Posts: n/a
Default Re: Format Error Bars


Hi Andrew,

You could use additional data series to plot the end points of your
error bars. The additional series would have their line property set to
none, therefore only displaying markers.

You may have to adjust the actual error values by use of cell formulas.

Andrew wrote:

> I am comparing two sets of data with an xy scatter graph.
> It has magnitude on the y-axis and frequency on the x-axis.
>
> Both series have custom sets of error bars.
> One is formatted pink and the other blue and they stand
> out nicely.
> The problem comes when I print. You cant tell which error
> bar
> belongs to which series as they look the same and are on
> top
> of each other. I have to photocopy the work so colour
> printing
> isn't really an option. Is it possible to format the
> little
> lines at the end of the error bars so that they are a
> different
> shape or something?
>


--

Cheers
Andy

http://www.andypope.info

  Reply With Quote
Reply



Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is On
HTML code is Off