Charts in Microsoft Excel. Why is the diagram not being built in Excel? How to create a chart in Excel. How to build a graph in Excel Why you can’t build a graph in Excel

In Excel you can work not only with numerical data. The program's tools also make it possible to construct diagrams of any complexity based on the data entered into the table. In this case, the design of the diagram can be customized at your discretion. In this article, we will look at techniques for constructing various charts using the tools available in Microsoft Excel.

The technique of creating diagrams is no more complicated than constructing ordinary tables in Excel, and anyone can master it easily and quickly.

Before you start building any chart, you need to create a table and fill it with data. The future diagram will be built on the basis of this table.
When the table is completely ready, you need to select the area that you want to display as a diagram, then go to the “Insert” tab. Here are the different chart types to choose from:
- Histogram
- Schedule
- Circular
- Hierarchical
- Statistical
- Spot
- Cascade
- Combined
Note:
Depending on the version of the program, the number of chart types may vary.

There are also other types of charts, but they are not as common. You can view the full list through the “Insert” menu (in the program menu bar at the very top), then the “Diagram” item.
Once you have decided on the type of chart you need, click on the appropriate item. Next you will be asked to select a subtype. For example, if you select a histogram, the following subtypes will be offered: regular, volume, line, volume bar.
We select the appropriate subtype, click on it, after which the diagram will be automatically generated and displayed on the screen.
For example, the visual display of a regular histogram will look like this:
The graph chart will be displayed as follows:

And this is what a pie chart looks like:

How to work with charts

When the diagram is built, you can start working with it, as well as customizing its appearance. To do this, go to the “Design” tab. Here you can configure various parameters of the created diagram, for example, change the design style, change the type, subtype, etc.

For example, to change the type of chart and its subtype, click on the “Change chart type” button and select what we need from the list that opens.

By clicking on the “Add chart element” button, you can open a list of actions that will help you customize your chart in detail.

You can also use the Express Layout tool for quick customization. There are a variety of chart designs available here, so you can choose the one that best suits your needs.

It is quite useful, along with the bars, to also have a specific data value for each of them. The data signing function will help us with this. We open the list by clicking the “Add chart element” button, here we select the “Data Labels” item and then the option that we like (in our case, “At the edge, outside”).

Done, now our diagram is not only visual, but also informative.

If you think the fonts in the chart are too small, you can adjust them. To do this, right-click, for example, on the data signature, select “Font...” from the menu that opens.

Here you can make the required changes and save them by clicking the “OK” button.

Chart with percentages

To create charts that require percentage display of data, the best option is to use the pie type.

The Italian engineer, economist and sociologist Vilfredo Pareto put forward a very interesting theory, according to which the 20% of the most effective actions taken provide 80% of the final result. It follows from this that the remaining 80% of actions provide only 20% of the achieved result.

This type of chart allows you to calculate the most effective actions that provide the greatest impact. Let's try to build this chart using the tools available in Microsoft Excel. The most suitable chart type to achieve this goal is a histogram.

We create a table, for example, with product names. One column will indicate the purchase volume in monetary terms, and the other will indicate the profit received. The purpose of this table is to calculate the purchase of which product brings the maximum benefit when selling it.
We build a regular histogram. To do this, you need to select the table area, go to the “Insert” tab and then select the chart type.
After we have done this, a chart will be formed with 2 bars of different colors, each of which corresponds to data from different columns of the table.
The next thing to do is to change the column responsible for profit to the “Chart” type. To do this, select the required column and go to the “Designer” section. There we see the “Change chart type” button, click on it. In the dialog box that opens, go to the “Graph” section and click on the appropriate type of graph.
That's all that needed to be done. Pareto chart is ready.
Further, it can be edited in the same way as we described above, for example, by adding the values of bars and points with values on the chart.

Hello everybody! In this article you will learn how to make a chart in Excel. It’s no secret that thanks to the visual presentation of data, you can quickly evaluate and analyze it. So, the step-by-step sequence of the construction process will be explained on the basis of the table below. It indicates monthly income, taxes of conditional individuals, as well as their ratio in percentage terms.

How to make a chart in excel

