How to Make an Interactive Chart

Create the Chart
1. Open the saved Excel worksheet.
2. Click and drag the cells for the chart.
3. Click the “Insert” tab on the command ribbon.
4. Click the lower-right arrow for the “Charts” dialog box launcher. The “Insert Chart” dialog box opens with a gallery of chart types.
5. Click the preferred chart style in the left pane. Examples include “Column”, “Pie”, and “Area.”
6. Click the preferred chart sample in the right pane.
7. Click “OK,” then the embedded chart appears on the worksheet with the source data.
8. Click in the chart area to activate the “Chart Tools” ribbon. Customize the chart with the commands in the “Design”, “Layout” and “Format” tabs. The “Design” tab contains “Chart Layouts” and “Chart Styles.” The “Layout” tab contains “Labels” for the chart area. The “Format” tab contains “Shape Styles” with outlines and effects.
Make the Chart Interactive
9. Click the “Review” tab on the command ribbon.
10. Click the “Share Workbook” button or the “Protect and Share Workbook” button in the “Changes” group, then a dialog box opens.
11. Click to check the check box that allows other users to edit this Excel chart.
12. Click “OK.”
13. Save this Excel file. Collaborators can update the worksheet values.