+ Reply to Thread
Results 1 to 3 of 3
  1. #1
    Registered User
    Join Date
    04-22-2008
    Posts
    4

    show/hide graph axis

    Hi,

    is there a way to be able to choose - depending on the amount of data in a graph - if you want to display the X-axis or not?

    I have a column graph that can update itself and have anywhere between 0 and > 200 columns. Whenever the graph has more than ~20 columns only every second column has its name displayed on the X-axis (and of course even fewer when the number of columns increases).

    I want that when the 20 column limit is reached the X-axis should be hidden automatically. Is there a way to achieve this?

    Thanks, osciva

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003 & 2007 & 2010
    Posts
    10,944
    Is the chart readable if you remove the category labels?

    If you want complete control without code using an additional data series plotted as line might work,
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    04-22-2008
    Posts
    4
    thanks,

    now I made every cell the title column in the source data dependent on a cell where I count the total colums. If its below a certain value I print "" instead of the name.

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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.2.0