Can you upload your workbook so we can get a look at it?
is this what you are looking for
if so just put sub-cat on color and the filter for the ones you want
If this posts assists in resolving the question, please mark it helpful or as the 'correct answer' if it resolves the question. This will help other users find the same answer/resolution. Thank you.
Thanks for your reply.
In the Line graph, i do not want to select the values manually.
The values should pass from Dashboard to Line Graph.
User can select one value in each sheet included in the dashboard. We have three sheets in the dashboard and that's how we get three values.
Now these three values should be autoselected in the Line graph.