title: Pie chart changing weekly
body: <p>I have a chart of every week in a year with information about how many hours, 9 people are working. Is it possible to make this into a weekly pie chart that automaticly shows the current week and percentage of total hours everyone is working i.e a workload pie chart auto updating to the current week.</p>
  
  <p><a href="http://imgur.com/QKx8JH5" rel="nofollow">Current graph</a></p>
  
  <p><a href="http://imgur.com/3P3Sj5b" rel="nofollow">What I want</a></p>
  
  <p>The data is taken from a calendar where everyone puts in their hours per week per project. <a href="http://i.stack.imgur.com/HLa5m.png" rel="nofollow">From this calendar</a></p>
  
  <p>I don't even know how to start with the code so I don't have any code for the pie chart. </p>
  
  <p>This is how the current year overview graph is set up <a href="http://i.stack.imgur.com/bGAMZdG" rel="nofollow">graph for hours a week for every person</a> </p>
  
  <p>This is formula for the hours <code>=SUMIFS(Calendarsheet!L4:L262;Calendarsheet!$B4:$B262;Calendarsheet!$B4)</code>
  I store names in B column</p>
  
  <p><a href="http://i.stack.imgur.com/XbebeMb" rel="nofollow">graph of percent of their max hours</a>
  Formula in this chart: <code>=B34/Calendarsheet!L$3</code>  it takes the hours from the first chart and divides by total workhours of that week taken from the calendarsheet</p>
  
  <p>Sorry for bad links, need more reputation to post more than 2 links </p>