+ Reply to Thread
Results 1 to 3 of 3

how to plot every 12th cell in a row, into a chart

  1. #1
    Registered User
    Join Date
    12-20-2011
    Location
    london, england
    MS-Off Ver
    Excel 2007
    Posts
    5

    how to plot every 12th cell in a row, into a chart

    Hi, getting desperate here........

    Imagine Cell A1 = Jan, Cell A2 = feb, Cell A3 = march...............Cell A13 = Jan.....Cell A25=Jan....Cell A37=Jan

    Underneath each cell is a percentage value.

    I need to be able to plot a bar chart just for January values, another for Feb values etc

    I just can't find anthing that works. I have 300 instances of each month in the row (That's 3600 rows) so I can't imagine having to redo the whole thing with references to other cells etc.

    Can I somehow create a seperate table for each month, without having to redo it all? My ideal solution would be to insert a formula and drag it whilst only copying every 12th row.

    Thanks
    Dantastic

  2. #2
    Forum Expert martindwilson's Avatar
    Join Date
    06-23-2007
    Location
    London,England
    MS-Off Ver
    office 97 ,2007
    Posts
    19,320

    Re: how to plot every 12th cell in a row, into a chart

    you can do it like this
    in say c1
    =INDEX($A:$A,ROW(A1)*12-11) dragged down will give 1,13,25....
    =INDEX($A:$A,ROW(A1)*12-10) will give 2,14,26...
    =INDEX($A:$A,ROW(A1)*12-9) will give 3,15,27and so on
    Last edited by martindwilson; 12-20-2011 at 12:33 PM.
    "Unless otherwise stated all my comments are directed at OP"

    Mojito connoisseur and now happily retired
    where does code go ?
    look here
    how to insert code

    how to enter array formula

    why use -- in sumproduct
    recommended reading
    wiki Mojito

    how to say no convincingly

    most important thing you need
    Martin Wilson: SPV
    and RSMBC

  3. #3
    Registered User
    Join Date
    12-20-2011
    Location
    london, england
    MS-Off Ver
    Excel 2007
    Posts
    5

    Re: how to plot every 12th cell in a row, into a chart

    Fabulous, thanks Martin!!!!

    You are todays' HERO.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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