Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error bar
Do anyone know how to change the width of the error bar freely out of
the three options available ? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error bar
Dennis,
What is the "error bar"? -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "dennis" wrote in message om... Do anyone know how to change the width of the error bar freely out of the three options available ? |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error bar
Probably the "Y Error Bars" tab in the "Format Data Series" dialog box.
"Chip Pearson" wrote in message ... Dennis, What is the "error bar"? -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "dennis" wrote in message om... Do anyone know how to change the width of the error bar freely out of the three options available ? |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error bar
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. "Stephen Bye" <. wrote in message ... Probably the "Y Error Bars" tab in the "Format Data Series" dialog box. "Chip Pearson" wrote in message ... Dennis, What is the "error bar"? -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "dennis" wrote in message om... Do anyone know how to change the width of the error bar freely out of the three options available ? |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error bar
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 "dennis" wrote in message om... 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. "Stephen Bye" <. wrote in message ... Probably the "Y Error Bars" tab in the "Format Data Series" dialog box. "Chip Pearson" wrote in message ... Dennis, What is the "error bar"? -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "dennis" wrote in message om... Do anyone know how to change the width of the error bar freely out of the three options available ? |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Error bar
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 ? "Stephen Bye" <. wrote in message ... 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 "dennis" wrote in message om... 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. "Stephen Bye" <. wrote in message ... Probably the "Y Error Bars" tab in the "Format Data Series" dialog box. "Chip Pearson" wrote in message ... Dennis, What is the "error bar"? -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "dennis" wrote in message om... Do anyone know how to change the width of the error bar freely out of the three options available ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Error: "Excel encountered an error and had to remove some formatti | Excel Discussion (Misc queries) | |||
Counting instances of found text (Excel error? Or user error?) | Excel Worksheet Functions | |||
I have Error 1919 Error Configuring ODBC dataSource Database | Excel Discussion (Misc queries) | |||
Automation Error, Unknown Error. Error value - 440 | Excel Programming |