banner



How To Move An Axis In Excel

After you lot have created a chart in Excel, what'south the first thing you usually want to practice with it? Make the graph await exactly the way you've pictured it in your mind!

In mod versions of Excel, customizing charts is easy and fun. Microsoft has really fabricated a large effort to simplify the process and place the customization options within like shooting fish in a barrel reach. And further on in this tutorial, you will learn some quick ways to add and alter all essential elements of Excel charts.

  • Add the chart championship
  • Customize chart axes
  • Add together data labels
  • Add, hibernate, move or format chart legend
  • Show or hide the gridlines
  • Edit or hide data serial in the graph
  • Change the chart blazon and styles
  • Change the default nautical chart colors
  • Bandy vertical and horizontal axes
  • Flip an Excel chart from left to right

iii means to customize charts in Excel

If y'all've had a take a chance to read our previous tutorial on how to create a graph in Excel, yous already know that yous can access the master chart features in three means:

  1. Select the chart and go to the Nautical chart Tools tabs (Design and Format) on the Excel ribbon.
  2. Right-click the chart chemical element you would like to customize, and choose the respective item from the context menu.
  3. Use the chart customization buttons that appear in the top right corner of your Excel graph when y'all click on it.

Even more customization options can exist constitute on the Format Chart pane that appears on the right of your worksheet as shortly equally you click More options… in the chart's context menu or on the Chart Tools tabs on the ribbon.

Tip. For immediate access to the relevant Format Chart pane options, double click the corresponding element in the chart.

Armed with this bones knowledge, let's run across how you tin can modify unlike chart elements to make your Excel graph look exactly the style yous'd like it to await.

How to add together title to Excel chart

This section demonstrates how to insert the chart title in different Excel versions so that you know where the principal chart features reside. And for the rest of the tutorial, we will focus on the about recent versions of Excel.

Add title to chart in Excel 2019, 2016 and 2013

In these Excel versions, a chart is already inserted with the default "Chart Championship". To change the championship text, merely select that box and type your title:
To add a chart title in Excel 2013, 2013 and 2019, select the title box and type the text.

You tin can also link the chart championship to some jail cell on the canvass, so that it gets updated automatically every time the liked cell is updated. The detailed steps are explained in Linking axis titles to a certain cell on the canvas.

If for some reason the title was not added automatically, and then click anywhere within the graph for the Chart Tools tabs to appear. Switch to the Blueprint tab, and click Add Chart Element > Chart Title > Higher up Chart I (or Centered Overlay).
Adding a chart title in Excel

Or, you can click the Chart Elements push in the upper-right corner of the graph, and put a tick in the Chart Title checkbox.
Adding a title to the chart using the Chart Elements button.

Additionally, y'all tin can click the arrow adjacent to Nautical chart Title and chose ane of the following options:

  • Above Chart - the default option that displays the title at top of the nautical chart area and changes the graph's size.
  • Centered Overlay - overlays the centered title on the chart without resizing the graph.

For more options, go to the Design tab > Add Chart Element > Chart Title > More Options.

Or, you tin can click the Chart Elements button and click Chart Championship > More Options…

Clicking the More Options item (either on the ribbon or in the context carte) opens the Format Chart Title pane on the right side of your worksheet, where y'all tin select the formatting options of your choosing.

Add championship to nautical chart in Excel 2010 and Excel 2007

To add a chart title in Excel 2010 and earlier versions, execute the post-obit steps.

  1. Click anywhere within your Excel graph to activate the Chart Tools tabs on the ribbon.
  2. On the Layout tab, click Chart Title > Higher up Nautical chart or Centered Overlay.

Adding a chart title in Excel 2010

For virtually Excel nautical chart types, the newly created graph is inserted with the default Nautical chart Championship placeholder. To add your own chart championship, you can either select the title box and blazon the text you want, or you can link the chart title to some cell on the worksheet, for example the table heading. In this example, the title of your Excel graph volition be updated automatically every time you edit the linked cell.

