need graphs to change when another cell is selected - Dashboard

Hmm.. That's funny.
Works fine. See attached file.
Double click to choose category to display.

Into Sheet2 tab code:

Please Login or Register  to view this content.

then based on B4 (choosen category) data series to display is 'shifted' in table I:AG, like:

ex. cell J4:

Please Login or Register  to view this content.

as I said its shifting data in table.
Hide this table which you are using for chart (with shifted values in cell) and show new table without any changes while clicking.
Do you know what I mean?

EDIT: if you don't want to create new table, use Dasboard table as picture and cover 'shifted' table like in attached file.
(Sorry I can resist to change colour of column on chart 1 based on category, it easy to reverse it).

Hi Kokosek

thanks that it brill , can you remove the colour change on the graph please

Dougers

Ps is it possible to select the catergory without a doubleclick

Please Login or Register  to view this content.

Without doubleclick, just activate cell.
No more chart color changes.
Apply it back as you wish.