| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Convert Chart Series Formula to Array Via VBA?
I am trying to convert the Chart series formula below to an array via VBA. I
have tried recording a macro and have had no success. I used the select series, click in the formula bar and hit F9 and this does not work. Can anyone help? Formula = "=SERIES(FirstFeltData!R1C65,FirstFeltData!R2C10:R 100C10,FirstFeltData!R2C66 :R100C66,1)" |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Convert Chart Series Formula to Array Via VBA?
Answered in the charting group.
- Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ Kevin G wrote: I am trying to convert the Chart series formula below to an array via VBA. I have tried recording a macro and have had no success. I used the select series, click in the formula bar and hit F9 and this does not work. Can anyone help? Formula = "=SERIES(FirstFeltData!R1C65,FirstFeltData!R2C10:R 100C10,FirstFeltData!R2C66 :R100C66,1)" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Convert the series to a formula | Excel Worksheet Functions | |||
| Array Formula for a Finite Series Sum ?? | Excel Worksheet Functions | |||
| Can I use an array formula as a series in an Excel chart | Charts and Charting in Excel | |||
| Extending a Chart Data Series from an Array - Can it be done? | Charts and Charting in Excel | |||
| Assign data to chart series, using array | Excel Programming | |||
![Kevin G[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