First of all, you should select the area based on the data indicated in which you need to build a diagram. In the example given, absolutely all data is highlighted - both income and taxes, as well as interest.
Go to the “Insert” tab, and select the view in the diagrams section.

So, in the diagrams section, users are asked to choose different types of future diagrams. The icon located next to the name visually explains how the selected type of diagram will be displayed. By clicking on any one, you can select a subtype in the list that appears.

If the user needs to embed a histogram without performing steps No. 2 and No. 3, he can only press the Alt button combination, as well as F1.

Taking a closer look at the subtypes, you will notice that they are all classified into one of only a few variations. They differ in either complete or partial shading of the diagram elements. You can explore this difference further.

So, the first case involves displaying data in three columns. In the second option, they are displayed as shaded parts of a single column.

In both the first and second variants, the percentage value is practically invisible, and all due to the fact that diagrams tend to demonstrate its absolute value. And compared to large values, such an insignificant number is hardly visible.

To create a chart for data of a single type, you need to identify it specifically in the first step. The following shows a chart for percentage values that were almost invisible before.

Editing diagrams

Once the diagrams have been constructed, they can be corrected at any second. Along with the resulting diagram, a number of tabs immediately appear under the single name “Working with diagrams”, and you go to the first of them - to the designer. Thanks to the tools of new tabs, the widest possibilities for adjusting diagrams are revealed.

Understanding the constructor

To display percentage values, a pie chart is often used. To build such a chart, while maintaining the same information, you need to click on the tool located first on the left side - “Change chart view”, and then select the required stitch subtype “Circle”.

Next, you will see the result of activating a tool called “Row/Column”, which interchanges data on the X and Y axes. Thus, the previously monochromatic histogram has acquired colors, becoming much more attractive.

Thanks to the "Chart Styles" section located on the designer tab, you can change the styles. By opening the drop-down list in this section, the user is presented with over forty style options to choose from.

An incredibly valuable tool is moving the chart. Due to it, you can place it on a full-screen separate sheet.

So, a sheet with a diagram on it is added to the existing sheets. If the user has to construct many other diagrams based on the one already created and adjusted, he can save it for further use as a template.

To do this, you just need to select the entire diagram, click on the “Save as Template” tool, type in the name and click “Save”. The saved template will then be available in the appropriate folder.

Getting familiar with the “Format” and “Layout” tabs

The tools of the above tabs often relate to the external design of the constructed diagram.

To add a name, you need to click on the corresponding item, give preference to one of two placement variations, type the name in the formula line, and then click Enter.

If necessary, titles on the X and Y axis can be added in the same way.

Using the Legend tool, you can control the display and position of explanatory text. In the presented case, they are the names of the months. They can be either removed or moved to any side.

Much preferable is a data signature tool that can be used to add numeric data to it.

If you set the diagram to be 3D when you created it, the Rotate Shape tool will become available on the tab called “Layout.” Due to it, it is possible to adjust the display angle of the diagram.

Using the “Shape Fill” tool, located in the “Format” tab, it is possible to fill the background of the diagram or any of its details with absolutely any desired color, texture or gradient.

It is worth noting that to fill the required element, it must be selected in advance.

Adding new data

