I want to create a scattered plot graph with data that will change depending on a selection of a list.
I already have the dynamic range in a cell, but I can't seem to use the indirect function in the graph, in order to make the data in the graph change.
Can someone please tell me how to make this work?
I already have the dynamic range in a cell, but I can't seem to use the indirect function in the graph, in order to make the data in the graph change.
Can someone please tell me how to make this work?