Microsoft Chart Advisor chart selecting process is based on an automated approach. A rule engine scans your data and calculates a score based on the rules and a so called popularity index. I have my doubts that such a full automated approach will help users selecting the appropriate chart type. Charts that are popular but not effective, like the pie chart, will get a high score.
You should have a look on another Excel Chart tool, Chart Tamer:
Chart Tamer is flowing a different philosophy, respecting Alan Coopers rule “Imagine users as very intelligent but very busy.” Chart Tamer asks you some questions about the relationship you want to display and how you want to emphasize your data. Finally Chart Tamer offers you a selection of charts that makes sense in this context.
Microsoft Chart Advisor chart selecting process is based on an automated approach. A rule engine scans your data and calculates a score based on the rules and a so called popularity index. I have my doubts that such a full automated approach will help users selecting the appropriate chart type. Charts that are popular but not effective, like the pie chart, will get a high score.
You should have a look on another Excel Chart tool, Chart Tamer:
http://www.bonavistasystems.com/Products_ChartTamer_Overview.html
Chart Tamer is flowing a different philosophy, respecting Alan Coopers rule “Imagine users as very intelligent but very busy.” Chart Tamer asks you some questions about the relationship you want to display and how you want to emphasize your data. Finally Chart Tamer offers you a selection of charts that makes sense in this context.
Andreas