Results 1 to 3 of 3

Thread: Hide The Range But Show Without Hiding The Chart Graph Series

  1. #1
    Member
    Join Date
    Dec 2012
    Posts
    78
    Rep Power
    12

    Hide The Range But Show Without Hiding The Chart Graph Series

    When I hide rows 55 to 66 it also hides the graph.How can I hide the rows 55 to 66 but keep the graph always visible
    Cheers
    Rich Cirillo
    Attached Files Attached Files

  2. #2
    Administrator Excel Fox's Avatar
    Join Date
    Mar 2011
    Posts
    1,402
    Rep Power
    10
    You'll need to use a dummy table for this, or write a more elaborate macro which codes the series based on the visible range of cells.

    This http://www.excelfox.com/forum/f2/cha...own-list-1197/
    A dream is not something you see when you are asleep, but something you strive for when you are awake.

    It's usually a bad idea to say that something can't be done.

    The difference between dream and aim, is that one requires soundless sleep to see and the other requires sleepless efforts to achieve

    Join us at Facebook

  3. #3
    Member
    Join Date
    Dec 2012
    Posts
    78
    Rep Power
    12
    I had a look at the file in post #2...it also removes the graph when the rows are hidden...what sort of macro would I require...would prefer to use the NA table and just hide the rows but do you believe this is not possible
    Cheers,,,,Rich

Similar Threads

  1. Change Data Series In Chart Using Drop-Down List
    By raybugge in forum Excel Help
    Replies: 2
    Last Post: 07-06-2013, 03:02 PM
  2. Adjust The Width Of Column Chart Series
    By rich_cirillo in forum Excel Help
    Replies: 6
    Last Post: 07-05-2013, 06:08 PM
  3. Replies: 4
    Last Post: 06-10-2013, 01:27 PM
  4. Convert Series into Range.
    By ayazgreat in forum Excel Help
    Replies: 13
    Last Post: 03-26-2012, 08:49 PM
  5. Color Chart Series VBA
    By Admin in forum Download Center
    Replies: 0
    Last Post: 04-29-2011, 11:26 PM

Posting Permissions

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