How to make a PlotTo create a plot
Creating a Chart or Graph in Excel[With video tutorial]
It' s no wonder, however, that some folks get a little scared by the idea of snooping around in Microsoft Excel. But I work in marketing operations, so that's a prerequisite. That' s why I thought I'd write a useful videotutorial as well as some step-by-step tutorials for anyone out there who is thinking of putting a table calculation full of information into a graph that actually, you know, means something.
These are the easy step-by-step procedures you need to create a diagram or graphic in Excel. Note that there are many different editions of Excel, so what you see in the above movie does not always exactly correspond to what you will see in your new one. I used Excel 2017 v16 in the following tutorial.
Please note that we recommend that you adhere to the below mentioned manuals and demos (or by downloading them as a PDF file via the link below) so that you can keep track of them. The majority of icons and features you will see and use are very similar in all Excel releases. Fill in your details in Excel.
Select one of nine graphics and diagram settings. Select your entries and insert the required graphic. If necessary, toggle the datas on each axle. Modify the dimensions of the caption and the axes label of your diagram. If necessary, modify the measuring option of the Y-axis. Order your details if you like. Name your diagram.
Fill in your details in Excel. First you have to fill in your details in Excel. Perhaps you have been exporting the information from another location, e.g. from your own research tools or your own online sales team. Select one of nine graphic and diagram settings you want to use. Excel gives you many ways to generate diagrams and graphics.
These include bars, line charts, circular charts, scatterplots and more. In the upper menu you can see how Excel can identify the individual elements, as shown below: Select your entries and insert the required graphic. I work with the best look in a chart, so let's do that.
In order to create a chart, select the dates and add the title of the axes Y and Y. Select the desired graphic from the drop-down box that opens. Refer to the resulting chart below. If necessary, change the datas on each axle. To change the display on the axes Y and Y, right-click on the chart and select'Select data', then click'Change row/column'.
This rearranges which axles are carrying which information in the following table. This is what the resulting graphic would look like: In order to modify the label and caption layouts, click on the diagram and then on the "Chart Design" page. Here you can select which layouts you like for the diagram header, axle header and key.
For my example (see below), I selected the item that displays smoother bars and captions below the graph. In order to further reformat the key, click on it to display the'Format Key' side panel, as shown below. Here you can modify the fill colour of the caption, which in turn changes the colour of the column itself.
In order to reformat other parts of your diagram, click on them one by one to open a corresponding formats dialog box. Modify the dimensions of the caption and the axes label of your diagram. The first time you create a diagram in Excel, the sizes of your axes and legends captions may be somewhat small, according to the diagram types you select (bar, circle, line, etc.).
When you have generated your diagram, you want to upgrade these tags to make them readable. In order to enlarge the captions of your diagram, click on them one by one and, instead of opening a new format field, click back on the "Home" register card in the upper Excel menu area. Then use the drop-down boxes for fonts and sizes to extend or reduce the caption and axes label of your diagram according to your requirements.
If necessary, modify the measuring option of the Y-axis. In order to modify the way the Y-axis is measured, click on the percentage of the Y-axis in your graph to open the "Format Axis" dialog box. Here you can choose whether you want to view the unit on the Axes Option page or whether you want to modify it, whether the Y-axis displays percentage values with 2 digits after the comp. or with 0 digits after the dec.
Since my chart sets the max percent of the Y-axis to 60% by default, I might want to adjust it to 100% by hand to display my information on a more general purpose chart. I can do this by selecting the'Maximum' checkbox - two boxes at the bottom under'Limits' in the'Format Axis' dialog box - and changing the value from 0.6 to 1 The resulting graphic would be modified to look like the one below (I raised the text on the' Home' register card so you can see the difference):
Order your details if you like. In order to arrange the information so that respondents' responses appear in the opposite order, right-click on your diagram and click "Select Data" to display the same option pane that you opened in steps 3 above. Click the up and down arrow this up and down to change the order of your information in the diagram.
When you need to reorder more than two rows of information, you can also reorder them in either increasing or decreasing order. Mark all your dates in the boxes above your diagram, click on "dates" and choose "sort", as shown below. Name your diagram. Here comes the funny and simple part: the name of your graphi.
Immediately after creating your graph, the heading "Chart Title" or something similar will probably appear, according to the Excel used. In order to modify this designation, click on "Chart Title" to display a write cursors. Then you can adjust the name of your charts at will. If you have a song you like, click "Home" in the top menu and use the text editing option to give your song the accent it is worth.
Refer to these and my definitive graphic below: Below are some extra tools to help you use Excel and visualize your information intelligently. Extra tools for using Excel and visualising data: Would you like more Excel-Tipps? This article explains how to create a second axle for an Excel diagram.