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/aspnet/699400c6-10b3-4b91-927e-0c14ac717a80/windows-defender-beta-2.aspx

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
dguillett@gmail.com
"Mark Roberts" wrote in message news:201011192732mark@frazpro.co.uk...
> 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/aspnet/699400c6-10b3-4b91-927e-0c14ac717a80/windows-defender-beta-2.aspx