+ Reply to Thread
Results 1 to 4 of 4

Excel 2007 : Conditional Formatting - Data Bars

  1. #1
    Registered User
    Join Date
    08-08-2009
    Location
    Brazil
    MS-Off Ver
    Excel 2003
    Posts
    2

    Conditional Formatting - Data Bars

    Hello everyone,
    I have a doubt regards to Excel 2007
    In *Condition Formatting *if I choose DATA BARS
    (that small bars in the cells that represent the number and compare the numbers in others cells...)

    my doubt is:
    is it possible to configure the DATA BARS
    to start from Right to Left (and not from Left to Right which is the default) ?*

    I will try to explain the reason of this doubt:

    In column B I have the variation of some values.
    In column C I have the formula: =IF(B1<0;B1;"")
    In column D I have the formula: =IF(B1>0;B1;"")

    then I use the DATA BARS in column C and D
    If the DATA BARS starts from Right to Left on column C
    I would have a perfect view of my data, did you understand ?
    (because in column C I have only negative numbers)

    Now I have some negative bars starting from Left to Right in column C
    and I have some positive bars starting from Left to Right in column D

    It is ok. but I I would like to have the side bars starting from Right to Left in column C,
    did you understand what I mean ?

    This is why I am looking for this answer and, if possible for you,
    I would appreciate your reply.

    Thanks a lot
    I'm from Brazil.

    Flavio
    Last edited by flaviocn; 08-09-2009 at 06:33 PM.

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

    Re: Conditional Formatting - Data Bars

    You can not change the direction of the data bars.

    Here is recent blog on databars in 2010 which illustrated the lack of control over the data bars.
    http://blogs.msdn.com/excel/archive/...xcel-2010.aspx

    Perhaps you could create the bars yourself using 2 columns and right/left align
    http://datapigtechnologies.com/blog/...-without-rept/
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    08-08-2009
    Location
    Brazil
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Conditional Formatting - Data Bars

    Andy,
    I thank you very much,
    These links are excelent and gave me the solution not only to Excel 2007 but also to work with Data Bar in Excel 2003 !
    Very very good.
    Flavio

  4. #4
    Administrator JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Conditional Formatting - Data Bars

    If that takes care of your need, be sure to EDIT your original post, click Go Advanced and mark the PREFIX box [SOLVED].
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    “None of us is as good as all of us” - Ray Kroc
    “Actually, I *am* a rocket scientist.” - JB (little ones count!)

+ 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