After creating a chart for a specific set of data, sometimes you need to add new information to the chart. To do this, first of all, you should select a new column and fix it in the clipboard (by simultaneously pressing Ctrl and C. Then you just need to click on the diagram, adding new saved data to it by pressing Ctrl and V. The diagram will display a new chain of tax data .

Innovative chart options in Excel 2013

If the programs of 2007 and 2010 are incredibly similar, the newer version is equipped with a set of pleasant innovations that will greatly facilitate the process of working with diagrams:

In the window for inserting a diagram type, you can preview it;
The type insertion window now has a new view - “Combined”, which combines several types;
The insert type window now includes a page with recommended charts, which the new version recommends based on the original selected data;
The Layout tab has given way to three new buttons—Chart Elements, Styles, and Filters;
It is now possible to sign data using callouts and take them directly from the sheets;
You can customize the design of parts using a convenient panel on the right, rather than in a dialog box.

I really hope that now you understand how to make a chart in Excel, and also, as a sign of gratitude, you will click on the social network buttons. Peace and goodness to everyone!

As Confucius once said, a picture is worth a thousand words. By adding charts to worksheets, we not only add interest to worksheets that involve a lot of numbers, but we also illustrate trends and anomalies that might otherwise go unnoticed. Excel simplifies the process of creating charts as much as possible and also allows you to experiment with different types of graphical representations. So let's find out how to create a chart in Excel?

Charts in Excel

Before we start looking at charts in Excel, I would like to say a few words about them. Remember how your high school algebra teacher tried to teach you how to solve equations using graphs, plotting some values on the X-axis and others on the Y-axis? Naturally, at that time your head was busy with other things, and you did not listen to him very carefully. You may have been saying to yourself, “I’ll never need this crap once I graduate from school and get a cool job!”

But, as they say, never say never, and school knowledge of algebra can come in handy. Even though Excel automates most of the chart creation process, you need to be able to distinguish the X-axis from the Y-axis in case the chart is not drawn correctly. To refresh your memory, the X axis is horizontal and is located at the bottom of the chart, and the Y axis is vertical and is located on the left side of the chart.

Most charts use only these two axes, with Excel plotting the categories along the X-axis ( categories), and their values are along the Y axis. The X axis is sometimes called temporal, because many charts plot time periods along it, such as months, quarters, or years.

Keep in mind that the worksheet values represented graphically in the chart are dynamically linked to the cells. Any change to the corresponding cell in the worksheet is automatically reflected in the chart.

Excel users have a number of quick and easy ways to create charts based on source data. But before you use one of them, select the data from which you will create a chart. To do this, position the cell cursor in the data table area. If you need to select a piece of data from a large table, select the values and headings that will be included in the new chart.

My favorite way to create charts in Excel is to use the button Recommended Charts(Recommended Charts) located on the ribbon tab Insert(Insert). A dialog box will appear on the screen Inserting a chart(Insert Chart) with tab selected Recommended Charts(Recommended Charts). To see what the data will look like if you select a particular chart, click on the thumbnail on the left side of the window. Once you find the chart you want, click on the button OK. As a result of these actions, the diagram will be embedded in the current sheet.

using the All Diagrams group buttons

To the right of the button Recommended Charts there is a group All Diagrams(Charts) ribbon tabs Insert. This group contains drop-down collection buttons that allow you to select different chart types and styles.

Insert a histogram or bar chart(Insert Column Chart or Bar Chart). Select a histogram, 3-dimensional histogram, bar chart, or 3-D bar chart.
Insert Hierarchical Chart(Insert Treemap Chart). Insert a tree diagram or sunburst diagram. This type of chart is used to compare parts to the whole, and when categories have multiple columns organized in a hierarchical structure.
Insert a waterfall or stock chart (InsertStockorWaterfallChart). Select a waterfall or stock chart.
Insert a graph or area chart (InsertLineChartorAreaChart). Insert a 2D or 3D graph or a 2D or 3D area chart.
Insert statistical chart (Inserthistrogramcharts). Insert a histogram, Pareto chart, or box-whisker chart.
Insert Combo Chart (InsertComboChart). Insert a 2D combined area histogram, clustered histogram, or stacked surface chart.
Insert a pie or donut chart (InsertPieorDoughnutChart). Select a 2D or 3D pie chart or a 2D donut chart.
Insert dot (X,Y) or bubble chart (InsertScatter (X,Y)orBubbleChart). Insert a 2D scatter (X,Y) or bubble chart.
Insert a surface or radar chart (InsertSurfaceorRadarChart). Insert one of the surface or radar charts.

Using the collections associated with a specific chart button, select the chart you want, and then click that button to embed the chart in the worksheet.

If you use the ribbon tab buttons Insert If you still couldn’t find the right diagram, then use the tab All diagrams(All Charts) dialog box Inserting a chart. Various chart types and styles are available in this window. To open this window, click on the group dialog box open marker Diagrams tabs Insert. Then select the tab All diagrams to access the full list of charts.

How to Create a Chart in Excel Using Quick Analysis Tools

If you need to create a chart based on a subset of a data table, use quick analysis tools. To do this, follow these steps:

Click the Quick Analysis tool icon located near the lower right corner of the selected cell range.

A palette of quick analysis tools will appear on the screen with the selected tab Formatting(Formatting). This palette also provides various conditional formatting options.

Click the Charts tab button (Charts), located at the top of the quick analysis tool palette.

After selecting a tab Diagrams buttons are displayed Ruled With grouping(Clustered Vag), Stacked ruler(Stacked Vag), Histogram with grouping(Clustered Column) Stacked histogram(Stacked Column) Spot(Scatter) and Other charts(More Charts). The first five buttons allow you to preview what the charts created from the selected data will look like. After selecting the last button, Other diagrams, a dialog box will appear on the screen Inserting a chart with dedicated tab Recommended charts. In this window you can choose from a wide variety of chart types.

To see what the different types of charts you create in Excel based on the selected data, select the corresponding chart button in the Quick Analysis tool palette.

After selecting the button for the chart type you need, a large thumbnail of the chart will appear on the screen, which will be created based on the selected tabular data. This thumbnail appears above the Quick Analysis tool palette as long as the mouse pointer is over the corresponding chart button.

Once you find the chart you want, click on the corresponding button on the Quick Analysis toolbar to select it.

Excel will create a floating (or embedded) chart that resides in the current worksheet. This chart will be activated so you can move and change it as you wish.

In the screenshot, the first quarter sales data (along with column headings) in the table has been selected. After selecting a range of cells and clicking on the Quick Analysis Tools icon displayed near the lower right corner of the selected cell range, the tab was selected Diagrams. A histogram with grouping was selected in the Quick Analysis tool palette. A histogram thumbnail with grouping appears above the Quick Analysis tool palette.

The created diagram is activated and the area occupied by it is automatically selected. This allows you to move the chart to any part of the sheet by dragging. While the chart is selected, individual areas of the chart are highlighted in different colors. The titles used for the chart legend are colored red. The color purple is used to highlight headings that serve as labels for the horizontal axis (category axis, or x-axis). Blue color is used to highlight values represented as columns in a histogram, as well as for the vertical axis labels (value axis, or y-axis). A set of contextual tabs will also appear on the ribbon. Working with charts(Chart Tools), including contextual tabs Constructor(Design) and Format(Format), and the tab will be selected Constructor.

How to create a chart in Excel on a separate sheet?

Sometimes you want to display the chart you just created on a separate worksheet, and you don't want to have to deal with moving the embedded chart you created with Quick Analysis tools or searching for buttons on the Ribbon tab Insert. In such situations, position the cell cursor anywhere in the data table from which the chart will be created (or select a range of cells in a large table), and press<F11>.

Excel will create a grouped histogram based on the data in the table or a selected range of cells on the chart sheet (Chart 1). The settings of a chart located on a separate sheet can be changed in the same way as the settings of an embedded chart.

How to move and resize a chart?

Immediately after creating the diagram, you can easily resize it and move it anywhere on the worksheet, since it remains selected. You can always tell when a graphic object, such as a chart, is selected because there are sizing handles that look like small squares along its outline. These markers are located at the corners and in the middle of the charting area. The following three buttons will also appear near the lower right corner of the selected chart.

ChartElements). This button is indicated by a plus sign and allows you to change chart elements such as chart titles, legend, grid, error bars, and trend lines.

