Check out the below given walk-through on how to use the Mixed chart component in Designer module.
The mixed chart is a combination of line-chart and column chart. It can plot 3- series of data on the chart. Mainly used to emphasize a different series of information on the chart.
To compare multiple categories Example: To analyze the company's budget v/s revenue.
Use stacked Column charts: Where multiple categories can be clubbed together on top of each other which makes addressing multiple questions easier.
Use columns side by side: Where comparison between multiple categories becomes easier instead of toggle between charts and data.
Add color for quick insight: Where displaying columns with colors will make users pay quick attention to important tasks.
The user can enable the Auto axis, the Base Zero value, Horizontal & Vertical marker line, zero marker line and can change the color of lines, increase or decrease the color Transparency by opacity.
The user can change the background color of the chart, can get the border for the chart, and can change the border color, can get the reflection of the chart by enabling the shadow option can also change the color and increase & decrease the transparency of the shadow.
The user can enable the 'Enable Context Menu’ from the preview section to download the reports in different formats. The user can change the heading and subheading of the downloaded charts and the name of the downloaded files from the Export context menu.
The user can change Y-axis values in units to %, T, Lacs, M, etc. Precision if we want the value in decimal format. Currency if we want the value in INR, Pound, USD. Position of the currency if it's in prefix and currency in Rupee then the sign will be seen in left side if it's in suffix then it will be seen in right-side. Number Formatter if we want it in Indian or international.
The user can change the height, width, top, left, chart type, column type & Line form. In this case, we have changed the chart type stacked, base type to plain & line form to segment.
Legend
The user can enable the internal legend if we want to show and can change the font size, color, style, etc.
Second Axis
The user can enable the second axis if we want to show any serial value according to the second axis.
Subtitle
The user can enable the subtitle to display the second title. The user can change the Name, Font color, size, style for the subtitle.
Title
The user can change Title Name, Font color, size, style, etc.
Tooltip
The user can show the description of the series can use the tooltip by enabling it.
X-Axis
The user can change the axis name, Font color, Font size, Enable the axis line, and the axis color.
Y-Axis
The user can change the axis name, Font color, Font size, Enable the axis line, and the axis color.
Dataset Series Properties
The user can change the color of each bar by selecting any of the series. There is an option to change the column type as well. Select either Line or Column options.
Download the given sample data and map it as mentioned below to plot your Mixed chart.
Use the Year column as Category field, and other columns as Series to plot data.