Skip to main content

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:

SectionDescription
BarCompare categories using horizontal or vertical bars.
Range BarDisplays a bar for each category that spans from a starting value to an ending value, showing the range covered.
BulletCompare a primary value to a target in a compact format.
Line, Area, Spline, StepTrack trends or changes over time with line or filled-area charts.
Scatter, BubbleShow relationships between two or more numeric values.
CombinationCombine multiple chart types to compare related measures.
HistoricalDisplay time series data with a chart and zoomable timeline.
OHLC, CandlestickVisualize open, high, low, and close values for financial data.
WaterfallShow how sequential values affect a total.
PolarPlot directional or cyclic data in a circular format.
RadarCompare multiple metrics per item in a web-like layout.