Follow the steps below to configure a Column Chart with dynamic series. If you are unsure if a Dynamic Series is right for your usage please consult the example here.

 

1. Select the Style of Chart you would like to work with.

 

Figure 1: The 3D column chart style is selected.

 

2. Select the Switch to Dynamic Series button. NOTE: You will be warned that you will lose any configurations at this point. You can, additionally, switch back to a static series configuration at any point.

 

Figure 2: The Dynamic Series button in the insert chart dialog.

 

3. Select the Field that you want to be presented on the Category Axis ( X-Axis) from the drop down list of available fields.

 

Figure 3: The Occupation field was selected for the Category Axis.

 

4. Select the Field that you want to be presented on the Value Axis ( Y-Axis) from the drop down list of available fields.

 

Figure 4: The sum of the Internet sales will be used as the value for the chart.

 

5. If needed change the function of the Value Axis by selecting the summation button.

 

Figure 5: The list of available function types.

 

6. You will need to select the dimension whose values will be used to create the series dynamically.

 

Figure 6: The year was selected to be the series Field.

 

7. Once you have configured all of your series all of your Chart, you may need to apply a local filter to your data. Visit this helpful page to learn more about applying a local filter.

 

Figure 7: The edit filter button in the Insert Chart Dialog.

 

8. You are able to enter a Caption for the Chart in the Properties section if needed.

 

Figure 8: A caption has been added to the Chart.

 

9. Once you have set up the Dynamic Series select Insert and the chart will be inserted in to the design surface.

 

Figure 9: The resulting table inserted into the design surface.

Next Steps

Chart Properties - Learn about how to edit and customize your chart after inserting it into the design surface.

Include or Exclude Widgets - Learn how to exclude widgets from your dashboard without deleting it all together.

Resizing Widgets - Learn how to resize your widgets in the design surface.

Repositioning Widgets - Lean how to reposition your widgets after inserting into the design surface.