What you have are essentially the same graph copied 9 times over. It seems
to work because you are not asking PowerPoint to update the links. If those
links do get updated -- as in your case because of a data change -- all the
graphs will show whatever you have currently selected in Excel.
The choices that I can think of are:
1) Make static images of the charts (i.e., copy+paste an image of the chart
not a linked Excel chart).
2) Insert a copy of the chart so that it is an Excel chart but no longer
connected to the Excel workbook...not a good idea, methinks.
3) Write a macro that does the 9 geographic selections (*6 copy+paste
operations per selection) from Excel to PP.
Depending on how often the data change, I would go with either 1 or 3,
keeping in mind that 3 might be relatively easy but could easily, if, for
example, you have slides that you annotate, entail a fair amount of work.
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-click to format may not work; right click and select
from the menu