Hello,
I would like to create a pivot chart with multiple panels. I have attached my workbook that shows an example of this. I'd like to change the gridlines so they only appear for "Cost" and "Use" (so there would only be one vertical grid line between 2020 and 2014, instead of at each year).
Under the thread "Create a bubble chart with sections" there is a link on how to create panel charts. In that example, if I'm not mistaken, the panel chart is created from first copying the pivot data as values. Is it possible to do something similar but within the pivot chart? I want to be able to incorporate the interactive capabilities of the pivot chart (such as adding in slicers etc.) so would rather not have to use a regular chart to do this.
Any help would be much appreciated!
Bookmarks