Mixed Chart

A Mixed Chart combines the strengths of Line Charts and Column Charts into a single visualization. It can plot up to three data series simultaneously, making it useful for comparing trends and categories in a single chart.

By overlaying line and column series, Mixed Charts help highlight relationships between discrete values (columns) and continuous trends (lines), providing a more complete perspective.

Best Situations to Use

Use a mixed chart when:

  • You need to compare multiple categories and their relationships.

  • A combination of quantitative values (column) and trends (line) is required.

  • You want to emphasize a key trend series while still showing categorical data.

Examples:

  • Analyzing a company’s budget vs. revenue vs. profit margin.

  • Displaying student scores (columns) alongside class proficiency trends (line).

  • Showing sales targets vs. actual sales with performance trendlines.

Variations

Mixed charts can be configured in several styles:

  • Stacked Columns + Line – Combine cumulative values with line trends.

  • Clustered Columns + Line – Show grouped categories with line overlay.

  • Overlaid Columns + Line – Overlay multiple series in a shared space with a trend line.

  • 100% Columns + Line – Normalize values to percentages with an added trend line.

Quick Enhancements:

  • Use stacked columns to answer multiple questions at once.

  • Display columns side by side for easier comparisons.

  • Add colors to highlight important series.

Properties

General

  • Component Name – Auto-generated unique identifier.

  • Position (Left, Top) – Placement coordinates on the canvas.

  • Height / Width – Chart dimensions.

  • Initial Visibility – Show/hide chart on load.

  • Max Button – Enable maximize view.

  • Color From Drill – Apply colors dynamically from drill-down results.

  • Points – Show or hide markers on the line chart.

  • Base Type – Define base (Plain, Rectangle, Cylinder, Gradient).

  • Chart Type – Choose layout (Stacked, Clustered, Overlaid, 100%).

  • Line Form – Select line style (Curve, Segment).

  • Bar Size – Adjust column width and spacing.

Threshold Settings

  • Show/hide threshold lines.

  • Configure upper (Threshold 1) and lower (Threshold 2) values.

  • Enable Fill Threshold to highlight area between values.

  • Customize fill color, opacity, and labels.

Annotation Settings

  • Enable annotation lines to mark significant points/events.

  • Manage annotation dataset: Connection, Label Field, Annotation Field.

  • Configure line color, width, opacity, and dash style.

  • Add tooltip titles for annotations. ⚠️ Note: Annotation mapping works with CSV and Excel data only.

Tooltip

  • Supported options: None, Default, Custom.

  • Customize tooltip background, opacity, border, font size, box width, and precision.

  • Enable highlighter mode to emphasize data points.

Background & Styling

  • Gradient rotation, opacity, and multiple color options.

  • Borders (color, radius, width).

  • Shadows with configurable color and transparency.

Title & Subtitle

  • Show/hide title and subtitle.

  • Customize text (color, font size, style, weight, alignment, decoration).

  • Option to pull dataset descriptions dynamically.

Axes

X-Axis

  • Show/hide axis line.

  • Customize label font (color, size, style, weight, rotation).

  • Tilt labels for readability.

  • Add tick marks and dataset descriptions.

Y-Axis

  • Show/hide axis line.

  • Customize labels (color, size, style, weight).

  • Add axis descriptions and dataset labels.

Second Axis

  • Enable a secondary Y-axis for additional series.

  • Customize units, precision, currency format, and number style.

  • Configure min/max values and auto scaling.

  • Add Zero Marker Line and customize its color.

Legend

  • Show/hide chart legend.

  • Customize font (color, size, style, weight).

  • Option to hide legend on load.

Formatter

  • Units (%, $, count).

  • Precision (decimal places).

  • Currency formatting.

  • Number format (Indian/International).

Axis Setup

  • Auto Axis Setup – Automatically scale axis.

  • Base Zero – Ensure axes start at zero.

  • Min/Max Values – Manually set ranges.

  • Add marker lines (horizontal, vertical, or zero).

  • Customize marker color and opacity.

Export Options

  • Enable context menu for quick export.

  • Supported formats: Excel, CSV, JPEG, PNG, PPT, PDF, Print.

  • Configure export heading, subheading, and file name.

  • Define global export type (Screenshot or Tabular).

Dataset Series Properties

  • Configure fields: Name, Display Name, Axis.

  • Customize color, chart type (Line or Column), and point shape.

  • For Line series: set line width and style.

Variants by Property Customization

  • Stacked Chart + Line:

    • Plain, Rectangle, Cylinder, Gradient 1–3 bases.

    • Line can be Segment or Curve.

  • Clustered Chart + Line:

    • Plain, Rectangle, Cylinder, Gradient 1–3 bases.

    • Segment Line overlay.

  • Overlaid Chart + Line:

    • Plain, Rectangle, Cylinder, Gradient 1–3 bases.

    • Segment Line overlay.

  • 100% Chart + Line:

    • Plain, Rectangle, Cylinder, Gradient 1–3 bases.

    • Segment Line overlay.

Example Use Cases

  • Finance: Compare company budget, revenue, and profit margin.

  • Sales: Track targets vs. actuals vs. performance trends.

  • Education: Show student scores by subject alongside overall proficiency trend.

  • Marketing: Analyze ad spend (columns) vs. engagement (line).

Sample Data Setup:

  • Category Field: Year (or time-based/categorical field).

  • Series Fields: Multiple numeric series (e.g., Budget, Revenue, Expenses).

9KB
Sample Data_Mixed chart.xlsx
Open

⚠️ Note:

  • Category fields can be string, numeric, or date.

  • Series fields must be numeric.

PreviousMito PlotNextPie Chart

Last updated