+ Reply to Thread
Results 1 to 2 of 2

Multicoloured data bars

  1. #1
    Registered User
    Join Date
    09-24-2010
    Location
    Lake Garda, Italy
    MS-Off Ver
    2010 Professional Plus (Italian/English/German)
    Posts
    7

    Multicoloured data bars

    Since CF data bars appeared in 2007 I've loved them but never liked the restriction to one colour for positive values, one colour for negative.
    So a couple of weeks ago I sat down to figure out a workaround and ended up with this:
    Name:  2014-07-08_085119.jpg
Views: 239
Size:  11.5 KB
    If anyone's interested...
    digimac.wordpress.com

    Please take a look, download the UserForm then pick apart my code.
    (this isn't a question so I hope I haven't broken any rules)

    Moderator's note: Moved from Excel General --6StringJazzer
    Last edited by 6StringJazzer; 07-08-2014 at 09:21 AM.
    David Macdonald
    Win7 Enterprise - Excel 2010

  2. #2
    Registered User
    Join Date
    09-24-2010
    Location
    Lake Garda, Italy
    MS-Off Ver
    2010 Professional Plus (Italian/English/German)
    Posts
    7

    Re: Multicoloured data bars

    Thanks to Jazzer for moving the thread to the right place.

    I may be going a little over the top with this multicolour data bar thing.
    You can now individually set the following for each data range:
    - bar colour
    - gradient or solid fill
    - show value
    - show border
    - border colour

    Name:  multicoloured.jpg
Views: 194
Size:  10.1 KB
    Name:  multicoloured pos-neg.jpg
Views: 177
Size:  10.7 KB

+ 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. Replies: 1
    Last Post: 12-23-2013, 06:29 PM
  2. Docking Command bars? (tool bars)
    By Rick_Stanich in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 07-06-2009, 03:51 PM
  3. Multicoloured lines on a graph?
    By no48 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-16-2008, 04:55 AM
  4. [SOLVED] How can I change a graph with 2 bars,2 lines to 3 bars, 1 line?
    By IOWAJulie in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 10-19-2005, 07:05 PM
  5. Lost all my menu bars and tool bars
    By CathyJ in forum Excel General
    Replies: 3
    Last Post: 08-08-2005, 08:05 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