Microsoft Office Tutorials and References
In Depth Information
On the Design tab, in the Data group, click Select Data to open the Select Data
Source dialog box.
In the Legend Entries (Series) area, click Year .
Click Remove to delete the Year series.
In the Horizontal (Category) Axis Labels area, click Edit to open the Axis Labels
Select cells A3:A9 , and then click OK . The Axis Labels dialog box closes, and the
Select Data Source dialog box reappears with the years in the Horizontal (Category)
Axis Labels area.