Setting series values on Excel Chart
 

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/tutorials...er-beta-2.aspx

Setting series values on Excel Chart
 

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

"Mark Roberts" wrote in message ...
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/tutorials...er-beta-2.aspx