PC Review
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Charting
Re: Format Error Bars
Forums
Newsgroups
Microsoft Excel
Microsoft Excel Charting
Re: Format Error Bars
![]() |
Re: Format Error Bars |
|
|
Thread Tools | Rate Thread |
|
|
#1 |
|
Guest
Posts: n/a
|
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 |
|
![]() |
|
| Thread Tools | |
| Rate This Thread | |
|
|

Main Page 

