Instead of having 14 individual charts and then adding them to a drop-down layout, is it possible to have 1 chart with all 14 categories in a drop-down (filter).
For example the first chart on the following page has 14 individual charts (Canada, 10 provinces and 3 territories). We had to create a total of 14 individual charts.
Instead of having individual charts, is it possible to create 1 chart with all of the information for the 14 charts in one data file and then have a drop-down filter within the 1 chart? This way the user can pick and choose which ones they want to see and then the designer only has to create 1 chart.