+ Reply to Thread
Results 1 to 3 of 3

How to keep the chart floor from moving (away from zero) when there are negative values

  1. #1
    Forum Contributor
    Join Date
    06-10-2005
    MS-Off Ver
    2007
    Posts
    223

    How to keep the chart floor from moving (away from zero) when there are negative values

    Hi,
    I have a 3-D column chart and it's great until I have a negative value. To see that particular column visually go down below zero, I need to change the minimum value of the y-axis from zero to a negative number. However, at that point, the grey floor separates from my columns and moves downward also. I want to keep the floor where it crosses the y-axis at zero.
    Any suggestions would be appreciated.
    Thanks,
    Phillycheese
    Attached Files Attached Files
    Last edited by Phillycheese5; 05-11-2015 at 12:06 PM.

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,441

    Re: How to keep the chart floor from moving (away from zero) when there are negative value

    You attachment does not contain a chart so it's hard to know how you constructed the chart.
    on a 3d chart with pos/neg values the floor will always be below the columns. If it remained at zero it would obscure the columns beneath it.
    Cheers
    Andy
    www.andypope.info

  3. #3
    Forum Contributor
    Join Date
    06-10-2005
    MS-Off Ver
    2007
    Posts
    223

    Re: How to keep the chart floor from moving (away from zero) when there are negative value

    Hey Andy,
    Not sure what happened with my attachment. I've tried to re-post but for some reason I'm having a problem with the upload. In any event, I figured that with the option to set the transparency of the floor that the issue you mention would not be a problem. I guess there's not really a way around it. The chart just looks very strange with the floor floating out in the middle of nowhere. Maybe I'll just get rid of the floor when I have negative values.
    Thanks,
    Phillycheese

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Scaling Chart but avoiding negative values
    By JoeSkittles in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 06-11-2013, 11:25 AM
  2. Stacked Area Chart - Negative Values
    By sagaramlani in forum Excel General
    Replies: 8
    Last Post: 09-05-2012, 12:54 PM
  3. negative values in chart
    By cassiopea in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-19-2012, 07:33 AM
  4. Replies: 2
    Last Post: 06-18-2012, 04:26 PM
  5. negative chart values?
    By spinkung in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 06-16-2008, 10:21 AM

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