hidden data in a graph

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 6 of 6

Thread: hidden data in a graph

  1. #1
    Board Regular Carrie's Avatar
    Join Date
    Nov 2002
    Location
    DFW, TX
    Posts
    418
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default hidden data in a graph

     
    I need to graph hidden data. I need to only show cirtain columns but the other columns need to be hidden.

    When I hide the data the bars disappear from my graph. I searched and know about the format...cells...custom...;;; but this just makes the data disappear.

    I need to HIDE the columns.

    Please Help.
    Thanks,

    Carrie

    "Time flies like the wind.
    Fruit flies like banana's."

    --Author Unknown

  2. #2
    Board Regular
    Join Date
    Sep 2002
    Location
    Simsbury CT USA
    Posts
    1,551
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: hidden data in a graph

    Hi:

    You might consider a custom view that "ghosts" the text in the data you wish to hide.

    That is, match the color of the text to that of the color of the cell....thus it seems to be hidden...then save this view as a custom view for later recall


    hope this helps

    plettieri

  3. #3
    MrExcel MVP
    Moderator
    Andrew Poulsom's Avatar
    Join Date
    Jul 2002
    Posts
    73,092
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: hidden data in a graph

    Activate the chart, choose Tool|Options|Chart tab and uncheck "Plot visible cells only".

  4. #4
    Board Regular Carrie's Avatar
    Join Date
    Nov 2002
    Location
    DFW, TX
    Posts
    418
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: hidden data in a graph

    Thank you, Thank you, Thank you!

    The Tools Options thing is exactly what I needed.
    Thanks,

    Carrie

    "Time flies like the wind.
    Fruit flies like banana's."

    --Author Unknown

  5. #5
    Board Regular
    Join Date
    Apr 2003
    Location
    Massachusetts, USA
    Posts
    53
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: hidden data in a graph

    Any solution updates for Excel 2010?
    Bruce Berger
    Boxborough, MA USA

  6. #6
    Board Regular
    Join Date
    Feb 2002
    Location
    Southfield,MI USA
    Posts
    2,305
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: hidden data in a graph

      
    In 2010 they stealthed the option here:

    Select the Chart -> Design Tab -> "Select Data" -> "Hidden and Empty Cells" -> Check off "Show data in hidden rows and columns".

    Repeat for each chart.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com