To link a chart title to a cell, perform the following steps:

  1. Select the nautical chart championship.
  2. On your Excel sheet, type an equal sign (=) in the formula bar, click on the cell that contains the needed text, and press Enter.

In this instance, nosotros are linking the title of our Excel pie nautical chart to the merged jail cell A1. Yous can besides select two or more cells, east.g. a couple of column headings, and the content of all selected cells volition appear in the chart title.

Linking a chart title to a cell

Move the championship within the chart

If you lot want to motion the championship to a different identify within the graph, select information technology and drag using the mouse:
Moving the title to a different place within the chart

Remove the chart title

If you don't want any title in your Excel graph, you can delete information technology in two ways:

  • On the Design tab, click Add Chart Element > Chart Title > None.
  • On the nautical chart, right-click the nautical chart title, and select Delete in the context menu.

Removing the chart title

Change font and formatting of nautical chart title

To modify the font of the chart championship in Excel, right-click the title and choose Font in the context menu. The Font dialog window will pop up where y'all tin can choose different formatting options.
Changing font and formatting of the chart title

For more formatting options, select the title on your chart, go to the Format tab on the ribbon, and play with different features. For example, this is how you can alter the title of your Excel graph using the ribbon:

Find advanced formatting options on the Format tab.]

In the same way, you can change the formatting of other chart elements such equally axis titles, centrality labels and nautical chart legend.

For more than information almost chart title, please encounter How to add together titles to Excel charts.

Customizing axes in Excel charts

For most chart types, the vertical axis (aka value or Y axis) and horizontal axis (aka category or X axis) are added automatically when you make a chart in Excel.

You can testify or hide chart axes by clicking the Chart Elements push button Chart Elements button, then clicking the arrow next to Axes, and then checking the boxes for the axes you want to show and unchecking those you lot want to hide.

For some graph types, such as combo charts, a secondary axis tin be displayed:
Adding a secondary axis to the Excel chart

When creating three-D charts in Excel, you can make the depth centrality to appear:
Adding a depth axis to a 3-D chart

Y'all tin can as well make different adjustments to the way that different axis elements are displayed in your Excel graph (the detailed steps follow below):
Change the way that different axis elements are displayed in your Excel chart

Add axis titles to a chart

When creating graphs in Excel, you tin can add titles to the horizontal and vertical axes to help your users empathize what the chart data is virtually. To add the axis titles, practise the post-obit:

  1. Click anywhere within your Excel chart, and then click the Nautical chart Elements button and check the Centrality Titles box. If you want to brandish the title only for one axis, either horizontal or vertical, click the arrow next to Axis Titles and clear one of the boxes:
    Adding an axis title
  2. Click the axis title box on the nautical chart, and type the text.

To format the axis championship, right-click it and select Format Axis Title from the context menu. The Format Centrality Title pane will appear with lots of formatting options to choose from. You tin also attempt different formatting options on the Format tab on the ribbon, equally demonstrated in Formatting the nautical chart championship.

As is the instance with chart titles, you can link an centrality title to some cell on your worksheet to have it automatically updated every time you edit the corresponding cells on the sheet.

To link an centrality title, select it, then type an equal sign (=) in the formula bar, click on the cell you desire to link the title to, and press the Enter fundamental.

Linking the axis title to a given cell on the sheet

Change the axis scale in the nautical chart

Microsoft Excel automatically determines the minimum and maximum scale values as well as the scale interval for the vertical axis based on the information included in the chart. All the same, yous can customize the vertical axis scale to meliorate run into your needs.

1. Select the vertical axis in your chart, and click the Chart Elements push button Chart Elements button.

2. Click the arrow adjacent to Axis, and and then click More options… This volition bring upwards the Format Centrality pane.

