HDTutorial
EN
How to Change Horizontal Axis Values in Excel 2016

Playback starts YouTube’s embedded player (privacy-enhanced mode).

How to Change Horizontal Axis Values in Excel 2016

672,803 views October 25, 2018 3:30

Watch on YouTube
ChannelAbsent Data Channel

Description from the creator

You can easily change the X-axis values/labels by editing your data labels. You can select new data to replace the existing X values. Check out the written instructions here: absentdata.com/change-the-graph-data-labels-exc…

If your Excel version looks different, here is an alternate way!
youtu.be/9i_Fox0R5-4

Your data is broken up into two dimensions, these are the X-axis and the Y-axis. You can use the information by using the
1.Select Data
2. In the Horizontal (Category) Axis Labels box, click Edit.
3. In the Axis label range box, enter the labels.

Contact me on LinkedIn
linkedin.com/in/gaelimholland

About this tutorial

Absent Data Channel published this 3:30 video tutorial on October 25, 2018. It has been watched 672,803 times on YouTube.

Duration
3:30
Published
October 25, 2018
Views
672,803
Likes
1,135

Share

Further reading

  • Change the scale of the horizontal (category) axis in a chart ... support.microsoft.com

    To change the point where you want the vertical (value) axis to cross the horizontal (category) axis, expand Axis Options, and then under Vertical axis crosses, select At category number and type the number that you wan…

  • Change Horizontal Axis Values in Excel 2016 - AbsentData absentdata.com

    Change Horizontal Axis Values in Excel 2016 Often there is a need to change the data labels in your Excel 2016 graph. The procedure is a little different from the previous versions of Excel 2016.

  • How to Change Axis Values in Excel | Excelchat got-it.ai

    How to Change Horizontal Axis Values. In the example we have a chart with Years on x-axis and Sales values on the y-axis: Figure 1. How to change x axis values. To change x axis values to “ Store” we should follow sever…

This tutorial in other languages