LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #6   Report Post  
Posted to microsoft.public.excel.charting,microsoft.public.excel.programming
external usenet poster
 
Posts: 5
Default Error bars in VBA

Thanks for the help everyone. Come to find out that when you try and do
an Include:=xlErrorBarIncludeBoth or Include:=xlBoth (which is the same
thing as far as I can see) with the Type:=xlCustom you must include
both the Amount:= (for the positive directions) and the MinusValues:=
(for the negative directions) even if you want to use the same values
for both the plus and minus of the error bars. So that was what I was
leaving out. Thanks again.

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Error bars alex Excel Discussion (Misc queries) 0 January 6th 10 08:29 AM
Error bars alex Excel Discussion (Misc queries) 1 January 6th 10 03:46 AM
y error bars greg Charts and Charting in Excel 3 July 16th 09 10:10 AM
Customise error bars on individual bars in a bar chart 2007 Millie Charts and Charting in Excel 2 April 25th 09 04:16 AM
error bars W Chamberlain Charts and Charting in Excel 1 September 24th 07 09:05 AM


All times are GMT +1. The time now is 03:34 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"