| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Works in 2007 but not 2003
"Barb Reinhardt" wrote in message ... I'm thinking this should work in both Dim aWS As Worksheet Dim myWS As Worksheet Set aWS = ActiveSheet Set myWS = ThisWorkbook.Worksheets("WMP") aWS.ChartObjects("Chart 1").Activate ActiveChart.SeriesCollection(2).Name = "=""Male""" ActiveChart.SeriesCollection(2).Values = myWS.Range("BM4:BM64") -- HTH, Barb Reinhardt If this post was helpful to you, please click YES below. No sorry didn't work |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| xls file works fine in Excel 2000 and 2007 but crashes on opening in 2003 | Excel Discussion (Misc queries) | |||
| Works 7.0 database files to Excel 2007 | Excel Discussion (Misc queries) | |||
| How do you import from Office 2007 into MS Works? | Excel Discussion (Misc queries) | |||
| How to inport works spreadsheet into excel 2007 | Excel Worksheet Functions | |||
| Works 4.0(wks) needs to be converted to Excel 2003 | Excel Discussion (Misc queries) | |||
![teepee[_3_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
