Zend certified PHP/Magento developer

Excel Pivot Charts – Creating different charts (with different grouping) from the same data

I would like to create (at least) two pivot charts sourced from the same data that display the data in different groupings; one will be grouped by years, the other grouped by months. I am able to create the two charts each on their own, but as soon as I create them both on the same Sheet/Workbook, they become linked and changing one changes the other.

The data for these charts is updated weekly so I don’t want to create entirely separate workbooks for each set of data I’m hoping to display in more than one way.

Is there anyway to ‘unlink’ the charts from themselves while still keeping them sourced from the same data? Something to do with data models? (I know the word but have never used anything in there.)


Example data:

PO_Number PO_Date_Created
144867 6/2/2022
134028 4/18/2022
145140 6/8/2022
141421 5/23/2022
145623 6/17/2022
94305 9/9/2021
142399 5/24/2022
145629 6/17/2022
132022 4/8/2022
144968 6/6/2022
145587 6/17/2022
145617 6/17/2022
145631 6/17/2022
145299 6/13/2022
135080 4/29/2022

Here is the set up. I’d like one for Months and one for Years; however, since I set the Month one up after configuring Years, it overrode the first chart.

ExampleOfLinked

Each graph works, just not at the same time.

enter image description here

Any tips or things to try would be very appreciated!