Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change errorbar series data from vba
I don't know if this can be done, but I'll ask the question.
I have a chart that I want to copy. The chart is an x-y scatter plot. The data supplied to the original chart and the copied chart are on the same sheet. The data from the first chart is in the first 60 rows, rows 1-60, and the data in the copied chart is in the next 60 rows, rows 61-120. I have developed a macro, where I ask the user what rows should be substituted in the copied chart. I then parse the formula of the data series and substitute the rows input by the user into the series formula. This has been successful. Of course the error bars still point to rows 1-60. I would like to be able to do something similar. Retrieve the error bar range reference, change the row references, and substitute the new range reference. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Change errorbar series data from vba
Unfortunately Excel does not expose the error bar source range to VBA. But
if you know the relationship between the data and the error bars, you can adjust the (for example) Y value range to reflect the error bar range. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions http://PeltierTech.com _______ "jnewby72" wrote in message oups.com... I don't know if this can be done, but I'll ask the question. I have a chart that I want to copy. The chart is an x-y scatter plot. The data supplied to the original chart and the copied chart are on the same sheet. The data from the first chart is in the first 60 rows, rows 1-60, and the data in the copied chart is in the next 60 rows, rows 61-120. I have developed a macro, where I ask the user what rows should be substituted in the copied chart. I then parse the formula of the data series and substitute the rows input by the user into the series formula. This has been successful. Of course the error bars still point to rows 1-60. I would like to be able to do something similar. Retrieve the error bar range reference, change the row references, and substitute the new range reference. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Change data series layout | Charts and Charting in Excel | |||
How to change the series order in a LEGEND ONLY...not data | Charts and Charting in Excel | |||
How do I change the shape of a data series | Charts and Charting in Excel | |||
?-Change data series range as data is entered? | Charts and Charting in Excel | |||
How do I change the order of the series in the Source Data? | Charts and Charting in Excel |