In the Select Data Source dialog box under Horizontal (Category) Axis Labels, click Edit. At the bottom right of the dialog. Make sure that you select the headings as well as the data before you create your chart. There should be no blank rows or columns. 264How can I make an Excel chart refer to column or row headings?Arrange your data so that headings are directly above and to the left of the data to be charted. If the row or column doesnвЂ™t have a header cell, drag to select the cells.If the chart uses rows as series, then you can add only rows if it uses columns as series, then you can add only columns.Add data from a range of cells: Drag over the table cells.Add or remove data from an existing data series: Click the dot for the row or column, then drag the corner of the selection box to include the cells you want.Change the order of data series: In the Format sidebar, click the Series tab, click the disclosure arrow next to Data, then click the Order pop-up menu and choose a data series.Change the data that is plotted in a pivot chart: Click the dot for any column, then choose the Column, Row, or Value data you want to plot.Click Done in the bar at the bottom of the window.

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.Arrange 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

Select Data For Chart Excel Mac