Charts in designer fall into four groups: Single-axis, Multi-axis, Special, and Combo charts. Each chart type supports certain properties and you will see different options depending on the chart type you’ve selected. While some types of charts use X and Y axes, others use data groups. Some charts also provide additional options, such as stacking type property in bar and area charts.
Keep in mind that your data range must in a certain layout to display them on different chart types. This means that the table named range to be used in a specific chart must have fields that can be selected for that type. For example, the Y axis fields of a Line chart should be numeric fields.
The first type is the charts with a single axis. These charts are best used to show the contribution of an individual item to the entire data set. Donut, Pie, Funnel, and Pyramid charts fall into this category.
The second consists of charts with two axes that are perpendicular with each other. Line, bar, column, and scatter charts are examples of this type. These types of charts are best used to show a trend over time or other numeric value.
The next type is special charts. Special charts vary from the first two groups based on their general layout. Charts like the Bubble and Gantt can be considered in this group. These charts excel at displaying data in a more specific structure. For example, a Gantt chart requires the table named range selection to have a column for Tasks, Start and End dates, as well as an optional Group field.
The last category consists of only the Combo chart, which essentially allows combining multiple chart types in one visualization. This is done by selecting two different data sets and plotting the data based on different axes. You can configure the chart and axis properties of each data field by selecting them first, and then clicking on that item. The Series Type determines the chart type, whereas the Series Position allows displaying the data on different sides of the chart area.