ChartStyles). This button is indicated by a brush symbol and allows you to change the chart layout and select a different color scheme.

ChartFilters). This button is indicated by a conical funnel icon and is intended to change the data series presented in the chart or the labels displayed in the legend or along the category axis.

If an embedded chart is selected (either immediately after creation or after clicking on it), a set of contextual tabs is displayed on the ribbon Working with diagrams (ChartTools), containing its own contextual tabs Constructor (Design) And Format(Format), and each group of cells presented in the chart is highlighted in a different color.

The embedded chart, highlighted on the worksheet, can be moved and scaled.

To move the chart, place the mouse pointer anywhere on the chart and drag it to a different position.
To resize the chart (you can stretch it in any direction if it looks distorted), place your mouse pointer over one of the selection handles. When the pointer changes to a double-headed arrow, drag the handle (the direction depends on which handle you selected and whether you want to stretch or shrink the diagram in that direction).

Once the chart is proportionally sized and in the desired location on the worksheet, deselect it (click anywhere on the sheet outside the chart area). Once the selection is deselected, the selection markers, as well as the buttons (Chart Elements), Chart styles(Chart Styles), (Chart Filters) and a set of contextual tabs Working with charts(Chart Tools) will disappear from the screen.

To select the chart again for editing, resizing, or moving, click anywhere on the chart. Once you've done that, the selection handles and set of contextual tabs Job With diagrams will appear on the screen again.

