Embedded Files
Charts can be created from worksheet data by selecting the data on which you want to base your chart - including any text to appear as headings or legend text. The easiest way to create a chart is to select the data you want to show in the chart, then click on the Chart icon on the toolbar. You can then change the chart type and all options.
To add a chart to a sheet:
Select the data to be plotted in the chart, ensuring you include any text to appear as headings or legend text. If the text and numbers do not appear in one continuous range, select the first range as normal then hold Ctrl while dragging over each additional range. Ensure all ranges contain the same number of cells.
Click on the Chart button on the toolbar
A simple column chart will be created on the current sheet.
On the right-hand side of the screen, the Chart Editor pane will show two tabs:
The Setup tab controls the chart type and any options that affect the chart as a whole e.g. the axis and series data.
The Customise tab lets you format the selected element of the chart - select the series of the chart to change the colour, select the heading to change the format of that, etc.
Click on the ellipses in the top-right corner of the chart window for additional options to delete the chart, download a copy, publish the chart, copy the chart, move the chart to its own sheet in the workbook, or add alt-text for visually impaired viewers.
Report abuse