Results 1 to 3 of 3
  1. #1
    Join Date
    Oct 2006

    Question Unanswered: Charting Help(arrays vs ranges)

    I have recorded a macro to make a nice little series chart. The problem is that I have to create a range on a sheet with the first row containing the category titles and then a row containing the series values. I really would rather just pass two arrays to the chart macro one with the category titles and the other with the series values.
    The problem is that I can't seem to find the proper way to make a macro that accepts arrays rather than ranges.

    Can anybody offer a suggestion as to what this macro might look like?

    Thank You for any help you may offer

  2. #2
    Join Date
    Oct 2003
    John Walkenbach addresses part of this with his Spreadsheet tips.

    Will this help you?
    old, slow, and confused
    but at least I'm inconsistent!

    (retired Excel 2003 user, 3/28/2008)

    How to ask a question on forums

  3. #3
    Join Date
    Oct 2006

    Talking Resp to Your Resp

    To be honest with you I don't really quite understand what he is doing.
    But thank you Shades for the response, I appreciate your time.

Posting Permissions

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