> ## Documentation Index
> Fetch the complete documentation index at: https://docs.dune.com/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/kuKkfe7NiZRF86tb/web-app/images/charts-graphs/bar-chart-example.png?fit=max&auto=format&n=kuKkfe7NiZRF86tb&q=85&s=e323fb193645f5940f19444c736dc5cd" 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/kuKkfe7NiZRF86tb/web-app/images/charts-graphs/area-chart.png?fit=max&auto=format&n=kuKkfe7NiZRF86tb&q=85&s=bb1999d60c6ab1ce79b14918ceb73743" 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/kuKkfe7NiZRF86tb/web-app/images/charts-graphs/scatter-chart-example.png?fit=max&auto=format&n=kuKkfe7NiZRF86tb&q=85&s=28b819bd3278203ac240a7dedac06a7e" 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/kuKkfe7NiZRF86tb/web-app/images/charts-graphs/line-chart-example.png?fit=max&auto=format&n=kuKkfe7NiZRF86tb&q=85&s=33bea6c207d5690bc2bf3210ea0063a8" 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/kuKkfe7NiZRF86tb/web-app/images/charts-graphs/pie-chart-example.png?fit=max&auto=format&n=kuKkfe7NiZRF86tb&q=85&s=43229f05e1e51df97f4cb92c6a07ab61" 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/kuKkfe7NiZRF86tb/web-app/images/charts-graphs/mixed-graph-example.png?fit=max&auto=format&n=kuKkfe7NiZRF86tb&q=85&s=d37bb037d6450146ab6f62f4350ac53c" 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/kuKkfe7NiZRF86tb/web-app/images/charts-graphs/all-visualization-configuration-options.png?fit=max&auto=format&n=kuKkfe7NiZRF86tb&q=85&s=6b128831df59fad58a588a238c9bc6e3" 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/kuKkfe7NiZRF86tb/web-app/images/charts-graphs/graphs-4.png?fit=max&auto=format&n=kuKkfe7NiZRF86tb&q=85&s=c14da7729ed6a03b96d9734489de4600" 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/kuKkfe7NiZRF86tb/web-app/images/charts-graphs/graphs-5.png?fit=max&auto=format&n=kuKkfe7NiZRF86tb&q=85&s=9d9e60252ec7ad3f2b573af6ef74a963" 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/kuKkfe7NiZRF86tb/web-app/images/charts-graphs/graphs-6.png?fit=max&auto=format&n=kuKkfe7NiZRF86tb&q=85&s=9620928fa2da1e4c85d4a22d633e42b7" 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/kuKkfe7NiZRF86tb/web-app/images/charts-graphs/graphs-7.png?fit=max&auto=format&n=kuKkfe7NiZRF86tb&q=85&s=be04cc6eff5335aebf1f121746fb87f4" 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/kuKkfe7NiZRF86tb/web-app/images/charts-graphs/graphs-9.png?fit=max&auto=format&n=kuKkfe7NiZRF86tb&q=85&s=8676452a80709485858e6643c1e618a9" 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/kuKkfe7NiZRF86tb/web-app/images/charts-graphs/graphs-color.gif?s=53484f9452c7189790f0ddaaf726a75e" 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/kuKkfe7NiZRF86tb/web-app/images/charts-graphs/pie-options.png?fit=max&auto=format&n=kuKkfe7NiZRF86tb&q=85&s=404bf0a9a1ce741c2c97703a4c40d5cf" 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/kuKkfe7NiZRF86tb/web-app/images/charts-graphs/graphs-8.png?fit=max&auto=format&n=kuKkfe7NiZRF86tb&q=85&s=601dbf0f8e58d83d0876907649a3db40" 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. |
