Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hello group,
I encountered strange behavior with the Chart.SeriesCollection(n).Values and XValues property when using floating point arrays. When this procedure is run, the integer array works fine, but the floating point array exits with the error message: "Unable to set the XValues property of the Series class". The strange part is: if you decrease the array size, it works, if you decrease the decimals, it works. The error remains if the array is typed. Anybody knows what's going on? Thanks. Emile Sub drawAxis() Dim xAxis(1 To 40), yAxis(1 To 40), n As Integer For n = 1 To 40 xAxis(n) = 0.005 yAxis(n) = 5 Next n Chart1.SeriesCollection(1).Values = yAxis Chart1.SeriesCollection(1).XValues = xAxis End Sub |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Strange behavior | Excel Discussion (Misc queries) | |||
SeriesCollection Values Property Oddity | Charts and Charting in Excel | |||
Strange behavior | Setting up and Configuration of Excel | |||
Strange behavior. | Excel Discussion (Misc queries) | |||
format text string for SeriesCollection.Name property | Excel Programming |