Sign in
 
Home20122008 R2200820052000LibraryForums
SQL Server >
> 
> 
Un-hiding hidden axis?

Odpovědět Un-hiding hidden axis?

  • Wednesday, May 16, 2012 5:17 PM
     
     
    Sign In to Vote
    0

    Working with SSRS 2008, thru BDIS

    How do I un-hide an axis that I've previously hidden. I created a data series that I'd initially displayed on the Secondary Horizontal Axis, all fine.

    Then I hid the Secondary Horizontal Axis. Now I want it back, but don't see anywhere to set it's visibility back to True (or Auto).

    All of the thread+help info I see describes "right-click on axis", blah, blah, but I don't SEE that axis to right-click on it.

    And the Properties dialog doesn't work as expected (consistent with other MS products) where I can see ALL the objects on the report in a hierarchy. If I click on Chart1, I'd expect to see all the members of Chart1, but Properties only shows a couple. Nothing like Secondary Horizontal Axis...

    Ideas? Clues for the clueless?
    Thanks in advance!

     

All Replies

  • Wednesday, May 16, 2012 8:25 PM
    Moderator
     
     
    Sign In to Vote
    1

    Hi There

    Please right click on the top of your chart where the secondary horizontal axis normally lies, you might need to click couple of time to get the right place J and then go secondary horizontal properties. Go to label and unhide from there.

    I hope this will help

     If you have any question please let me know.

    Many Thanks

    Syed Qazafi Anjum

    Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

     
  • Wednesday, May 16, 2012 9:02 PM
     
     
    Sign In to Vote
    0

    Not that I don't appreciate the response, but there is no "there" there... as I stated, the axis is not visible. And "click a couple of times" is not helpful. You don't think I tried this?
    Sorry:(

     
  • Wednesday, May 16, 2012 9:58 PM
    Moderator
     
     Answered
    Sign In to Vote
    1

    Hi There

    Can you please do the following?

    1. Select you chart and go to properties and select chart area collection click on that little ellipse (it is sixth from the top after category group
    2. A new window appear name chart area collection editor
    3. Please click on that little ellipse category axis under axis
    4. Now another window open chart axis collection
    5. Here you can see both on your primary axis as well as secondary axis
    6. Select secondary axis and under appearance you can see visible

    I have put some screenshot for your help

    Many Thanks

    Syed Qazafi Anjum

    Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful.

     
  • Wednesday, May 16, 2012 10:22 PM
     
     
    Sign In to Vote
    0

    NAILED IT!

    *thank you*

    And the revelation of "collections" under the chart. Now I'm seeing a bunch of useful stuff! Nice!

     
  • Wednesday, May 16, 2012 10:31 PM
    Moderator
     
     
    Sign In to Vote
    0

    Hi There

    I am really glad that your problem has been resolved. Every day we learn a lot from each other that what we called sharing thoughts.

    Good luck for your project

    Many thanks

    Syed Qazafi Anjum

    Please click "Mark as Answer" if this resolves your problem or "Vote as Helpful" if you find it helpful