I have a set of data which can be represented either by State or Week, I would like to the user to be able to choose which representation they would like by choosing from a combo box which would in turn change the switch coloumn/row option in the select data option. I dont know how to reference the combobox linked cell to this option - any help would be much appreciated, I have attached a spread sheet with the data set and format of graphs I would like, both graphs come from the same data - I only want one to be visible in my report.
Thanks in advance.
Bookmarks