---
title: "Drill Capability on Charts"
canonical: "https://wiki.yellowfinbi.com/space/user80/1589759/Drill%20Capability%20on%20Charts"
format: markdown
---
> Macro (anchor)



> Macro (toc)

## Overview


Using either the drill down hierarchies or related reports option you can set up drill on charts. This allows users to click on a specific chart section and drill down or through to a related report for more detail. Using this option you can set up charts that drill into more detailed charts or tables, providing users with a greater level of data analysis.



## Setup


Chart drill functionality inherits the drill parameters of the report. Use the standard drill functions to setup the drill parameters for a report.


> See [Drill Down](https://yellowfin.atlassian.net/wiki/spaces/user80/pages/1591676) and [Drill Through](https://yellowfin.atlassian.net/wiki/spaces/user80/pages/1588699) for more information.

**<span style="color: #cc0000">Note:</span>** Ensure that the report drill through parameters and fields are the same that are used in your chart.


## Chart Drill Through Settings

When creating your chart(s) there are a range of options you can apply to enable drill functionality that you have applied to your report.

![image](media://ece2a1b6-e9a7-4597-9492-c8935609389e)


| **Setting** | **Option** | **Description** |
| --- | --- | --- |
| **Drill Enabled** | All | All of the compatible drill through relationships, defined on the Related Reports step of the builder, will be used on this chart. |
| One | Only one of the drill through relationships, defined on the Related Reports step of the builder, will be used on this chart. |
| **Enabled Report** | (Report List) | <span style="color: #000000">Here you can define which Drill Through report relation is used on the chart. All others will be ignored for this chart.</span><br>**<span style="color: #cc0000">Note:</span>** This option is only available when **Drills Enabled** is set to **One**. |
| **Drill Through Relationship** | Automatic | The drill through relationships to be used on this chart will automatically be set up. For this to happen all the join fields defined in each relationship must be a chart component in order for the relationship to link correctly. The defined hyperlink field in the relationship is ignored as the link is automatically applied. |
| Full | The drill through relationships to be used in this report will be set up with whatever link fields are used in the chart, all other defined link fields will be omitted as part of the drill. The hyperlink field will be used as defined in the Related Reports step. |


## Supported Charts


Below is a table of drill functionality by chart type.


**<span style="color: #c00000">Note:</span>** All charts can use **Link To** drilling.


| **Chart Type** | **Chart** | **Drill Down** | **Drill Anywhere** | **Drill Through** |
| --- | --- | --- | --- | --- |
| **Auto Chart** | <span style="color: #cc0000">Select Scenarios</span> | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) |
| **Analytical** | Scatter | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) |
| Histogram | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) |
| Box & Whisker | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) |
| Trellis (<span style="color: #cc0000">Select Scenarios</span>) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) |
| Heat Grid | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) |
| **Area** | Area | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) |
| Area (<span style="color: #cc0000">Time Series</span>) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) |
| Stacked Area | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) |
| **Bar** | Horizontal Bar | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) |
| Horizontal Bar (<span style="color: #cc0000">Time Series</span>) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) |
| 3D Horizontal Bar | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) |
| Stacked Horizontal Bar | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) |
| Stacked Horizontal Bar (<span style="color: #cc0000">Time Series</span>) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) |
| Horizontal Cylinder | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) |
| Proportional Bar | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) |
| **Column** | Vertical Column | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) |
| Vertical Column (<span style="color: #cc0000">Time Series</span>) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) |
| 3D Vertical Column | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) |
| Stacked Vertical Column | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) |
| Stacked Vertical Column (<span style="color: #cc0000">Time Series</span>) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) |
| Cylinder | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) |
| 3D Stacked Column | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) |
| Layered Column | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) |
| **Combination Charts** | Combined Category | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) |
| Combined Category (<span style="color: #cc0000">Time Series</span>) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) |
| Overlay Chart | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) |
| Overlay Chart (<span style="color: #cc0000">Time Series</span>) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) |
| **Financial ** | Financial Line | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) |
| High Low | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) |
| Candlestick | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) |
| **Line** | Line | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) |
| Line (<span style="color: #cc0000">Time Series</span>) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) |
| 3D Line | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) |
| Z Chart | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) |
| Stepped | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) |
| **Map** | Raster Map | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) |
| Google Map | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) |
| GIS Google Map | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) |
| GIS Map | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) |
| GIS Bubble Map | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) |
| GIS Heat Map | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) |
| **Pie** | Pie | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) |
| 3D Pie | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) |
| Multi Pie | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) |
| Ring | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) |
| **Special Purpose** | Funnel | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) |
| Proportional Infographic | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) |
| Comparative Infographic | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) |
| Radar | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) |
| Waterfall | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) |
| Event | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) |
| Week Density | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) |
| Digital Numeric Display | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) |
| Numeric Display | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://5a836d62-3f4a-464a-93ca-c788c1811e31) | ![image](media://60c1c9bb-db02-4969-be24-d1ffdb7bb5f4) |