From the Chart Tools, Layout tab, Current Selection group, select the Vertical (Value) Axis.Make sure that the chart is still selected.In the dialog box under Horizontal (Category) Axis Labels, click Edit.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.
#How to restore headers in excel 2016 series#
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.This Excel table can be used like a source for Pivot Tables, list boxes, charts etc. After doing this conversion you will observe that an autofilter drop-downs starts appearing over the header rows. In the Axis label range enter the cell references for the x-axis or use the mouse to select the range, click OK. To recover corrupted Excel file data, we recommend this tool.Listen to John Michaloudis interview various Excel experts & MVPs to get their inisghts & tips. Click here to read our step by step guide on Power Pivot Excel 2016 SEARCH. In the Select Data Source dialog box under Horizontal (Category) Axis Labels, click Edit. Power Pivot in Excel 2016 allows you to harness the power of Business Intelligence right in Excel.There should be no blank rows or columns. 264How can I make an Excel chart refer to column or row headings?Īrrange your data so that headings are directly above and to the left of the data to be charted.
0 kommentar(er)
