+ Reply to Thread
Results 1 to 4 of 4

Entire chart hides when one row is hidden

  1. #1
    Registered User
    Join Date
    06-30-2015
    Location
    Idaho
    MS-Off Ver
    2010
    Posts
    2

    Entire chart hides when one row is hidden

    First time posting on this forum, but I have been unable to find the solution to my problem either here or on another forum.
    The problem I am having is that the two charts on this sheet are hiding themselves whenever I hide row 11 (the sheet in question is attached). I want to hide this row because I don't want the sheet calculations to be seen (found in rows 9, 11, 13, 15, 17, 19). I can successfully hide the other calculations rows, but for some irritating reason hiding row 11 hides the charts.
    I have already changed the setting to show hidden data, as well as the setting to have the charts not move/resize with cell changes.

    Does anyone have a suggestion on how to correct this problem?

    Thanks for your help.
    Attached Files Attached Files

  2. #2
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,023

    Re: Entire chart hides when one row is hidden

    No problem when I try to hide row 11... I'm also using 2010. Open the version you posted (ie download it from the forum). Do you still lose the charts when you hide row 11?
    Glenn




    None of us get paid for helping you... we do this for fun. So DON'T FORGET to say "Thank You" to all who have freely given some of their time to help YOU.

    Temporary addition of accented to illustrate ongoing problem to the TT: L? fh?ile P?draig sona dhaoibh

  3. #3
    Registered User
    Join Date
    06-30-2015
    Location
    Idaho
    MS-Off Ver
    2010
    Posts
    2

    Re: Entire chart hides when one row is hidden

    Well, that's interesting. What is even more interesting is that when I opened the original file the problem had disappeared as well. I had previously tried closing and reopening the file, but maybe I needed to completely exit Excel for it to work properly.
    Thanks for pointing this out and for helping. Hopefully this was a one-time glitch.

    (^_^)

    -Sam

  4. #4
    Forum Moderator Glenn Kennedy's Avatar
    Join Date
    07-08-2012
    Location
    Digital Nomad... occasionally based in Ireland.
    MS-Off Ver
    O365 (PC) V 2403
    Posts
    44,023

    Re: Entire chart hides when one row is hidden

    Yep... the hairy man's approach often works... turn it off & turn it on again!!

+ 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. Copy Entire Row On Filter Data Including Hidden Columns
    By FallingDown in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-12-2014, 04:17 AM
  2. [SOLVED] Chart Lengend to show marker style on hidden line - Line chart
    By etaf in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 08-22-2013, 05:19 PM
  3. [SOLVED] Macro the hides entire rows based on a drop down list
    By MGK086 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 08-14-2012, 11:32 AM
  4. Hidden Chart
    By laureenl in forum Excel General
    Replies: 1
    Last Post: 03-26-2007, 12:41 AM
  5. Hidden data - hidden chart
    By Brisbane Rob in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-01-2006, 04:51 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