3. On the Format Axis pane, under Axis Options, click the value axis that you want to change and do one of the following:

  • To set up the starting betoken or ending indicate for the vertical axis, enter the respective numbers in the Minimum or Maximum
  • To change the scale interval, type your numbers in the Major unit of measurement box or Pocket-size unit of measurement box.
  • To reverse the club of the values, put a tick in the Values in reverse order box.

Changing the vertical axis scale

Because a horizontal axis displays text labels rather than numeric intervals, it has fewer scaling options that you can change. However, yous can alter the number of categories to brandish between tick marks, the order of categories, and the bespeak where the two axes cross:
Scaling options of the horizontal axis

Change the format of centrality values

If you want the numbers of the value axis labels to display equally currency, per centum, time or in some other format, correct-click the axis labels, and choose Format Axis in the context carte du jour. On the Format Axis pane, click Number and choose one of the available format options:
Changing the format of numbers on axis labels

Tip. To revert back to the original number formatting (the style the numbers are formatted in your worksheet), bank check the Linked to source box.

If you don't see the Number section in the Format Centrality pane, make sure you've selected a value centrality (usually the vertical centrality) in your Excel chart.

Adding data labels to Excel charts

To make your Excel graph easier to understand, you tin can add data labels to brandish details about the data serial. Depending on where you lot desire to focus your users' attending, you tin can add labels to one data series, all the series, or private data points.

  1. Click the information series you want to label. To add a label to i data indicate, click that data indicate later selecting the series.
    Select the data series or data point you want to label.
  2. Click the Nautical chart Elements button, and select the Data Labels option.

For example, this is how we can add labels to one of the information series in our Excel chart:
Adding labels to one of the data series in the chart

For specific nautical chart types, such equally pie nautical chart, you can too cull the labels location. For this, click the arrow side by side to Data Labels, and choose the pick you desire. To show information labels inside text bubbles, click Data Callout.

Choosing the labels location

How to alter data displayed on labels

To change what is displayed on the information labels in your chart, click the Chart Elements button > Information Labels > More options… This will bring upwardly the Format Information Labels pane on the right of your worksheet. Switch to the Label Options tab, and select the choice(s) yous want under Characterization Contains:
Choosing what data to display on the labels

If y'all want to add your ain text for some data bespeak, click the label for that information bespeak and so click it again so that only this label is selected. Select the label box with the existing text and type the replacement text:
Adding your own text for some data point

If you determine that as well many data labels clutter your Excel graph, you lot can remove any or all of them by correct-clicking the label(south) and selecting Delete from the context menu.

Data label tips:
  • To change the position of a given information label, click it and drag to where you want using the mouse.
  • To change the labels' font and background color, select them, go to the Format tab on the ribbon, and choose the formatting options you desire.

When you create a chart in Excel, the default legend appears at the bottom of the chart, and to the right of the chart in Excel 2010 and earlier versions.

To hide the legend, click the Chart Elements push button Chart Elements button in the upper-correct corner of the nautical chart and uncheck the Fable box.

To motility the chart fable to another position, select the nautical chart, navigate to the Design tab, click Add Chart Element > Legend and cull where to motility the legend. To remove the fable, select None.

Moving the chart legend

Another way to move the legend is to double-click on it in the nautical chart, and then choose the desired legend position on the Format Legend pane under Legend Options.
Choose the desired legend position on the Format Legend pane.

To change the legend'southward formatting, yous have plenty of unlike options on the Fill up & Line and Furnishings tabs on the Format Legend pane.

In Excel 2013, 2016 and 2019, turning the gridlines on or off is a matter of seconds. Simply click the Chart Elements push and either bank check or uncheck the Gridlines box.
Showing or hiding the gridlines on the Excel chart

Microsoft Excel determines the virtually appropriate gridlines type for your nautical chart type automatically. For instance, on a bar nautical chart, major vertical gridlines will be added, whereas selecting the Gridlines option on a column nautical chart will add together major horizontal gridlines.

