+ Reply to Thread
Results 1 to 2 of 2

Trying to set up an autofill "queue" for a chart

  1. #1
    Registered User
    Join Date
    06-30-2014
    Location
    Virginia
    MS-Off Ver
    2007
    Posts
    1

    Trying to set up an autofill "queue" for a chart

    I'm trying to set up a chart with an auto fill "queue".

    For example.
    I have six names. I have one name in each cell: 2C, 3C, 4C, 5C, 6C, 7C.
    I want the queue to be in the order of 2C --> 3C --> 4C -->5C --> 6C --> 7C --> 2C --> 3C --> ∞
    I also want the queue to be linked to a variable/formula "x".
    So that when I place "x" in a cell it will automatically fill in a name from the queue.
    The first time I place "x" it will fill in 2C's name, the next time I place "x" it will fill in 3C's name, and so on.
    I want it to constantly be in order, never going from "x" 2C, to "x" 5C. It must always be in the same order, as listed above.
    I would also read the excel from left to right, and up to down, as you would read any normal american book.

    "x" will be whatever it is I need to place in the cell to automatically fill in the next name on the queue.

  2. #2
    Forum Expert cbatrody's Avatar
    Join Date
    04-15-2014
    Location
    Dubai
    MS-Off Ver
    Microsoft Office 365 ProPlus
    Posts
    2,134

    Re: Trying to set up an autofill "queue" for a chart

    Hi,

    Welcome to the Forum.

    Please post a sample template of your workbook using "Go Advanced" option.

+ 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] Very small AutoFill macro showing "AutoFill methode of range class failed" why ?
    By nur2544 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-28-2013, 10:21 PM
  2. [SOLVED] Problem creating Line Chart from columns "date" and "money"
    By brosef in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 11-05-2012, 09:01 AM
  3. Replies: 0
    Last Post: 09-17-2012, 01:17 PM
  4. Replies: 0
    Last Post: 09-17-2012, 08:24 AM
  5. Replies: 4
    Last Post: 02-03-2008, 05:11 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