Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How to customize error bars by VB code?
Hello NG,
from a Visual Basic (6) project, I need to customize the error bar of a chart, to get a different value for each data point. In Excel, this is done with a range reference: ActiveChart.SeriesCollection(1).ErrorBar Direction:=xlY, Include:= _ xlPlusValues, Type:=xlCustom, Amount:="=Hoja1!R1C3:R2C3" but I need to do this by VB code, in order to control a OLE-Chart. Reference to the datasheet-range is not working: oGraph.SeriesCollection(1).ErrorBar Direction:=xlY, Include:=xlBoth, _ Type:=xlCustom, Amount:=oGraph.Application.DataSheet.Range("A1:A3" ) Any ideas? Thanks in advance Miguel |
#2
|
|||
|
|||
MS Graph, while similar to XL, doesn't support the full capabilities of
XL. Custom error bars is one of the features supported by XL but not by Graph. -- Regards, Tushar Mehta www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article .com, says... Hello NG, from a Visual Basic (6) project, I need to customize the error bar of a chart, to get a different value for each data point. In Excel, this is done with a range reference: ActiveChart.SeriesCollection(1).ErrorBar Direction:=xlY, Include:= _ xlPlusValues, Type:=xlCustom, Amount:="=Hoja1!R1C3:R2C3" but I need to do this by VB code, in order to control a OLE-Chart. Reference to the datasheet-range is not working: oGraph.SeriesCollection(1).ErrorBar Direction:=xlY, Include:=xlBoth, _ Type:=xlCustom, Amount:=oGraph.Application.DataSheet.Range("A1:A3" ) Any ideas? Thanks in advance Miguel |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Make Change Case in Excel a format rather than formula | Excel Worksheet Functions | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) | |||
Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
Opening a file with code without a set file name | Excel Discussion (Misc queries) | |||
Error trapped only while stepping through the code - Not triggered when run | Excel Discussion (Misc queries) |