I have a workbook set up where I've got 10 columns (for different demographic age groups), and multiple rows, one of data for each month. This will be an ongoing update... at the end of each month, new data will be added for each of the 10 columns.

There are several different metrics... i.e. several different tables. Each one has 10 columns, same demographics, same titles, etc. Example: 10 columns, one for Kids 2-4, one for kids 5-11, etc. etc.
Row 1 = Jan data, Row 2 = Feb data, etc.
Chart 1 shows the average number of doctor visits for the month; Chart 2 shows the average number of dentist visits for the month; Chart 3 shows the average number of sick days for the month, etc. etc.

I've set up a chart page that has four charts on it that reads off of the data sheets. The charts are on a separate chart page, and this is what is going to be sent out in a distribution list (all other pages will be hidden).

At the top, the user picks the demo they want, and all four charts update and show that demo... If I pick Kids5-11, Chart 1 will show avg doctor visits for this group, chart 2 will show avg dentist visits for the group, etc.

Right now, I've hard coded to show the last 13 months. What I would like to do is a drop down to pick the starting month to show and the final month to show, and the charts update. So someone could look at just the last quarter, last year, last 2 years, etc.

I'm working on this problem, and no good solution yet, so any help would be great... but also have a second problem...

Each time a demo is picked, I need to have a text box at the bottom of the charts page that lists a few bullet points that can be found in the data... i.e. Kid5-10 are picked... the text box needs to come up and say something like "During the winter months, Kids between 5 and 10 go to the doctor less than all other groups." or something like that.

Each demo has their own "bullet" points. And they need to appear at the bottom based on the drop down demo picked.

This need to have a GREAT look to it, etc. Big guys will see it.

I've tried some time of "just typing the message into a cell" and referencing the cell, but always come up with problems. Difficult to format, etc. Plus don't even know how to call the cells.

Also looks at making each text box for the demos a shape (rectangle) and typing bullet points in, but again, don't know how to call the appropriate shape to show up on the charts page.

Anyone able to point me in a good directions to find out good way to do this?

Seems best would be text box approach... ten text boxes, and call the appropriate text box to appear based on the drop down... but can't make it happen.

Any help would be great. Thanks