Microsoft Office Tutorials and References
In Depth Information
3. On the Design tab, in the Data group, click Select Data .
The Select Data Source dialog box opens.
4. In the Legend Entries (Series) area, click Year .
5. Click Remove .
The Year series disappears.
6. In the Horizontal (Category) Axis Labels area, click Edit .
The Axis Labels dialog box opens.
7. Select cells B3:B9 , 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.