How to Build a Three-Dimensional Chart in Microsoft Dynamics NAV

Last week’s blog on Creating Advanced Charts in Dynamics NAV dealt with two-dimensional charts, but you can also add a third dimension. Select one Amount and one Dimension from the lower right as before. Then select another Dimension from the lower left-hand corner. 

chart8

Here we have a chart that shows Sales Order Amount by Salesperson and State: 

chart9

If you left click on the chart, you can move the chart’s angle to change the view to your liking.

If you want to print this chart or save it to imbed in a document, right click on the chart and the Print and Save Picture As options will appear.  To save the chart in Dynamics NAV, select Customize.

chart10

This brings you to the Generic Chart Customization where you can add an Axis Title and a chart Description. Then click on Copy Chart in the ribbon to save. 

chart13

Fill in a New Chart ID and Title.

chart14chart15

To see where the chart is now saved, go to Departments > Administration > Application > Setup > RoleTailored Client > Generic Charts, or do a Ctrl + F3 search for Generic Charts.  

chart16

Now, if you want to insert this chart on a FactBox or Role Center, the chart will be available in the list. Read my blog on Adding Charts to Role Centers and List Pages in Microsoft Dynamics NAV for details on that process.

Customizing a Generic Chart in Dynamics NAV

You can also create a chart from scratch.  Go to Generic Charts and select New on the ribbon to be taken through the customization.

chart18

The Generic Chart Customization has many options in which to create charts that track your important business metrics.  For instance, take look at the following choices for Aggregation and Graph Type to get a feel for what’s available: 

chart19chart20

chart21

You can also select multiple measurements in the Data Column, as you can see here:

chart22

Overall, there are multitudes of available combinations in which to experimentHopefully, this information gives you confidence to begin creating charts and provides a foundation to build more complex charts in the future. Happy charting!