| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Problem with Excel97/Chart/Formula
Hi!
I have an application written in VB 6.0 in which I am creating an Excel Chart. The code below works fine with Excel 2003, but it fails on Excel 97. Set xlsSeries = ActiveChart.SeriesCollection.NewSeries xlsSeries.Formula = sFormula Any Ideas? Tobias |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
Problem with Excel97/Chart/Formula
Hi Tobias,
Your code works fine for me in Excel 97. With one series already existing, sFormula being "empty" gives me =SERIES(,,{1},2) when I select it. Maybe xl97 cannot evaluate your formula, what ever it is. Regards, Peter "Tobias Schittkowski" wrote in message m... Hi! I have an application written in VB 6.0 in which I am creating an Excel Chart. The code below works fine with Excel 2003, but it fails on Excel 97. Set xlsSeries = ActiveChart.SeriesCollection.NewSeries xlsSeries.Formula = sFormula Any Ideas? Tobias |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Problem with chart and formula | Excel Discussion (Misc queries) | |||
| Problem When Opening Excel97 | Excel Discussion (Misc queries) | |||
| formula from Excel97 doesn't work in Excel2003,any ideas why? | Excel Worksheet Functions | |||
| Excel97 CopyWorksheet Problem | Excel Programming | |||
Linear Mode
