title: Coloring Bar Graph in Excel based on value
body: <p>I have the following data</p>
  
  <pre><code> Client              Week            Revenue
  
   Google              1               4000
   Microsoft           1               5000
   Intel               2               2000
   EvilCorporation     3               1000
  </code></pre>
  
  <p>You get the idea (the numbers and names have obviously been changed in the above data).  I want the bar graph to be a certain color based on the week number. The data will change week to week, but there will always be a week 1, 2 and 3. So i need 3 colors, one for each week, that corresponds to the proper company. The x-values would label the companies, and Y values would be the revenue.</p>
  
  <p>From my research, I found out that this is pretty much impossible in excel using the graph tools, and VBA is required. While I do know VBA functions, I have 0 experience with VBA graphing, and how and where would you call the function after creating it.</p>
  
  <p>If there is a different type of graph this would be easier with, I'm all for it, as long as it is easy to look at.</p>