> ## Documentation Index
> Fetch the complete documentation index at: https://dune-automated-update-duneapi-openapi-files.mintlify.site/llms.txt
> Use this file to discover all available pages before exploring further.

# Charts and Graphs

> Create bar charts, line charts, area charts, scatter charts, pie charts, and mixed visualizations from query results.

Visualizations make your data come to life. You can create a visualization from any query result to surface trends, compare metrics, and share insights visually.

<Tip>
  Watch our [visualization tutorial video](/resources/learning/video-tutorials#creating-graphs--charts) to see how to create charts step-by-step.
</Tip>

## Chart Types

Dune supports the following chart types. You can mix multiple types in a single visualization — for example, combining bars and lines — as long as your base chart is not a pie chart. Expand each type below to see an example.

<AccordionGroup>
  <Accordion title="Bar Charts" icon="chart-bar">
    <img src="https://mintcdn.com/dune-automated-update-duneapi-openapi-files/uJw7BXgjXDjXwgMu/web-app/images/charts-graphs/bar-chart-example.png?fit=max&auto=format&n=uJw7BXgjXDjXwgMu&q=85&s=8f1d6494adfb7d864381f58306f0208a" alt="bar chart example" width="1230" height="230" data-path="web-app/images/charts-graphs/bar-chart-example.png" />
  </Accordion>

  <Accordion title="Area Charts" icon="chart-area">
    <img src="https://mintcdn.com/dune-automated-update-duneapi-openapi-files/uJw7BXgjXDjXwgMu/web-app/images/charts-graphs/area-chart.png?fit=max&auto=format&n=uJw7BXgjXDjXwgMu&q=85&s=eb9566142662f6ebc653d19684535aeb" alt="area chart example" width="1230" height="230" data-path="web-app/images/charts-graphs/area-chart.png" />
  </Accordion>

  <Accordion title="Scatter Charts" icon="chart-scatter">
    <img src="https://mintcdn.com/dune-automated-update-duneapi-openapi-files/uJw7BXgjXDjXwgMu/web-app/images/charts-graphs/scatter-chart-example.png?fit=max&auto=format&n=uJw7BXgjXDjXwgMu&q=85&s=fd0e581f0386cecc7af5c9450d0ebcda" alt="scatter chart example" width="1230" height="230" data-path="web-app/images/charts-graphs/scatter-chart-example.png" />
  </Accordion>

  <Accordion title="Line Charts" icon="chart-line">
    <img src="https://mintcdn.com/dune-automated-update-duneapi-openapi-files/uJw7BXgjXDjXwgMu/web-app/images/charts-graphs/line-chart-example.png?fit=max&auto=format&n=uJw7BXgjXDjXwgMu&q=85&s=1bccdfe140f3e951a05c6df07c6b9b0a" alt="line chart example" width="1230" height="230" data-path="web-app/images/charts-graphs/line-chart-example.png" />
  </Accordion>

  <Accordion title="Pie Charts" icon="chart-pie">
    <img src="https://mintcdn.com/dune-automated-update-duneapi-openapi-files/uJw7BXgjXDjXwgMu/web-app/images/charts-graphs/pie-chart-example.png?fit=max&auto=format&n=uJw7BXgjXDjXwgMu&q=85&s=3e1fdf623f77fa2b6d16b794eb6b4c87" alt="pie chart example" width="1230" height="230" data-path="web-app/images/charts-graphs/pie-chart-example.png" />
  </Accordion>

  <Accordion title="Mixed Graphs" icon="chart-column">
    <img src="https://mintcdn.com/dune-automated-update-duneapi-openapi-files/uJw7BXgjXDjXwgMu/web-app/images/charts-graphs/mixed-graph-example.png?fit=max&auto=format&n=uJw7BXgjXDjXwgMu&q=85&s=d100f9fcd1635c8e1865c313fa48ebe9" alt="mixed graph example" width="1230" height="230" data-path="web-app/images/charts-graphs/mixed-graph-example.png" />
  </Accordion>
</AccordionGroup>

## Visualization Configuration Options

All chart types share a common set of configuration options. Use the tabs below to learn how to customize each aspect of your visualization.

<img src="https://mintcdn.com/dune-automated-update-duneapi-openapi-files/uJw7BXgjXDjXwgMu/web-app/images/charts-graphs/all-visualization-configuration-options.png?fit=max&auto=format&n=uJw7BXgjXDjXwgMu&q=85&s=e46be95801798c853b51edb8d7281810" alt="all visualization configuration options" width="1377" height="1131" data-path="web-app/images/charts-graphs/all-visualization-configuration-options.png" />

<Tabs>
  <Tab title="Chart options">
    This section allows you to define how to display your data.

    <img src="https://mintcdn.com/dune-automated-update-duneapi-openapi-files/uJw7BXgjXDjXwgMu/web-app/images/charts-graphs/graphs-4.png?fit=max&auto=format&n=uJw7BXgjXDjXwgMu&q=85&s=834c2869ff831a31a084fbe7ff9b98c3" alt="see explanations below" width="350" height="239" data-path="web-app/images/charts-graphs/graphs-4.png" />

    **Title**

    * The title will appear in all instances of this graph prominently at the top.
    * The graph will always keep the name of the Query, even if you edit this.

    **Show chart legend**

    * Ticking this box will enable or disable the legend for the chart.

    **Enable stacking**

    * If applicable, ticking this box will stack the chart values on top of each other based on the x-axis values.
    * If this is not turned on, the values will be plotted individually on the y-axis.
    * The calculation underpinning this will always group the value corresponding to one value on the x-axis. Make sure your data is clean in able for this to work (avoid gaps in your data).

    **Normalize to percentage data**

    * This will normalize the chart to display percentage values of the chosen data table.
    * The calculation underpinning this will always group the value corresponding to one value on the x-axis. Make sure your data is clean in able for this to work (avoid gaps in your data).

    **Show data labels**

    * Ticking this box leads to the display of the individual datapoints inside of the graph.
    * This only makes sense in cases where you have few datapoints that are spread out far enough from each other to not overlap.
  </Tab>

  <Tab title="Result data">
    Here you can pick the data points that are to be displayed.

    <img src="https://mintcdn.com/dune-automated-update-duneapi-openapi-files/uJw7BXgjXDjXwgMu/web-app/images/charts-graphs/graphs-5.png?fit=max&auto=format&n=uJw7BXgjXDjXwgMu&q=85&s=53b9797b2eb3de20027892098e46e190" alt="see explanations below" width="341" height="193" data-path="web-app/images/charts-graphs/graphs-5.png" />

    You can choose one **x-axis** and multiple **y-axis.**

    Alternatively, you can also choose one data series on the y-axis and choose to group it by a different column of your table (as shown in the example above).
  </Tab>

  <Tab title="X-axis options">
    Using these options you can influence how your x-axis data gets displayed.

    <img src="https://mintcdn.com/dune-automated-update-duneapi-openapi-files/uJw7BXgjXDjXwgMu/web-app/images/charts-graphs/graphs-6.png?fit=max&auto=format&n=uJw7BXgjXDjXwgMu&q=85&s=04235e9ccc3a5076c377e821e985f7ed" alt="see explanations below" width="340" height="228" data-path="web-app/images/charts-graphs/graphs-6.png" />

    **Axis title**

    * This field allows you to specify a title for your x-axis.

    **Sort Values**

    * by ticking this box you can specify if you want the values in your chart to be ordered.
    * If your x-axis is a time series, this will automatically happen.

    **Reverse value**

    * Ticking this box will reverse the order of the values on the x-axis.

    **Logarithmic**

    * Ticking this box will make your x-axis values display \_\_ logarithmically.
  </Tab>

  <Tab title="Y-axis options">
    With these options you can influence how your y-axis data gets displayed.

    <img src="https://mintcdn.com/dune-automated-update-duneapi-openapi-files/uJw7BXgjXDjXwgMu/web-app/images/charts-graphs/graphs-7.png?fit=max&auto=format&n=uJw7BXgjXDjXwgMu&q=85&s=a4f28c5b859dc3d915679fe5b0f10664" alt="see explanations below" width="337" height="224" data-path="web-app/images/charts-graphs/graphs-7.png" />

    **Axis title**

    * This field allows you to specify a title for your y-axis.

    **Logarithmic**

    * Ticking this box will make your y-axis values display logarithmically.

    **Enable right y-axis**

    * Ticking this box will enable an additional y-axis that you can plot values on.
    * You can choose in the [chart series section](web-app/visualizations/charts-graphs#ordering-your-series) what you want to be displayed on the left and right axis.
  </Tab>

  <Tab title="Series options">
    <img src="https://mintcdn.com/dune-automated-update-duneapi-openapi-files/uJw7BXgjXDjXwgMu/web-app/images/charts-graphs/graphs-9.png?fit=max&auto=format&n=uJw7BXgjXDjXwgMu&q=85&s=cb6c17befcf5ef9025948d9dab4b0050" alt="" width="1431" height="142" data-path="web-app/images/charts-graphs/graphs-9.png" />

    In this section of the Visualization editor you can finalize your graph.

    * You can rename the "series" by simply clicking into the field.
    * You can change the chart type by clicking into the dropdown.
    * You can change the colors by clicking into the color box.
    * Finally you can also change the order of the series.

    **Picking Colors**

    You can pick colors with your browser native color selector.

    This might look slightly different for you depending on which browser you use.

    <img src="https://mintcdn.com/dune-automated-update-duneapi-openapi-files/uJw7BXgjXDjXwgMu/web-app/images/charts-graphs/graphs-color.gif?s=f6e6d0aa61d966ecd03c5972a0e59055" alt="Choose any color you want!" width="1920" height="1080" data-path="web-app/images/charts-graphs/graphs-color.gif" />
  </Tab>

  <Tab title="Pie options">
    <img src="https://mintcdn.com/dune-automated-update-duneapi-openapi-files/uJw7BXgjXDjXwgMu/web-app/images/charts-graphs/pie-options.png?fit=max&auto=format&n=uJw7BXgjXDjXwgMu&q=85&s=71951dfeb7e6c2e7d28c1ec88d8ed887" alt="pie options" width="443" height="305" data-path="web-app/images/charts-graphs/pie-options.png" />

    **Label format**

    * This field allows you to define the [tick format](#xy-axis-tick-and-label-formats) of the data labels in your pie chart.
  </Tab>
</Tabs>

### X/Y-axis Tick and Label formats

<img src="https://mintcdn.com/dune-automated-update-duneapi-openapi-files/uJw7BXgjXDjXwgMu/web-app/images/charts-graphs/graphs-8.png?fit=max&auto=format&n=uJw7BXgjXDjXwgMu&q=85&s=12dca85e1413ff7c95302af0f2364778" alt="image" width="482" height="367" data-path="web-app/images/charts-graphs/graphs-8.png" />

Tick formats change how numeric values and axis labels in your graphs are displayed.

Here's how to format them:

| Starting Value | Tick/Label format | Output          | Description                                                                                                                                                         |
| -------------- | ----------------- | --------------- | ------------------------------------------------------------------------------------------------------------------------------------------------------------------- |
| 1256784.3745   | `[blank]`         | 1256784.3745000 | Displays the number 7 decimal precision.                                                                                                                            |
| 1256784.3745   | `0`               | 1256784         | Displays only the integer.                                                                                                                                          |
| 1256784.3745   | `0,0`             | 1,256,784       | Only displays the integer with comma separation.                                                                                                                    |
| 1256784.3745   | `0,0.00`          | 1,256,784.38    | Displays the number with `[x]` decimal precision, where `[x]` is the number of `0` you add after the decimal point.                                                 |
| 1256784.3745   | `0.0a`            | 1.2M            | Displays the number with `[x]` precision and a letter based on the number's `1e[y]` power (eg "m" for million, "b" for billion)                                     |
| 1256784.3745   | `$0.0a`           | \$1.2M          | Adds a "\$" to the number. Works with all formats above though use of the `a` suffix is recommended. Currently the only "\$" is the only supported currency symbol. |
