See Pivot4 in the attached. There is a chart which shows % Shop Hours Awarded. Let me know if this works for you. If so, then you can play with the chart formatting to prettify it anyway you like.
Basically, I just copied the pivot table in Pivot 2 and deleted the totals, leaving the percentages. I filtered out everything but the awarded amount.
Next I inserted a Pivot Chart (from the Analyze in Pivot table Tools) and created a line chart. I haven't worked with pivot charts much but they don't always do what you want. In this case, they were charting the percentage awarded with the month in the legend, basically the opposite of what is needed. So to change that, I right click on the chart and select "Select Data..." and press the Switch Row/Column button. If you do that, you'll see it actually changes the table too.
One nice thing about the pivot charts is that it has the filters right on the chart so you can modify what is shown directly on the chart.
|