generate_dual_axis_chart
Create a dual-axis chart to compare two quantitative variables using bar and line series. Visualize trends and magnitudes across distinct y-axes for clear data analysis.
Instructions
Generate a dual-axis chart for visualizing two quantitative variables using a combination of bar and line series. Ideal for comparing trends and magnitudes across two metrics with distinct y-axes.
Input Schema
TableJSON Schema
| Name | Required | Description | Default |
|---|---|---|---|
| background | No | Chart background color (hex). Optional, defaults to white. | |
| chartTheme | No | Chart theme. Optional, defaults to 'light'. | |
| colorField | No | Color grouping field. Should not duplicate the dimension field. | |
| colors | No | Color palette for chart elements. | |
| dataTable | Yes | Input data for the dual axis chart, e.g., [{ x: '2018', gmv: 99.9, user: 1200 }]. | |
| height | No | Chart height. Optional, defaults to 500. | |
| leftYAxisHasGrid | No | Show horizontal grid lines for the Y-axis. | |
| leftYAxisHasLabel | No | Show Y-axis labels. | |
| leftYAxisHasTick | No | Show Y-axis ticks. | |
| leftYAxisTitle | No | Y-axis title. | |
| output | No | Chart output type. Defaults to 'image'. | image |
| rightYAxisHasGrid | No | ||
| rightYAxisHasLabel | No | ||
| rightYAxisHasTick | No | ||
| rightYAxisTitle | No | ||
| stackOrPercent | No | Stacking mode: 'stack' for stacked data, 'percent' for percentage stacking. Requires 'color' field. | |
| subTitle | No | Chart subtitle text. | |
| title | No | Chart title text. | |
| titleOrient | No | Title position in the chart. | |
| width | No | Chart width. Optional, defaults to 500. | |
| xAxisHasGrid | No | Show vertical grid lines for the X-axis. | |
| xAxisHasLabel | No | Show X-axis labels. | |
| xAxisHasTick | No | Show X-axis ticks. | |
| xAxisOrient | No | X-axis position in the chart. | |
| xAxisTitle | No | X-axis title. | |
| xField | Yes | Dimension field. Must exist in the data. | |
| yField | Yes |