Results 1 to 6 of 6

hidden data in a graph

This is a discussion on hidden data in a graph within the Excel Questions forums, part of the Question Forums category; I need to graph hidden data. I need to only show cirtain columns but the other columns need to be ...

  1. #1
    Board Regular Carrie's Avatar
    Join Date
    Nov 2002
    Location
    DFW, TX
    Posts
    416

    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,542

    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
    67,364

    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
    416

    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

    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
    1,774

    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.

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