Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
bubble Chart bubblesize problem in VBA
Hi all,
I am trying to create a bubble chart in VBA but the code crashes on the bubblesize line. I originally recorded a macro then modified it to allow several series and to use named ranges for the data. When the code gets to ActiveChart.SeriesCollection(i).BubbleSizes = Range("zprod" & i) It crashes with an error. I searched through these groups and saw some info on this but nothing I tried would work. I have created named ranges like xprod1, yprod1, zprod1, where "zprod" is the bubblesize. The range "allplotdata" contains three columns of data but it not want I eventually want to plot. That was added based on other comments about having the data specified before changing to a bubble chart. numseries is an integer from 1 to 5. Each would be a separate series with a different color. Doesn't matter since it crashes on 1. The code crashes on i = 1 on the bubblesizes line. It says runtime error 5, Invalid procedure or argument. So far the code looks like this: Sub CreateBubble() Charts.Add ActiveChart.SetSourceData Source:=Range("allplotdata") ActiveChart.ChartType = xlBubble3DEffect 'ActiveChart.SeriesCollection(1).Delete For i = 1 To numseries If (i 1) Then ' NewSeries is done once for each series except the first ' because by default there is already one series ActiveChart.SeriesCollection.NewSeries End If ActiveChart.SeriesCollection(i).Name = prodlist(i, 1) ActiveChart.SeriesCollection(i).XValues = Range("xprod" & i) ActiveChart.SeriesCollection(i).Values = Range("yprod" & i) ActiveChart.SeriesCollection(i).BubbleSizes = Range("zprod" & i) Next i Thanks for your help! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
very odd bubble chart problem | Charts and Charting in Excel | |||
How can I change the color of negative bubble in bubble chart | Charts and Charting in Excel | |||
How can I change the color of negative bubble in bubble chart | Charts and Charting in Excel | |||
Problem with BUBBLE CHART scale and legend | Charts and Charting in Excel | |||
How do I move a hidden bubble to the front in a bubble chart in E. | Excel Discussion (Misc queries) |