With this setting, you can select a chart type for the specific series. Choose between three chart types to better represent your data:
- Columns: Each value will be represented by a column. Best used to represent independent values for direct comparison.
- Line: A continuous line will connect all values in the series. Best used to represent change between values.
- Area: Similar to Line, but with a color or gradient fill. Best used for stacks of multiple series, or as a background element.
- Reference Line: Represents a specific value, average, target, or benchmark. It is well suited for use with conditional formatting, as it helps viewers quickly interpret how the data relates to that point
You can mix and match various chart types for multiple series to create unique combinations for your specific use case.

Was this helpful? Thank you for your feedback!
Sorry about that.
How can we improve it?