How to move a chart to a separate sheet?

Even though Excel automatically places all new charts on the same worksheet that contains the original data (unless, of course, you use the key trick<F11>), sometimes it is more convenient to place them on a separate sheet. To move an embedded chart to its own sheet, follow these steps:

Click the Move Chart button (Movechart), located on the Constructor contextual tab.
In the Move Chart dialog box that opens, set the radio button to “on a separate sheet” ( Newsheet).
(Optional) In the text box next to the radio button, rename the worksheet you are creating from the standard Chart1 to something more meaningful.
Click OK to close the dialog box and open a new sheet with the chart placed on it.

If, after moving the chart to a separate sheet, you decide to return it to the data sheet, click the button Move chart contextual tab Constructor. Then click on the button An object(Object), select the name of the desired worksheet from the associated drop-down list and click OK.

How to Create a Chart in Excel: Edit Charts Using the Contextual Design Tab

On the tab Constructor, related to a set of contextual tabs Working with diagrams, There are buttons designed to perform any transformations of the new diagram.

Context tab Constructor contains the following groups of buttons.

Chart Layouts (ChartLayouts). To change specific chart elements such as titles, data labels, legend, and other elements, click the button Add a chart element(Add Chart Element). Note that most of the options are duplicated in the Chart Elements palette, which appears when you click the This button is located to the right of the highlighted embedded chart. To select a new layout for the selected chart, click the button Express layout(Quick Layout).
ChartStyles). Click the button Change colors(Change Colors) to display a pop-up palette that includes a variety of full-color and monochrome color schemes that can be applied to the chart. In the Chart Styles collection, you can view or select a style for the current chart.
Data (data). Click the button Row column(Switch Row/ Column) to immediately swap the data used for the legend and category axis. Click the button Select data(Select Data) to open the data source selection dialog, where you can not only swap the legend and categories, but also edit any of these categories.
Type (Ture). To change the chart type, click the button Change chart type(Change Chart Type), and then in the dialog box that opens, go to the tab All diagrams select the chart type you need.
Location (Location). Click the button Move chart(Move Chart) to move the chart to a new chart sheet or to another worksheet.

How to Create a Chart in Excel: Customizing Chart Elements

Using the button (Chart Elements), indicated by a plus, which is displayed after selecting a chart, you can add various elements to the chart. To add a chart element, click the button. A list of the main elements of the diagram will appear on the screen.

After checking the checkbox, the corresponding element immediately appears in the diagram area. To remove a specific chart element, clear the corresponding check box.

To add or remove part of a chart element, or change the layout for elements such as (Chart Title), Data Labels(Data Labels), Data table(Data Table) Error limit(Error Bars) Legend(Legend) or Trend line(Trendline), select the required option from the corresponding submenu of the chart element.

For example, to change the position of the chart title, click on the item's submenu and select the appropriate option.

Above the diagram(Above Chart). Add a chart title or move it above the chart area and center it.
Bycenter(overlay) (Centered Overlay Title). Adds or moves the chart title to the top of the chart area, aligned to the center.

Extra options(More Options). Displays the panel (Format Chart Title) on the right side of the Excel window. In this panel, you can select various formatting options for the chart title by clicking the buttons Shading and borders(Fill & Line) Effects(Effects) and Size and properties(Size and Properties). The indicated buttons are located under the list header Title options Text Options Text fill and outline(Text Fill & Outline), Text effects(Text Effects) and Inscription(Textbox).

How to Create a Chart in Excel: Adding Data Labels to Individual Chart Series

