+ Reply to Thread
Results 1 to 2 of 2

Macro to create more charts

  1. #1
    Forum Contributor
    Join Date
    11-04-2012
    Location
    Czech Republic
    MS-Off Ver
    MS 2007,Mac 2011
    Posts
    227

    Talking Macro to create more charts

    Hi all,


    Hope, that anyone could help me with the following issue I'm facing.
    I have a macro, which creates me a 2 charts for 2 metrics ( 1 chart for each). My metrics are in columns as below. Is there a way to have dynamic macro, which will create me number of charts depending on number of columns?

    Week Number of Calls Number of Serial numbers
    W1 10 410
    W2 45 446
    W3 101 85


    The point is, that number of columns ( metrics) always change, this could avoid a lot of manuall work

    Thanks a loooot to all
    Andy

  2. #2
    Forum Contributor
    Join Date
    11-04-2012
    Location
    Czech Republic
    MS-Off Ver
    MS 2007,Mac 2011
    Posts
    227

    Re: Macro to create more charts

    Hi,

    Is there anybody who could help with that?

    Thanks, Andy

+ 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] Macro to add to Name Manager and Create Charts
    By Tberrie in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 12-10-2014, 07:23 AM
  2. Macro To Create Several Charts
    By jhunt10 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-20-2014, 11:35 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. [SOLVED] 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