HomeApplicationOffice information

Modify the axis of the chart in Excel

The following article details you how to modify axis of a chart in Excel 2013.

As you know, the graph is made up of 2 x and y axes. The contents of the data displayed on the axes are then displayed corresponding to the axes. Modifying the axes of a chart is a modification of the description team for axial data:

Modify the axis of the chart in Excel Picture 1

To edit the contents of the axes in the chart, do the following (The example here changes the Y axis):

Step 1: Modify the frame of the shaft.

- Click on the axis to modify -> Format -> Shape Styles -> select properties to modify as:

+ Shape Fill: Select the fill color for the frame of the axis.

+ Shape Outline: Select a fill color for the border of the axis.

+ Shape Effect: Select the effect for the frame of the axis.

Modify the axis of the chart in Excel Picture 2

Step 2: Modify the text of the axis:

- Click on the axis to modify -> Format -> WordArt Styles-> select properties to modify as:

+ Text Fill: Select the fill color for the text content of the axis.

+ Text Outline: Select the fill color for the axis text content.

+ Text Effect: Select the effect for the text of the axis.

Modify the axis of the chart in Excel Picture 3

Do the same for the X axis. Notice that the content of the text displayed on the axis cannot be changed, it only changes when its content in the data table changes.

- Results after editing the content of axes:

Modify the axis of the chart in Excel Picture 4

The above is a detailed guide on how to modify chart axes in Excel 2013.

Good luck!

5 ★ | 1 Vote

You should read it

May be interested

  • How to make a thermometer template in ExcelHow to make a thermometer template in Excel
    using a thermometer chart in excel is a good choice for keeping track of financial goals. here are detailed step-by-step instructions on how to make a heat chart in excel.
  • 'Moving' chart in Excel'Moving' chart in Excel
    do you see a motion chart in excel? with a simple, self-created viual basic program, you can make your chart move to look lively. suppose, you have a data table with column a containing the variable x (from a4: a19).
  • MS Excel 2007 - Lesson 10: Modify columns, rows and cellsMS Excel 2007 - Lesson 10: Modify columns, rows and cells
    when you open a new blank workbook in excel 2007, cells, columns, and rows are set to default sizes. you can change the size of each cell, column and row, as well as insert new columns, rows and cells if needed.
  • Detailed instructions on how to graph in excelDetailed instructions on how to graph in excel
    the article will help you learn how to graph in excel and help you manage the data you have.
  • How to create a pie chart in Microsoft ExcelHow to create a pie chart in Microsoft Excel
    pie charts are a great tool for visualizing information. it allows users to see the partial relationship with the entire data.
  • How to draw a bar chart in ExcelHow to draw a bar chart in Excel
    how to draw a bar chart in excel. a bar chart is a chart that is used quite a lot, this is a chart that displays many different types of data with a rectangular column, the longer the bar, the greater the value. there are two types of bar charts: vertical and vertical charts
  • How to create a pie chart in ExcelHow to create a pie chart in Excel
    pie charts are a regular way to show things through data, which help your paper be scientific and attract readers. the following article details how to create a pie chart in excel.
  • How to Make a Pie Chart in ExcelHow to Make a Pie Chart in Excel
    this wikihow teaches you how to create a visual representation of your data in microsoft excel using a pie chart. open microsoft excel. it resembles a white 'e' on a green background.
  • Hide and show chart labels in ExcelHide and show chart labels in Excel
    the following article will guide you in detail how to show / hide chart labels in excel. for example, the following chart is created: 1. want to add revenue details for employees displayed on the chart do the following.
  • How to Create a Multi-Line Chart in ExcelHow to Create a Multi-Line Chart in Excel
    drawing a multi-line chart in excel is very simple! if your spreadsheet has multiple groups of data, you can view the data visually by creating a chart with multiple lines. you can create a new chart or add lines to an existing chart. this article will show you how to create a multi-line chart

Office information