Data labels display the numeric values of worksheet cells that correspond to specific points on a chart. To add data labels to the selected chart and position them accordingly, click the button Chart elements located to the right of the selected chart, and select the checkbox Data Labels(Data Labels). A submenu will appear with the following options available.

In the center(Center). Centering the labels on the data points on the chart.
At the edge, inside(Inside End). Placing labels inside, near the edge of the data points.
At the base, inside(Inside Base). Placing data labels inside, at the base of the data points.
At the edge, outside(Outside End). Placing labels on the outside, near the edge of the data points.
(Data Callout). Add text and numeric labels that appear in callouts that describe data points.

Extra options…(More Data Label Options). Displaying the panel Data Signature Format(Format Data Labels) on the right side of the Excel window. In this panel, you can select various data label formatting options by clicking the buttons Shading and borders(Fill & Line) Effects(Effects) and Size and properties(Size and Properties). These buttons are located under the list header Title options(Title Options). Under the heading Text Options(Text Options) buttons are located Text fill and outline(Text Fill & Outline), Text effects(Text Effects) and Inscription(Textbox).

How to add a data table to a chart?

Sometimes, instead of labels that may overlap data points on a chart, it makes sense to insert a table of data below the chart.

To add a data table to a selected chart (or change its location or format), click the button to the right of the selected chart and select the checkbox Data table. From the submenu that appears, you can select one of the following options.

Show legend keys(With Legend Keys). Selecting this option displays a table at the bottom of the chart that includes color keys that are used in the legend to highlight the different data series in the first column.
Don't show legend keys(No Legend Keys). Select this option to create a data table at the bottom of the chart area (without a legend).
Extra options…(More Options). Displaying the panel Data Table Format(Format Data Table) on the right side of the Excel window. From this task pane, you can select various data table formatting options by clicking the buttons Shading and borders(Fill & Line) Effects(Effects) and Size and properties(Size and Properties). These buttons are located under the list header Title options(Title Options). Under the heading Text Options(Text Options) buttons are located Text fill and outline(Text Fill & Outline), Text effects(Text Effects) and Inscription(Textbox).

If you no longer need a table at the bottom of the chart, select No from the Data Table button drop-down menu.

How do I change the title of a chart?

Initially, generic titles such as “Axis Title” and “Chart Title” are added to the chart. To replace these useless titles with others, click on the title itself or on the drop-down button Add a chart element, located in the group Current fragment(Current Selection) tabs Format set of contextual tabs Working with charts, and then select the desired chart element. Excel will let you know that a particular element is highlighted by enclosing it in a frame.

Once the title is selected, click on the insertion point in the text and edit the title as you would any cell in the worksheet. You can click on the title to select it completely, enter a new title and press the key to replace the old header with a new one. If you want to place title text on two lines, click where you want the line break to be and press .

When you're finished editing the title, click anywhere else on the chart (or worksheet if you're done editing the chart).

How to Create a Chart in Excel: Formatting Chart Titles

If headings are added to a chart, Excel uses the Calibri font by default; in this case, a 14-point font is selected for the chart title, and a 10-point font for the axes titles. To change the title font or its attributes, select the title and use the group buttons Font(Font) tabs home(Noshe).

With Live Preview, you can see the font under your mouse pointer directly on the diagram before you select it. To do this, expand the buttons attached Font(Font) and Font size(Font Size) lists, and then hover over different items.

If you need to change any other header formatting attributes, you can do this using the contextual tab Format from a set of contextual tabs Working with charts. To format the text field that contains the title, click one of the following group buttons Shape styles(Shape Styles).

Shape styles(Shape Styles). These thumbnails, along with drop-down style collections, allow you to format both the text itself and the attributes of the field containing it.
Filling a shape(Shape Fill). This button allows you to select a fill color for the title field.
Figure outline(Shape Outline). This button allows you to select a color for the field outline.
Shape Effects(Shape Effects). This button allows you to apply a new effect (Shadow, Glow, etc.) to the text field.

To format only the text of headings, use the icons from the Word Art Styles group.

