Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
-
Adding Data to Ranges Object
In the end I just irlblinky's code in a function and repeated for all the ranges. Thanks all!- pauluk13
- Post #12
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Adding Data to Ranges Object
Thanks for all your help. irlblinky I thought it would be possible to instead to do something like: Dim rng As Ranges Ranges.Item(1)=("A1:B4") Ranges.Item(2)=("C1:D4") for all ranges Charts.Add ActiveChart.ChartType = xlPie ActiveChart.SetSourceData Source:=rng(i)...- pauluk13
- Post #9
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Adding Data to Ranges Object
Oh yeh I have qualified the source bk elsewhere. Thanks. Wouldn't that change my original graph? What I need is multiple graphs all with the same formatting but displaying different data.- pauluk13
- Post #5
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Adding Data to Ranges Object
So far I have: Dim rng As Range Set rng = Sheets("DL3").Range("B1:F28") With bk.Worksheets("DL3 Critical").ChartObjects.Add _ (Left:=0, Width:=500, Top:=0, Height:=300) .Chart.SetSourceData Source:=rng End With This code makes one graph...- pauluk13
- Post #3
- Forum: VBA Visual Basic for Applications (Microsoft)
-
Adding Data to Ranges Object
Hi, I want to create multiple graphs in Excel of the same style but with different ranges of data. My plan was to set up a ranges collection that stores a list of ranges. I could then loop through and create a new graph for each one. However I cannot find a way to add values to a ranges object...- pauluk13
- Thread
- Replies: 11
- Forum: VBA Visual Basic for Applications (Microsoft)
