Hi I am trying to recreate an excel chart I have in Google charts but cant figure out how to do this one. I have quite a few others but this is more difficult. I tried the code playground and couldn't find an answer there also.
You can see the image of the original cart and the data here:
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.