How to change vertical axis values in a chart. Formatting chart axes. Removing the chart title
When you create a chart, tick marks and tick marks (tick marks are small unit labels that cross an axis and look like ruler ticks. Tick labels identify categories, values, and series on a chart.) appear on the axes by default. The way they are displayed can be customized using major and intermediate divisions and division labels. To avoid cluttering a chart, you can display fewer tick marks and labels on the horizontal axis (category axis) by specifying the intervals at which you want to add category labels, or by specifying the number of categories to display between tick marks.
You can also change the alignment and orientation of labels, and change or format the text and numbers that appear in them, such as displaying numbers as percentages.
Showing and hiding axes
Click the chart on which you want to show or hide the axes.
The funds will be displayed Working with charts, including tabs Constructor, Layout And Format.
On the tab Layout in Group Axles(Figure 4) press the button Axles.
Figure 4. Group Axles
To display an axis, highlight the type of axis you want to display, and then select one of the options that corresponds to the axis to display.
To hide an axis, select the type of axis you want to hide and then select the option No.
Setting axis tick marks and labels
On a chart, click the axis for which you want to customize tick marks or tick labels, or follow these steps to select an axis from the list of chart elements.
On the tab Format in Group Current fragment click the arrow next to the field Chart area, and then click the axis you want to select.
Open the page Axis parameters if it is not already open, and then do one or more of the following:
to change the display of the main divisions, in the field Basic
to change the display of auxiliary tick marks in the drop-down list Intermediate select the desired division position;
to change the position of the division labels in the field Axis labels select the desired option.
You can hide tick marks or tick labels by selecting the option No.
Changing the number of categories between labels and divisions
On a chart, click the horizontal axis (category axis) that you want to change, or follow these steps to select an axis from the list of chart elements.
Open the page Axis parameters, if it is not already open, and then do the following as you choose. To change the spacing between axis labels, see Interval between signatures select an option Specify the interval unit, and then enter the desired number in the text field. To display captions for each category, enter a value of 1, to display them through one category, enter 2, for every third category - 3, etc.
To change the placement of axis labels, in the Signature distance from axis enter the required number.
To place the labels closer to the axis, enter a lower value. Enter a larger value if you want the distance between the label and the axis to be greater.
Change the alignment and orientation of labels
You can change the alignment of axis labels on both the horizontal axis (category axis) and the vertical axis (value axis). If there are multi-level category labels in the chart (category labels on the chart, displayed as a structure depending on the data in the cells on the sheet. For example, the heading “Students” can be displayed above the line with the headings “EP-11d”, “EP-12d”) You can change the alignment of all label levels. You can also change the distance between label levels on the horizontal axis (category axis).
On a chart, click the axis that contains the labels for which you want to apply a different alignment, or follow these steps to select an axis from the list of chart elements.
Select the desired axis. On the tab Alignment in area Text Format select the desired position in the field Vertical alignment.
To change the text orientation, select the desired position in the box Text direction.
To quickly change the horizontal alignment of selected axis labels, right-click the axis, and then in the mini toolbar, click Align Left ,Centered or Align Right .
The chart in the table editor is built on the basis of data, which is always displayed along the axes. The axes display the values of this data. But, by default, the editor may leave the axes blank or display numbers in the wrong format. To fix this you need to understand how to correctly label axes in Excel using the built-in chart settings functions.
There is a LAYOUT tab in the program menu, which allows you to customize elements. Find the AXES NAME button and select VERTICAL AXIS NAME from the drop-down list. Next, the editor offers a choice regarding the placement of the inscription from three options: rotated title, vertical or horizontal.
After selecting the first item, the image will display an inscription placed as required. You need to click on the field and change the text as you wish.
Below you can see how the name is positioned after activating the vertical layout option.
And when choosing horizontal placement, the inscription will look like this.
Horizontal axis name
We perform the actions by analogy with placing the name of the vertical axis. But, there are some differences. The user is provided with only one way to position the label: the title under the axis.
After the horizontal inscription appears, we change its contents.
How to label axes in Excel? Horizontal Axis Labels
The axis guide of the chart is usually divided into several equal parts, which allows you to define the ranges of the curve. They can also be signed in your own way.
On the AXIS button there is an item MAIN HORIZONTAL AXIS. After clicking on it, a caption settings menu appears, thanks to which you can completely remove signatures by selecting NO SIGNATURES or NO from the list.
By default, Excel displays text from left to right, but you can change this by clicking on the RIGHT TO LEFT menu item.
There are also additional parameters with which you can configure the axis of data in detail: the interval between labels, the type of axis, its location relative to the text, recording format, etc.
Vertical Axis Labels
To configure the vertical axis, you need to select the MAIN VERTICAL AXIS item of the AXIS button. You can remove the signatures or display them according to the numerical characteristics:
Millions.
Billions.
Logarithmic scale.
The figure below shows captions in thousands.
It is also possible to configure the axis more thoroughly by clicking on ADDITIONAL PARAMETERS.
These are the main ways to configure the division scale and axis names. Carrying out this algorithm, even a novice user can easily cope with the process of editing a diagram.
Share our article on your social networks:What's the first thing we think about after creating a chart in Excel? About how to give the diagram exactly the look we imagined when we got down to business!
In modern versions of Excel 2013 and 2016, customizing charts is simple and convenient. Microsoft has put a lot of effort into making the setup process simple and the necessary options easily accessible. Later in this article we will show several simple ways How to add and customize all the basic chart elements in Excel.
3 Ways to Customize Chart Options in Excel
- Select the chart and use the tabs from the group Working with charts(Chart Tools) – Constructor(Design) and Format(Format).
- Right-click on the chart element that you want to configure and select the right command from the context menu.
- Use special icons that appear near the upper right corner of the diagram when you click on it with the mouse.
Even more parameters are in the panel Chart Area Format(Format Chart), which appears on the right side of the worksheet if you click Extra options(More options) in context menu charts or group tabs Working with charts(Chart Tools).
Advice: To immediately open the desired section of the panel to configure chart parameters, double-click on the corresponding element on the chart.
Armed with this basic knowledge, let's look at how we can modify various elements of a chart in Excel to give it exactly the look we want it to have.
How to Add a Title to an Excel Chart
In this section, we will cover how to add a title to a chart in different versions Excel, and show you where the main tools for working with diagrams are located. In the rest of the article, we will look at examples of work only in the newest versions of Excel 2013 and 2016.
Adding a title to a chart in Excel 2013 and Excel 2016
In Excel 2013 and Excel 2016, when you create a chart, the text “ is automatically inserted into its title. Chart title“. To change this text, simply select it and enter your own name:
You can also link the chart title to a cell in the worksheet using a link so that the title is automatically updated whenever the contents of the linked cell change. How to do this is described.
If for some reason the name was not added automatically, then click anywhere on the diagram so that a group of tabs appears Working with charts(Chart Tools). Open the tab Constructor(Design) and press Add a chart element(Add Chart Element) > Chart title(Chart Title) > Above the diagram(Above Chart) or Centered (overlay)(Centered Overlay).
Or click the icon Chart elements(Chart Elements) near the upper right corner of the chart and check the box Chart title(Chart Title).
Next to the parameter Chart title(Chart Title) you can click the arrow pointing to the right (see the figure above) and select one of the proposed options:
- Above the diagram(Above Chart) – the name is placed above the chart area, the size of the chart is reduced; this option is the default.
- Centered (overlay)(Centered Overlay) – the centered title is superimposed on top of the plotting area, but the size of the graph does not change.
To find more options, open the tab Constructor(Design) and press Add a chart element(Add Chart Element) > Chart title(Chart Title) > Additional header options(More Options). Or click the icon Chart elements(Chart Elements), then Chart title(Chart Title) > Extra options(More Options).
Button press Extra options(More Options), in both cases, opens the panel Chart Title Format(Format Chart Title) on the right side of the worksheet, where you can find required parameters.
Adding a title to a chart in Excel 2010 and Excel 2007
To add a title to a chart in Excel 2010 and earlier versions, follow these steps:
Linking the chart title to a worksheet cell
The different types of charts in Excel are most often created with alt text instead of a title. To set your own title for a chart, you can either select the chart field and enter the text manually, or bind it to a worksheet cell that contains, for example, a table title. In this case, the name Excel charts will automatically update every time the contents of the linked cell change.
To associate a chart title with a worksheet cell:
- Select the chart title.
- In the formula bar, enter an equal sign ( = ), click on the cell containing the desired text and click Enter.
IN in this example we associate the Excel chart title with the cell A1. You can select two or more cells (for example, multiple column headers) and the chart title will display the contents of all selected cells.
Moving the title in the diagram
If you need to move the chart title to another location, select it and drag it with the mouse:
Removing the chart title
If you don't need a title for an Excel chart, you can remove it in two ways:
Changing the font and design of the chart title
To change the chart title font in Excel, right-click on it and click Font(Font) in the context menu. A dialog box of the same name will open, in which you can configure various font parameters.
If you need more detailed settings, highlight the chart title, open the tab Format(Format) and play with different parameters. Here's how, for example, you can change the title of a chart using the Menu Ribbon:
In the same way, you can change the design of other chart elements, such as , axis labels and .
Setting up chart axes in Excel
For most chart types in Excel vertical axis(aka the value axis or Y axis) and horizontal axis(aka category axis or X axis) are added automatically when creating a chart.
To hide or show the chart axes, click the icon Chart elements(Chart Elements), then click the arrow in the line Axles(Axes) and check the boxes next to the axes that you want to show, or uncheck the boxes next to those that you want to hide.
Some chart types, such as combo charts, may show a secondary axis.
When creating 3-D diagrams, you can display depth axis:
For each element of the chart axes in Excel, you can configure various parameters (we'll talk about this in more detail later):
Adding axis titles to a chart
When creating a chart in Excel, you can add titles to the vertical and horizontal axes to help users understand what data is shown in the chart. To add axis titles, you need to do this:
To customize the appearance of the axis title, right-click on it and in the context menu click Axis title format(Format Axis Title). This will open a panel of the same name with a large selection of customizable design parameters. You can also use the options offered on the tab Format(Format) Menu ribbons, as we did with .
We associate the names of the axes with the given cells of the worksheet
Today you learned about how you can customize charts in Excel. Of course, this article only scratches the surface of the topic of setting up and formatting charts in Excel, although there is much more that can be said about this. In the next article, we will build a chart from the data that is in different worksheets. In the meantime, I recommend that you practice to consolidate the knowledge you have acquired today.
Most chart types allow you to hide or show axes. To make your chart data easier to understand, you can also change its appearance.
Important: This article does not cover changing the scale of chart axes. For information about changing the scale, see the following articles:
More about axes
Charts typically have two axes that measure and organize data: a vertical (value axis or y-axis) and a horizontal (category axis or x-axis). 3D histograms, 3D cone charts, and pyramid charts have a third axis, the depth axis (row axis or z axis), so that data can be plotted to the depth of the chart. Radar charts have no horizontal (category) axes, and pie and donut charts have no axes at all.
Vertical axis (values)
Horizontal axis (categories)
Depth axis (data series)
Here's what you can do with your charts to make them look more impressive and convey information better. additional information For information about what axes are and what you can do with them, see the section.
Showing and hiding axes
Setting axis tick marks and labels
Changing the number of categories between labels and divisions
Change the alignment and orientation of labels
Advice You can change the horizontal alignment of an axis label by clicking the axis and selecting from the toolbar home option Align Left , Align Center or Align Right .
Changing the text of category labels
Note
Changing the appearance of text and numbers in captions
Text formatting
On the toolbar home select the type of formatting you need.
Advice home in Group Font.
Formatting numbers
Note quantity / total = percentage 10 / 100 = 0,1 and then format 0,1 10 % .
Change the appearance of chart axes in Office 2010
Show or hide axes (Office 2010)
Set tick marks and axis labels (Office 2010)
Change the number of categories between labels and tick marks (Office 2010)
Change the alignment and orientation of labels (Office 2010)
The alignment of labels can be changed on both the horizontal (category) and vertical (values) axis. If your chart has multi-level category labels, you can change the alignment of each level of labels. You can also change the distance between label levels on the horizontal (category) axis.
Advice To change the horizontal alignment of an axis label, right-click the axis and click mini toolbars select Left , Centered or Right .
Change the text of category labels (Office 2010)
You can change the text of category labels on the sheet or directly on the chart.
Change the text of a category label on a sheet
On the worksheet, click the cell with the signature text that you want to change.
Type new text and press Enter.
Note. After you make changes to the sheet, the chart is automatically updated.
Changing the caption text on a chart
Change the appearance of text and numbers in captions (Office 2010)
You can change the format of the label text on the category axis or the numbers on the value axis.
Text formatting
In the chart, right-click the axis with the labels you want to format.
On mini toolbars Select the formatting options you want.
Advice You can also select an axis with labels and then use the formatting buttons on the tab home in Group Font.
Formatting numbers
Note. Before you format numbers as percentages, make sure that the numbers shown in the chart were calculated as percentages in the source data and are displayed in decimal format. Percentages are calculated in the worksheet using the expression quantity / total = percentage. For example, if you calculate the value 10 / 100 = 0,1 and then format 0,1 As a percentage, the number should be displayed as follows: 10 % .
Add tick marks to an axis
The axis can be formatted to display major and minor tick marks at selected intervals.
This action applies to Word for Mac only: in the menu view select item Page layout.
Click the chart and open the tab Constructor.
Click the button Add a chart element > axes > Additional Axis Options.
On the panel Axis format expand the element divisions and select Options for major and minor tick types.
After you add tick marks, you can change the spacing between tick marks by changing the value in the field character spacing .
All about axes
On the charts different types axes may be displayed differently. For example, scatter (xy) and bubble charts display numerical values on both a horizontal and vertical axis. An example would be displaying the amount (inches) of precipitation relative to barometric pressure. Both elements have numerical values, and data points are plotted on the x and y axes relative to those values. There are many options available for value axes, such as setting the scale to logarithmic.
Other types of charts, such as histograms, graphs, and area charts, display numeric values only on the vertical (value) axis and text classifications (or categories) on the horizontal axis. An example would be to display the amount (inches) of precipitation by geographic area. In this example, geographic areas are text categories of data that are displayed on the horizontal (category) axis. Geographic areas that represent text are spaced evenly, unlike values that can be measured. Keep this distinction in mind when choosing a chart type, since the capabilities for value and category axes differ. In such cases, the depth (series) axis is another kind of category axis.
When you create a chart, the axes display tick marks and labels by default. The way they are displayed can be customized using main and intermediate divisions and labels. To avoid cluttering a chart, you can display fewer labels or tick marks on the horizontal axis (categories) by specifying spacing for labeling categories or the number of categories displayed between tick marks.
You can also change the alignment and orientation of labels, or the display format of text and numbers (for example, to display numbers as percentages).
Note: This page has been automatically translated and may contain inaccuracies and grammatical errors. It is important to us that this article is useful to you. Was the information useful? For convenience also (in English).
It is not always possible to immediately create a graph and chart in Excel that meets all user requirements.
Initially, it is difficult to determine which type of graphs and charts is best to present data in: a volumetric chart, a stacked bar chart, or a chart with markers.
Sometimes the legend is more of a hindrance than a help in presenting the data and it is better to turn it off. And sometimes you need to connect a table with data to the graph to prepare a presentation in other programs (for example, PowerPoint). Therefore, it is worth learning how to use the settings for graphs and charts in Excel.
Changing graphs and charts
Create a table with data as shown below. You already know how to build a graph in Excel using data. Select the table with the data and select the “Insert” - “Histogram” - “Histogram with Grouping” tool.
The result is a graph that needs to be edited:
- remove legend;
- add table;
- change chart type.
Chart legend in Excel
You can add a legend to the chart. To solve this problem we perform the following sequence of actions:
- Left-click on the chart to activate it (select it) and select the tool: “Working with Charts” - “Layout” - “Legend”.
- From the Legend tool's drop-down list of options, select the option: "None (Do not add legend)." And the legend will be removed from the chart.
Table on graph
Now you need to add a table to the chart:
- Activate the graph by clicking on it and select the “Chart Tools” - “Layout” - “Data Table” tool.
- From the drop-down list of options for the “Data Table” tool, select the option: “Show Data Table”.
Types of graphs in Excel
- Select the “Chart Tools” - “Design” - “Change Chart Type” tool.
- In the “Change chart type” dialog box that appears, specify the names of groups of chart types in the left column - “With areas”, and in the right section of the window select “With areas and stacking”.
For complete completion, you still need to sign the axes on Excel chart. To do this, select the tool: “Working with Charts” - “Layout” - “Axis Titles” - “Name of the Main Vertical Axis” - “Vertical Title”.
Near the vertical axis there is a place for its title. To change the vertical axis title text, double-click on it with the left mouse button and enter your text.
Delete the schedule to move on to the next task. To do this, activate it and press the key on the keyboard – DELETE.
How to change the color of a graph in Excel?
Based on the original table, create a graph again: “Insert” - “Histogram” - “Histogram with grouping”.
Now our task is to change the fill of the first column to gradient:
Tools for complex design of gradient fills on charts are now available to you:
- name of the workpiece;
- direction;
- corner;
- gradient points;
- color;
- brightness;
- transparency.
Experiment with these settings, and then click “Close”. Please note in the "Name of the workpiece" are already available ready-made templates: flame, ocean, gold, etc.
How to change data in Excel graph?
A graph in Excel is not a static picture. There is a constant connection between the graph and the data. When the data changes, the “picture” dynamically adapts to the changes and thus displays the current indicators.
We will demonstrate the dynamic connection of a graph with data using a ready-made example. Change the values in the cells of the range B2:C4 of the original table and you will see that the indicators are automatically redrawn. All indicators are automatically updated. It is very comfortable. There is no need to re-create the histogram.