LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 1
Default Pb With Excel 2003 Charts

Hi guys, I've got a big pb... and if someone could help me quickly it
would be great.

There's my pb :
I run a macro under VB which create charts and series within each
charts using :

'Creating Chart
'Add serie

'And then:

1.Set AddSingleChartSeriesFromRange =
NewChart.SeriesCollection.NewSeries
2.AddSingleChartSeriesFromRange.Values = "=" &
RangeToChartAddress(ChartSeriesValues)

3.If Not ChartSeriesXValues Is Nothing Then
AddSingleChartSeriesFromRange.XValues = "=" &
RangeToChartAddress(ChartSeriesXValues)

4.If Not ChartSeriesName Is Nothing Then
AddSingleChartSeriesFromRange.Name = "=" &
RangeToChartAddress(ChartSeriesName)


' It does crash just after setting the values...


The thing is, it does work fine for a lot of charts , but somehow
manages to crash for one of the chart ( which can be different
depending of the series of each chart, for that I 'm wondering if
didn't hit any limit within Excel for the series within a
workbook...which might be 256 but it is written 255 on a worksheet on
the excel specifications).

Or I was thinking As well, It might due to that my values are string (
and my xvalues are date), could it be pb ?

I already verified the length of each data, and they are the same for
Values and Xvalues.

The odd thing, is that my program does carry on after, and create the
following charts, but if you close excel or try to save the workbook ,
Excel crashes....

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel 2003 Charts TWB Charts and Charting in Excel 3 August 13th 08 08:00 PM
Charts Excel 2003 Gringarlow Charts and Charting in Excel 3 January 25th 08 02:38 AM
Excel 2003 Using graphics in charts Trish Charts and Charting in Excel 1 September 27th 06 03:32 AM
Excel 2003 Charts KnightSurfer Charts and Charting in Excel 0 April 20th 05 02:03 AM


All times are GMT +1. The time now is 04:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"