Plots data in order and stacked by category to represent 100%.

Joins data with lines and a filled area below.

Track changes or trends over time.

Plots data in vertical columns.

Make comparisons between discrete categories.

2D and 3D options are available.

Plots data proportional to the sum of items.

Data points shown as a percentage of the whole.

Smaller values displayed in a secondary bar chart.

Return different TRUE and FALSE results from logical tests

=IF(logical_test,[value_if_true],[value_if_false])

Plots fluctuations in stock prices or other data.

Uses 5 series of values, in order: volume, open, high, low, close.

Data needs to be organized in the correct order.

Remove non-printing characters from a text string.

CLEAN(text)

Plots data in order and joins with a line and a filled area below.

Track changes or trends over time.

2D and 3D options are available.

Plots the distribution of data grouped into frequency bins.

Bin width or count can be adjusted.

Data is shown as continuous with no gaps between bins.

Plots data on a common axis radiating out from the center of the chart.

Useful for plotting responses to questionnaires or performance reviews.

Available in wireframe (with or without markers) or filled versions.

Plots data points for independent and dependant variables.

Often used for scientific, statistical, and engineering data.

Also known as XY chart. Shows patterns in large sets of data.

Plots data in order and joins with a 2D line.

Track changes or trends over time.

3D option is also available.

Plots data in vertical columns and a filled area.

Make comparisons between discrete categories.

Enables charting of values from diverse data sets.