+ Reply to Thread
Results 1 to 2 of 2

Hiding Values Below Z Axis Minimum Value on Axis Charts

  1. #1
    TryingToExcel
    Guest

    Hiding Values Below Z Axis Minimum Value on Axis Charts

    I want to use an area chart to show values for data series above a certain
    minimum Z axis value. Unfortunately, I can't find a way to hide parts of
    series that have values below this minimum. The chart shows a continuation of
    the series as though the values were AT the minimum. I've also tried to
    manually clear cells in the table that have values less than the mimum but
    that hasn't worked. Any suggestions?

  2. #2
    Tushar Mehta
    Guest

    Re: Hiding Values Below Z Axis Minimum Value on Axis Charts

    XL's ability to draw 3D charts is very limited. You have hit one of
    the limitations.

    --
    Regards,

    Tushar Mehta
    www.tushar-mehta.com
    Excel, PowerPoint, and VBA add-ins, tutorials
    Custom MS Office productivity solutions

    In article <[email protected]>,
    [email protected] says...
    > I want to use an area chart to show values for data series above a certain
    > minimum Z axis value. Unfortunately, I can't find a way to hide parts of
    > series that have values below this minimum. The chart shows a continuation of
    > the series as though the values were AT the minimum. I've also tried to
    > manually clear cells in the table that have values less than the mimum but
    > that hasn't worked. Any suggestions?
    >


+ Reply to Thread

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.6.0 RC 1