Setting series values on Excel Chart

[Mark Roberts]

Hi

I'm struggling very hard in getting beyond this error when trying to use VB to generate a chart from data previously inserted into the sheet.

Unable to set the Values property of the Series class.

The code works absolutely fine in XL2007 but I am having to port it back to 2003 and the inference is that its empty values that cause it to hiccup - something I cannot avoid.

My code is:

1. Retrieve selected data from database and place it at the top of the sheet

2. Add The Chart

3. Iterate through the data (amount can be variable depending upon user inputs)

For j as integer=1 to dtsales.Rows.Count



Submitted via EggHeadCafe - Software Developer Portal of Choice
"Windows Defender" Beta 2 available (formerly "Microsoft Antispyware")
http://www.eggheadcafe.com/tutorial...27e-0c14ac717a80/windows-defender-beta-2.aspx

 

[Don Guillett]

You may find that the 2007 code does not work in 2003 but the 2003 code will
work in both.

--
Don Guillett
Microsoft MVP Excel
SalesAid Software
(e-mail address removed)
in message news:[email protected]...