Bar chart

Thanks Thanks:  0
Likes Likes:  0
Results 1 to 2 of 2

Thread: Bar chart

  1. #1
    New Member
    Join Date
    Jan 2014
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Bar chart

     
    Hi,
    I am trying to get excel to change the colous by the lenght of each bar, automatically. We have 5 bar lenghts, is there some formula I can use so that for eg. bar with lenght 1 always comes up red, bar with lenght 2 always comes up yellow, etc. I can do this for a single graph but cannot get it consistently for every chart generated.
    Thank you in advance

  2. #2
    MrExcel MVP VoG's Avatar
    Join Date
    Jun 2002
    Location
    127.0.0.1
    Posts
    63,651
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Bar chart

      
    HTH, Peter
    Please test any code on a copy of your workbook.

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

 

 
DMCA.com