+ Reply to Thread
Results 1 to 3 of 3

Macro To Create Several Charts

  1. #1
    Registered User
    Join Date
    01-16-2014
    Location
    34399958
    MS-Off Ver
    excel mac 2011
    Posts
    3

    Macro To Create Several Charts

    I have a set of data where there are about 14-15 months along the first row, and then in the first column there are about 150 rows of items. There are then values for each item and each month (sometimes blank or zero). It's just a giant pivot table. I would like to make a separate chart for each item that goes across all of the months all on one new page/sheet. I'm fairly new to VBA, so this is what I have so far, but I really need some help haha.

    Sub Add_Charts()
    Dim i As Integer


    Worksheets("All").Activate
    Worksheets("Charts").Activate


    For i = 0 To Worksheets("All").Range(Worksheets("All").Range("A5"), Worksheets("All").Range("A5").End(xlDown)).Count
    Worksheets("Charts").Shapes.AddChart.Select
    ActiveChart.ChartType = xlLine
    ActiveChart.SeriesCollection.Values = Worksheets("All").Range(Worksheets("All").Cells(5 + i, 1), Cells(5 + i, 7))
    Next i


    End Sub

    I appreciate any help!

  2. #2
    Registered User
    Join Date
    01-16-2014
    Location
    34399958
    MS-Off Ver
    excel mac 2011
    Posts
    3

    Re: Macro To Create Several Charts

    Any ideas?

  3. #3
    Registered User
    Join Date
    01-16-2014
    Location
    34399958
    MS-Off Ver
    excel mac 2011
    Posts
    3

    Re: Macro To Create Several Charts

    To the top, somebody has to know how to do this haha

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] Can you create self updating charts in macro enabled worksheets?
    By GarethT in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 04-25-2013, 04:28 AM
  2. [SOLVED] loop macro to create different charts by selecting different x-axis data
    By burnmeister in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 04-01-2013, 10:38 AM
  3. Replies: 1
    Last Post: 06-28-2012, 11:10 AM
  4. VBA Macro to create new worksheet, charts, etc.
    By Jim15 in forum Excel Programming / VBA / Macros
    Replies: 15
    Last Post: 11-03-2008, 02:47 PM
  5. Vb macro stops when I try to create more than 89 charts
    By Tiberius in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-19-2006, 01:55 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1