Charts
Charts are visual representations of data. Used effectively, they transform worksheets into powerful visuals—helping you identify trends, compare values, and draw insights rapidly and efficiently.
In this section:
| Section | Description | |
|---|---|---|
| Bar | Compare categories using horizontal or vertical bars. | |
| Range Bar | Displays a bar for each category that spans from a starting value to an ending value, showing the range covered. | |
| Bullet | Compare a primary value to a target in a compact format. | |
| Line, Area, Spline, Step | Track trends or changes over time with line or filled-area charts. | |
| Scatter, Bubble | Show relationships between two or more numeric values. | |
| Combination | Combine multiple chart types to compare related measures. | |
| Historical | Display time series data with a chart and zoomable timeline. | |
| OHLC, Candlestick | Visualize open, high, low, and close values for financial data. | |
| Waterfall | Show how sequential values affect a total. | |
| Polar | Plot directional or cyclic data in a circular format. | |
| Radar | Compare multiple metrics per item in a web-like layout. |