Results 1 to 12 of 12

Bar Graph Color Selection for negatives

Threaded View

  1. #1
    Registered User
    Join Date
    01-03-2010
    Location
    North Carolina
    MS-Off Ver
    Excel 2007
    Posts
    12

    Bar Graph Color Selection for negatives

    I have an EXCEL bargraph that I would like to automatically show a green bar if the number is positive and a red bar if the number is negative. Just using the inverse color if negative does not give me the option of selecting the color. Is it possible to do what I am asking automatically, or must I manually set the color every time the value changes sign?

    Thanks
    Attached Files Attached Files
    Last edited by chadwellp; 03-24-2010 at 09:47 PM. Reason: Added file example

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