Hide Lines in a graph chart

[psk180590]

Hello All,

I have a requirement where i would like display the graph indicating sales of the whole country by default, and upon selection of a particular state the graph of that state should be displayed along with country graph. And at last the city graph should also be on the same lines as state graph.

Could you please provide me any pointers on doing this.

Thanks much. Wish you all a nice weekend!!

[kamal_sanguri · Accepted solution]

No selection-

with state selection -

with city selection-

I have change it a way that when you select a state the dimensions changes to City.. if we keep it state the selected sate would be visible as a point in overall line ( which might not be so informative)

something like this;