Create Charts in Workbooks
You can create a visual representation of data in your workbook using a chart. When you change
the corresponding non-array-based workbook data, the chart automatically updates.
Optionally, you can select to update the chart when unconstrained array data
changes.
If you include dates or times in the chart, make sure you use standard date/time formats;
otherwise, Worksheets doesn't recognize the information as dates.
The maximum number of data points that Worksheets can include in a chart is 100,000.
When creating a chart from pivot table data, keep in mind that charts don't
understand the structure of a pivot table and you might not be able to create a
meaningful chart from a particular set of cells. Additionally, if you have a chart
that displays as you want it to, and later you change the rows, columns, or values
to include in the pivot, you might not be able to chart it.
- Select the cells containing data that you want to use for the chart.
- Select .
- Select the cell where you want the chart to be located, and clickOK.
The chart starts at the selected cell and displays in a merged area of cells. The Chart
Configuration panel displays
Adjust the chart size as needed by dragging the bottom right corner.
In the Chart Configuration panel, select
Auto-update if unconstrained
arrays add or remove rows/columns
to automatically update the chart
if an array size change causes rows or columns to be added or deleted.Use the panel tabs to customize your chart:
- Appearance: Options include 100% stacked area and 100% bar and column chart types, combination charts, legend location, colors, and more.
- Data: Options include labeling the first row and column, size/color, transposing row/column data, adding a benchmark value, editing/reordering/hiding a data series, and more.
- Axis: Options include x- and y-axis titles and title colors, and hiding axis lines.
If you close the Chart Configuration panel, you can open it again by clicking a chart
or by clicking the
Chart
button in the formula bar.