Updating excel 2016 data labels
From the image below, you can see that this graph is based on the index column and the Selected Period column.Our goal is to replace the X axis with data from Date Column.For categorical data, you don’t need to worry about this.Also, you can directly change x values from Select Data Source window. Follow the visuals instructions below or watch the video: Create a graph.Right-click the graph to options to format the graph.In the options window, navigate to Select Data to change the label axis data.Share your Chart Formatting Tricks: What are your favorite chart formatting tricks? My favorite tricks are using text boxes to add rich formatting to charts (example here) and messing with fonts and colors (some rules here).
Our goal is to change the x-axis so that you can delete the x values and replace them with the new values.I have tried formatting the date in 'Axis Options' - First, make sure that you have the Axis Field Buttons showing. It should result in something like the below image.You can format data labels in Excel if you choose to add data labels to a chart.To format data labels in Excel, choose the set of data labels to format.To do this, click the “Format” tab within the “Chart Tools” contextual tab in the Ribbon.
It is displaying the X Axis label as "21-Mar", "22-Mar", etc.