Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
I'm using Jon Peltier's code to modify strings within charts;
For Each mySrs In ActiveChart.SeriesCollection strTemp = WorksheetFunction.Substitute(mySrs.Formula, OldString, NewString) mySrs.Formula = strTemp How do I use a similar approach to change strings for the error bar ranges? I'm having trouble referring to the error bars, and don't know how to define myError (dim mySrs as Series - what's the equivalent?) thanks, Andy |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
y error bars | Charts and Charting in Excel | |||
Customise error bars on individual bars in a bar chart 2007 | Charts and Charting in Excel | |||
Y error bars | Charts and Charting in Excel | |||
Replace Hyperlink Addresses Help 'Dim OldStr As String, NewStr As String | Excel Programming | |||
How do I replace last numeric string from a alphanumeric string? | Excel Discussion (Misc queries) |