I love using interactive charts in Excel with Checkboxes. I have created the charts before with no problem but this time I am having issues. I have more info to chart and I am trying to figure out how to do this…by the way the report is for survey results.
Each question on the survey would have its own chart. I need each question to show me what the score is by brand and for a certain location by month. So I need to add locations to the charts..so for example I want to see the SCORE for location OCC and brand BREPUBLIC for Question 1??? I currently use check boxes...I have check boxes listed for each QUESTION and by BRAND but how would I add LOCATION to the charting series?
Thanks
Each question on the survey would have its own chart. I need each question to show me what the score is by brand and for a certain location by month. So I need to add locations to the charts..so for example I want to see the SCORE for location OCC and brand BREPUBLIC for Question 1??? I currently use check boxes...I have check boxes listed for each QUESTION and by BRAND but how would I add LOCATION to the charting series?
Thanks
