Getting more out of Excel Reports

Microsoft Dynamics GP V10 delivered 200 out of the box Excel Reports that allow you to quickly generate, modify and save refreshable excel files.  The beauty of this is the ability to create pivot tables and graphs quickly off of Dynamics GP information that is easily refreshable from inside Excel.  Now . . . I’m no graphing guru and I suspect there are many out there that are in the same boat (no Fargo flood pun intended).  Sooooo  here’s a great Office Excel 2007 add-in that suggests different kinds of charts according to the data that is selected.

Based on the data in your spreadsheet, it identifies, ranks, and displays an array of charts most relevant to you so you can make the most out of your information.

chart advisor


Have fun with it.



Comments (3)
  1. From the I nside Microsoft Dynamics GP blog comes word of a new chart advisor tool for Excel that can

  2. Weekly, the Dynamics GP team will be posting a ‘Did you know?’ series.  We’ll give tips, tricks

  3. Andreas says:

    You should have a look on Chart Tamer:

    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.

    Chart Tamer is following 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.


Comments are closed.

Skip to main content