Express styles. Icons from the WordArt style gallery allow you to apply a new WordArt style to the selected heading text.
Fill text(Text Fill). This button allows you to select the title text color from the palette.
Text outline(Text Shape) This button allows you to select an outline color for title text characters from a palette.
Text effects(Text Effects). This button allows you to select an effect to apply to the text (for example, shadow, glow, reflection, etc.) from a drop-down list.

How to Create a Chart in Excel: Formatting Category and Value Axes

If a chart displays a lot of values, Excel doesn't care much about how the value (or category) axes on a 3D bar chart or scatter chart are formatted.

If you don't like how the values on the X or Y axis are displayed, change the axis format. To do this, follow these steps:

Click on the appropriate axis or select an axis name from the list of chart elements. (This is the first button in the Current fragment group ( CurrentSelection) of the Format contextual tab (Format).) From the drop-down list, select Horizontal Axis (of categories) (Horizontal (Category)Axis) for horizontal axis or Vertical axis (values) (Vertical (Value)Axis) - for vertical.

Excel will limit the selected axis to an outline with selection handles.

Click the Format Selection button (FormatSelection), located in the Current fragment group of the Format contextual tab.

The taskbar will appear Axis format(Format Axis), on which under the title Axis parameters(Axis Options) there are icons that allow you to change the axis settings.

To change the scale, appearance of labels, and their placement on an axis, change the appropriate settings in the Axis Options section (this section is automatically selected when the Axis Format taskbar is displayed.)

Using these options, you can adjust the minimum and maximum values (corresponding to the end labels), set the values to be displayed in reverse order, and use a logarithmic scale. You can also display axis tick marks (hundreds, thousands, millions, etc.), change the location of the major and intermediate labels, and change the intersection point of the X and Y axes.

To change the formatting of the selected axis values, click the Number option and then click the Category drop-down list ( Ca tegory) select the desired number format and set the necessary settings. To assign the same numeric formatting to values in the selected axis that you assigned to values in worksheet cells, select the Link to Source check box ( Linked ThatSource).

For example, to select a number format with no decimal separators, select Numerical(Number), check the box Separate groups of digits(Use 1000 Separator (,)) and enter zero in the field Number of decimal places(Decimal Places).

To change the alignment and orientation of the selected axis labels, click the Size and Properties button ( Size & Properties), located in the Axis Options section of the Axis Format taskbar, and then in the Vertical Alignment drop-down lists ( VerticalAlign-ment) and Text Direction (TextDirection) select the appropriate values.
Click the Close button (Close) to close the Format Axis task pane.

As you set new axis parameters, the program displays them on the chart. However, these changes will actually be applied to the diagram only after clicking the button Close taskbar Axis format.

To change the default font and its size, as well as other attributes of the labels along the selected axis, click on the corresponding group button Font tabs home.

Conclusion

Now you know, how to create a chart in Excel different ways. Learned how to move and resize a diagram. Mastered the method of creating diagrams on a separate sheet. Learned how to change chart elements and format text in a chart. We hope this article was useful to you.

Microsoft Excel makes it possible not only to conveniently work with numerical data, but also provides tools for constructing charts based on the entered parameters. Their visual display can be completely different and depends on the user's decision. Let's see how to draw different types of diagrams using this program.

Since Excel can flexibly process numerical data and other information, the charting tool here also works in different directions. This editor has both standard types of charts based on standard data, and the ability to create an object to demonstrate percentages or even visually display the Pareto law. Next we'll talk about different methods for creating these objects.

Option 1: Building a chart from a table

The construction of different types of diagrams is practically no different, only at a certain stage you need to select the appropriate type of visualization.

Working with charts

After the object has been created, in a new tab "Working with diagrams" Additional tools for editing and modification become available.

Option 2: Display the chart as a percentage

To display the percentages of various indicators, it is best to create a pie chart.

Option 3: Building a Pareto chart

According to Vilfredo Pareto's theory, the 20% most effective actions bring 80% of the total result. Accordingly, the remaining 80% of the total set of actions that are ineffective bring only 20% of the results. Constructing a Pareto chart is precisely designed to calculate the most effective actions that give the maximum return. Let's do this using Microsoft Excel.

As you can see, Excel provides many functions for constructing and editing various types of charts - the user just has to decide what type and format is needed for visual perception.