I'm looking for advice on better graphing software.
Specifically, I'm responsible for running reports and disseminating information on health and human service needs in my region. We have a fairly rigid taxonomy (AIRS taxonomy if any of ya'll know it) that's got somewhere between 9 and 10 thousand terms, with terms strictly correlating to a specifically defined need. This allows for a great deal of granularity and makes searching for programs easier, but it makes giving people a good accounting of trends MORE difficult because broad trends get diluited--for instance, there's at least 1,000 medical taxonomies tracking different medical needs, vs five or six for utilities (water, gas, electric, heating fuel [think propane]). So I'm working on categorizing needs in terms of broad levels, and using charts to demonstrate broad trends--BUT I'd like to be able to click on relevant section (Say a section labeled utilities) and have that link to a subgraph (say a chart showing which type of utility was most requested). The ability to do or two layer would be better even; say, there's a section called "Medical" on a pie chart, I click it, it resolves down to a chart showing "Dental, Vision, Reproductive" and then I could click on THOSE sections to break them down even more.
Or even an ability to do stacked bar graphs for broad terms, with each one broken down into it's components would be better than what I have now. We have Excel and Word, and they can do basic charts and graphs pretty well, but I've been unable to achieve this functionality. I can do a stacked bar graph but the labeling abilities in Excel seem too limited for what I need.