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!

Register Log in
  • Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. pauluk13

    Adding Data to Ranges Object

    In the end I just irlblinky's code in a function and repeated for all the ranges. Thanks all!
  2. pauluk13

    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)...
  3. pauluk13

    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.
  4. pauluk13

    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...
  5. pauluk13

    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...

Part and Inventory Search

Back
Top