> ## Documentation Index
> Fetch the complete documentation index at: https://docs.equals.com/llms.txt
> Use this file to discover all available pages before exploring further.

# Charts

> Create professional and modern visualizations of your data

With Equals, it's easy to create professional and modern-looking charts that can be shared individually or via a Dashboard.

You can create the following chart types:

* Line
* Combo
* Scatter
* Area, stacked area, and 100% stacked area
* Column, stacked column, and 100% stacked column
* Bar, stacked bar, and 100% stacked bar
* Pie

<img src="https://mintcdn.com/equals/rY-jt2rKiL-81FoS/images/docs/9f4d1bd5f052c78edd66eee041f34cd072241da2625d98baba152cada05d80db-workspace_23.png?fit=max&auto=format&n=rY-jt2rKiL-81FoS&q=85&s=b06ac8fba0585f578fca38b01c78ed58" alt="" width="2400" height="1350" data-path="images/docs/9f4d1bd5f052c78edd66eee041f34cd072241da2625d98baba152cada05d80db-workspace_23.png" />

# Creating charts

To get started, select your date range, then go to `Insert > Chart` or use the shortcut `CMD`+`K` and type `Insert chart`. This will insert a default chart into your workbook and open the chart configuration panel.

Charts have the following defaults for a clean look:

* The title and legend are left-aligned
* Y-axis labels but no line
* Horizontal gridlines only
* No data labels are displayed on series
* 'Professional' style (more on styles here)

You can modify these defaults and other settings, including:

* **Type**: Select either Line, Scatter, Combo, Area, Column, Bar, or Pie. Stacked and 100% stacked variations are available for Area, Column, and Bar charts.
* **X-axis**: Set a specific metric for your X-axis, which will define the data point intervals.
* **Series Selection**: Click on the series from to edit how they are displayed in your chart.

# Customizing Charts

You can configure the look and feel of each aspect of your chart to suit specific use cases.

There are 5 aspects of your chart that you can configure:

1. Chart
2. Series
3. X-axis
4. Left Y-axis
5. Right Y-axis

## Chart

Here, you can configure your chart's style, colors, legend, and title.

### Styles

First, choose from one of the two available *styles*:

* **Modern**: A bold look and feel with rounded edges, smoothed lines, and grey axes.
* **Professional**: A classic look with straight edges and lines, tick marks, and black axes.

### Colors

Next, choose a *color scheme* for your chart. The options will vary based on your selected chart style:

* **Bright** or **Cool** colors (Modern style)
* **Business** or **Basic** (Professional style)
* **Purple** or **Stone** for a monochromatic look (both styles)

<img src="https://mintcdn.com/equals/i4fADVD49syZwhQ2/images/docs/1228cdc-chart-styles-colors.png?fit=max&auto=format&n=i4fADVD49syZwhQ2&q=85&s=112e06644a0764e20b1cf2e969f8960c" alt="" width="2400" height="1350" data-path="images/docs/1228cdc-chart-styles-colors.png" />

Once a color scheme has been applied to a chart, you can change the color of individual series from a set of defaults or add your own custom colors.

You can also create your own custom colors schemes that are shared across your Equals Workspace. To do so, select *Add style* from the *Color* drop down, then hit the `+` icon to add your chosen set of colors. Once saved, your custom color scheme can be applied to charts in any Workbook and used by other members of your Workspace.

### Title & Legend

Add a *Title* or a *Legend* and modify their position from the sidebar.

### Grid

You can also choose to apply horizontal and vertical gridlines, as applicable based on the type of your chart, for better readability.

## Series

In the `Series` section, you can configure the way series' from your selected data range are displayed in your chart. You can also drag and drop series to re-order them. To get started, click on a specific series to configure.

<img src="https://mintcdn.com/equals/i4fADVD49syZwhQ2/images/docs/602387ffb053bc44a5bdf6461f9503ee4fbe84a76d0e7e030e685648d069c5f6-workspace_24.png?fit=max&auto=format&n=i4fADVD49syZwhQ2&q=85&s=45ee48f559a7a08f3edbf5b71e78006e" alt="" width="2400" height="1350" data-path="images/docs/602387ffb053bc44a5bdf6461f9503ee4fbe84a76d0e7e030e685648d069c5f6-workspace_24.png" />

* If a specific series has been selected, give it a *Name* that will be displayed in the chart's legend.
* Select a *Color*. This will be set based on the chosen color scheme but can be modified to be any color.
* Choose which *Axis* to chart your series on–the Left or Right Y-axis.
* Add a *Trendline* for your chart series and choose from several mathematical models, including Linear, Logarithmic, Exponential, and Moving average
* Decide whether to display *Labels* for each data point in your series and configure their format and positioning.

## Axes

You can configure the appearance of each axis in your chart, including the X-axis, Left Y-axis, and Right Y-axis. In each section you can:

* Add a *Title* for each axis
* Choose to show show a *Line, Tick marks*, and/or *Labels*
* Define the angle at which data labels will be displayed under *Slant label*
* Normalize the way data is displayed by selecting *Log scale* or a specific *Scaling option*. You can also use *Limit* to define min/max values.

# Updating charts

If your chart is built on live data from an underlying [query](https://docs.equals.com/docs/queries), you can enable [auto-expand](https://docs.equals.com/docs/auto-expand) on the chart's data range to automatically refresh it each time the query is run. This will ensure that your charts are up-to-date without the need to manually copy and paste data or expand data ranges.

To manually update your chart, you can manually insert data into the chart's selected data range. You can also adjust your data range to reflect new rows of data in your Workbook by selecting `Edit` in the top right corner of the chart, and then editing the `Data range` input.

# Sharing charts

There are a few options for sharing and distributing charts:

* Add your chart to a [Dashboard](https://docs.equals.com/docs/building-and-sharing-dashboards) that can be auto-distributed to your team via Slack or email on a set schedule.
* Download individual charts as a .PNG file by right-clicking and selecting *Download chart*.

***

[Pivot tables](/docs/pivot-tables)

[Filters and sorts](/docs/filters-and-sorts)
