I tried to get this to work but since it is not possible to place 'levels' tags around an MS chart, this won't work. The MS chart doesn't take up specific cell values ie; A1 B1 C1 etc (it can be dragged like an image anywhere on the sheet and partially cover some cells only) so it can't be used in the manner you suggested.
However when enabling the 'year' dimension using the NP page feature, I did get a separate chart for each year value.
Hope this helps...
We are just 'like' you & like to be liked when we provide a helpful answer and or when you press the 'Solution Accepted' button if an answer provided resolves your question or issue... Cheers!