Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Excel 2003 Charts | Charts and Charting in Excel | |||
Charts Excel 2003 | Charts and Charting in Excel | |||
Excel 2003 Using graphics in charts | Charts and Charting in Excel | |||
Excel 2003 Charts | Charts and Charting in Excel |