charts
charts
Thanks Thanks:  0
Likes Likes:  0
Results 1 to 3 of 3

Thread: charts

  1. #1
    Guest

    Default

     
    I have a chart pulling data from columns that I want hidden. When I hide them, the chart goes blank. Is there any way to keep this from happening?

  2. #2
    New Member
    Join Date
    Mar 2002
    Posts
    32
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    I've found the simplest thing to do is to change the text color on the cells to be the same as the background. The column is still there, but the data is invisible.

    Doug

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

      
    On 2002-03-15 06:47, Anonymous wrote:
    I have a chart pulling data from columns that I want hidden. When I hide them, the chart goes blank. Is there any way to keep this from happening?
    Put your data on a separate worksheet and hide that worksheet using the Format | Sheet | Hide menu command.

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