How to Change Data Organization in Excel. ... Create a column header row with labels for each of your columns and highlight the first row. Select the "Home" tab of the Ribbon, ...

To change all data labels, click anywhere in the chart. To modify all labels on either the x or y-axis, click anywhere within the data series. To modify a single data label, click on the data label.

To change, edit or rename a Data Series name in Microsoft Excel Graph or Chart without editing the original row or column name, follow this procedure: Open the Excel spreadsheet to find the chart ...

Although you don't have to format your data as an Excel table, doing so will make life easier if you add more rows or columns, and Excel generally reads data formatted as a table ...