See attached - I have 4 graphs that I have 2 different Process Steps locked in each and then want the user selections of FY and Service Area to apply. When I use the '$' in the code, I get the same data for all graphs even though they should be different because they are looking at different steps.
I think the issue is related to selections on a graph on another sheet(tab) in my dashboard. There is a bookmark for the Dashboard tab when the doc is opened to select Ticket Created And Routed for that tab.
If you instead select the same 2 steps as in one of the NPrinting tabs like Routed and Fully Approved, the numbers on the Dashboard tab charts should match those on CH151 and CH152 on the For NPrinting tab.
NPrinting has a way to "Clear All Selections" when connecting to the source data but when I did that, nothing came across because even the locked field selections were cleared. Ugh. Any ideas?
Taking a step back from what you have and lets talk about your requirement? What selections are needed for all charts and which ones are only needed for specific charts? Right now, I am very confused as to what exactly is needed.
If you look on the NPrinting tab, you will see 2 process steps that are locked for each pair of graphs. Those have alternate states applied based on which steps are selected. The FY and SERVCIE_AREA selection would then need to be applied to all of the charts in addition to the locked fields.
In Contrast, the graph on the Dashboard tab is responsive to 2 process steps selected by the user and are not locked.