Error bar

  • Thread starter Thread starter dennis
  • Start date Start date
D

dennis

Do anyone know how to change the width of the error bar freely out of
the three options available ?
 
Probably the "Y Error Bars" tab in the "Format Data Series" dialog box.
 
Stephen,

You are right. its the y- error bars. how can i set the width of the
drop line freely, for example, 6 pt, 10 pt or higher ?

dennis.
 
Well I just tried recording a macro while I changed the width and this is
what I got:

ActiveSheet.ChartObjects("Chart 1").Activate
ActiveChart.SeriesCollection(1).ErrorBars.Select
With Selection.Border
.LineStyle = xlContinuous
.ColorIndex = 57
.Weight = xlThick
End With
Selection.EndStyle = xlCap

If you look up the Weight property in the help text you will see that it has
only these 4 possible values:
xlHairline
xlThin
xlMedium
xlThick
 
Thks stephen.
But what i actually want is to build a histogram on a XY scatter
chart. i want to use the drop line as a histogram bar but even
..weight=xlThick is not wide enough. There any other way of doing that
?
 
You must log in or register to reply here.

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

how to add error bars into bar chart 1
Quick Access Tool Bar 1
Error bar 3
Setting Bar Width in a Bar Chart 1
What's new today? 7
Overflow error in Progress Bar 7
Excel Error bars on barplot not in series in excel 2016 0
ActiveX ProgressBar - Scrolling Error disables color update 1

Back
Top