Results 1 to 3 of 3

Thread: How to make a chart with conditional formatting support

  1. #1
    Join Date
    Nov 2011
    Posts
    120

    How to make a chart with conditional formatting support

    Is there way to automate a bar chart color based on value positive or negative. for example if the value is positive change the bar chart color to green, if the value is negative change the bar chart color to red.

  2. #2
    Join Date
    Nov 2010
    Posts
    422

    Re: How to make a chart with conditional formatting support

    This looks a kind of complicated process. It is possible to create the same, but you have to define conditional formatting in the cell rather on the chart. You can setup a conditional formatting setup in table and define the appropriate values. I don't think it is possible to do that in the Chart itself.

  3. #3
    Join Date
    Nov 2010
    Posts
    503

    Re: How to make a chart with conditional formatting support

    No there is no option for that. You cannot simply add colors to the chart and make chart to change colors. That might need to use any 3rd party software which can provide you options for this purpose. Excel just offers you easy to chart and define the values based on the cell reference. There is no option to define automatic colors which will be changed based on the value inserted.

Similar Threads

  1. VBA Conditional Formatting in Microsoft Excel
    By Thedevotee in forum MS Office Support
    Replies: 4
    Last Post: 21-01-2012, 02:12 PM
  2. Apply Conditional formatting on more than one cells
    By T-User5 in forum Windows Software
    Replies: 3
    Last Post: 14-11-2010, 04:59 AM
  3. How to use conditional formatting in open office
    By Romany in forum Windows Software
    Replies: 4
    Last Post: 08-03-2010, 10:38 AM
  4. Writing a conditional formatting with Excel 2007
    By KAMAL60 in forum Software Development
    Replies: 5
    Last Post: 23-10-2009, 06:19 PM
  5. Conditional formatting in excel
    By RockeЯ in forum Windows Software
    Replies: 4
    Last Post: 27-06-2009, 12:06 PM

Tags for this Thread

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
  •  
Page generated in 1,711,704,348.53413 seconds with 17 queries