Menu
![]() From the Design tab, Data group, select Select Data. ![]() From the Chart Tools, Layout tab, Current Selection group, select the Horizontal (Category) Axis.Make sure that you select the headings as well as the data before you create your chart. In the Series name box, enter the cell reference for the name of the series or use the mouse to select the cell, click OK.Īrrange your data so that headings are directly above and to the left of the data to be charted.In the dialog box under Legend Entry Series, select the first series and click Edit.In the Axis label range enter the cell references for the x-axis or use the mouse to select the range, click OK. ![]()
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |