Building Charts in Microsoft Dynamics NAV 2015

EBS customers often ask us how they could build their own charts in Microsoft Dynamics NAV 2015. There are a few ways NAV users can achieve that.

These are:
–          Show as Chart feature
–          Generic Charts
–          Charts in Excel

1.       Show as Chart Feature
Nearly all the list pages in Dynamics NAV 2015 have an action button to show the list in either a list or a chart view. Below is an example of the item list page. You need to select the measure (Profit %) and the dimension (Product Group Code). You can then filter the list to only see the items with a product group code. This shows you a graphical view of the % profit by item group.

Building Charts in Microsoft Dynamics NAV im1
Right clicking on the chart, gives you the option to save the chart, print it or customise it.
The same type of graph can be built on the customer list to show the sales by customer group for example.

2.       Generic Charts
To show the chart on your role center, it needs to be saved under the Generic charts. Out of the box, NAV 2015 has a few charts you can customise (eg. customer per salesperson).
In the below example I’ve created a new chart called Customer Sales vs. Profit by Location

Building Charts in Microsoft Dynamics NAV im2

 

To view this chart, add it to the Role centre (click on Blue button at the top left –> Customize–> Customize this page–> Chart part–> Add. Select the Blank chart–> Customize part–> Select T39-01–> Click on OK). Now we see the above chart part in the role centre:

Building Charts in Microsoft Dynamics NAV im3

3.       Charts in Excel
The lists can also be exported to Excel (CTRL+E).  Use Power View to generate map charts.

Building Charts in Microsoft Dynamics NAV im4.jpg

 

 

 

 

 

 

 

 

 

Microsoft Dynamics NAV 2015 offers a few simple ways to build your own charts in a few clicks.

This blog post was written by Mathieu Kalck, Dynamics NAV Consultant at EBS. 

 

If you have out-dated business software that’s limited in its reporting and analytical capabilities – then you should to talk to EBS about a powerful business management software solution – Microsoft Dynamics NAV. To find out more about Microsoft Dynamics NAV, please call Paul Woods at EBS for an obligation free discussion on 1300 303 973, email info@ebsys.com.au or visit ebsys.com.au

Microsoft Dynamics NAV is global enterprise resource planning (ERP) software that helps more than 100,000 companies worldwide manage their accounting and finances, supply chain, and operations. Start with what you need now, and easily adapt as your business needs change. In the Microsoft cloud or on your servers—the choice is yours.

Evolution Business Systems (EBS) specialises in business management solutions that give you the freedom to focus on your business. Melbourne based EBS does this by automating your core business processes and integrating your specialist business applications to deliver the right financial management solution. With deep expertise in leading financial applications including Microsoft Dynamics NAV and Arrow Financials, EBS works beside clients to ensure their software solves problems rather than creating more. EBS has a detailed implementation strategy that is tailored to customers in terms of timelines, requirements, risks and responsibilities. While it does not sell or support hardware or site network environments, EBS informally partners with selected specialists in these areas to provide clients with a “total solution”.

Subscribe here to get our free EBS monthly enewsletter to get the latest news from Microsoft Dynamics NAV.