Excel Report for Many Departments 3

[shelby55]

Hi

I am using Excel 2003 to develop an automated template. The data will come from queries in an Access database.

My plan is to have a page of the Excel worksheet designated for the raw data that will populate the graphs on the report page. The report page will be fashioned like a dashboard.

The reason for this post to ask about format. The data will be queried by month and department. Can the raw data be split out like this as well and the graph change according to what department is selected in a pull down list? How would you create such a thing for multi-departments? Thanks.

 

[xlbo]

and an extra star to Skip for his persistence!!

I am not an expert, clearly, but this is a helping forum, not just for people with advanced skills.

Actually, Tek-Tips is:

INTELLIGENT WORK FORUMS
FOR COMPUTER PROFESSIONALS

Unlike say expertsexchange or other such sites, Tek-Tips prides itself on not just giving answers but helping people to unserstand. The colliary to that is that people who ask questions should be willing to try to learn for themselves as well.

you are right that this forum is not just for people with advanced skills but it may be more tiered towards people that want to gain advanced skills rather than just get an answer to a question. You certainly seem to be in the former category so please don't take this as an attack - it is more a defence of Skip and the ethos of the site which I belive he upholds to a great degree



Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question