To alter the gridlines type, click the arrow next to Gridlines, and then cull the desired gridlines type from the list, or click More Options… to open up the pane with advanced Major Gridlines options.
Change the gridlines type

When a lot of data is plotted in your nautical chart, y'all may want to temporary hide some data series then that you could focus merely on the most relevant ones.

To do this, click the Chart Filters push Chart Filters button on the right of the graph, uncheck the information series and/or categories you want to hide, and click Apply.

To edit a data series, click the Edit Series button to the correct of the information serial. The Edit Series button appears as presently equally you hover the mouse on a certain information series. This will also highlight the respective series on the chart, and then that you could clearly see exactly what element you will be editing.
Editing a data series in the chart

Changing chart type and way

If you decide that the newly created graph is non well-suited for your data, you can easily change it to some other chart type. Simply select the existing chart, switch to the Insert tab and choose some other nautical chart type in the Charts group.

Alternatively, you lot can right-click anywhere within the graph and select Change Chart Type… from the context carte.
Changing the chart type

To quickly change the mode of the existing graph in Excel, click the Chart Styles button Chart Styles button on the correct of the chart and scroll downward to meet the other style offerings.
Changing the chart style

Or, choose a different style in the Charts Styles group on the Blueprint tab:
The Charts Styles group on the Excel ribbon

Changing nautical chart colors

To modify the color theme of your Excel graph, click the Chart Styles button, switch to the Color tab and select one of the bachelor colour themes. Your choice volition be immediately reflected in the chart, then you can decide whether it will look well in new colors.
Changing the color theme of the chart

To choose the color for each information series individually, select the data series on the chart, go to the Format tab > Shape Styles group, and click the Shape Fill button:

Changing the color of the selected data series

How to swap X and Y axes in the chart

When yous make a nautical chart in Excel, the orientation of the data series is determined automatically based on the number of rows and columns included in the graph. In other words, Microsoft Excel plots the selected rows and columns as it considers the all-time.

If y'all are not happy with the style your worksheet rows and columns are plotted past default, you tin can hands swap the vertical and horizontal axes. To practise this, select the nautical chart, become to the Design tab and click the Switch Row/Cavalcade button.
Swaping the vertical and horizontal axes in the chart

How to flip an Excel chart from left to right

Take yous ever made a graph in Excel only to find out that information points announced backwards from what yous expected? To rectify this, reverse the plotting order of categories in a chart as shown below.

Right click on the horizontal centrality in your nautical chart and select Format Centrality… in the context menu.
Right click on the horizontal axis and select Format Axis… in the context menu.

If you prefer working with the ribbon, go to the Blueprint tab and click Add Nautical chart Chemical element > Axes > More Axis Options…
Click Add Chart Element > Axes > More Axis Options… on the ribbon.

Either way, the Format Axis pane will show upwardly, you navigate to the Axis Options tab and select the Categories in reverse order option.
Select the Categories in reverse order option to flip the chart.

Apart from flipping your Excel chart from left to right, you can also alter the order of categories, values, or series in your graph, contrary the plotting order of values, rotate a pie chart to any angle, and more. The following tutorial provides the detailed steps on how to do all this: How to rotate charts in Excel.

This is how you customize charts in Excel. Of course, this article has merely scratched the surface of Excel chart customization and formatting, and there is much more to it. In the side by side tutorial, we are going to make a chart based on data from several worksheets. And in the meanwhile, I encourage y'all to review the links at the end of this article to learn more.

You may also be interested in

Source: https://www.ablebits.com/office-addins-blog/2015/10/29/excel-charts-title-axis-legend/

Posted by: dossearclonime.blogspot.com

0 Response to "How To Move An Axis In Excel"

Post a Comment

Iklan Atas Artikel

Iklan Tengah Artikel 1

Iklan Tengah Artikel 2

Iklan Bawah Artikel