how to make a bar graph in word

• Creating a Chart is a four-step process. An important task you are likely to perform is to amend the data. This article has been viewed 612,839 times. You can create stacked graphs in 2D or 3D and can export the graph in PNG, JPG, PDF, or CSV formats. Click on the tab entitled "Layout" in the Chart Tools menu. Click, "Yes." He has over two years of experience writing and editing technology-related articles. Then select the data range, in this example, highlight cell A2:B9. Create chart or graph directly in Microsoft Word Open the Microsoft Word program. Efficient organization of your data on Google Docs is efficiently done by making a bar graph. He is technology enthusiast and an English teacher. Word Cannot Open This File Because It Is Larger Than 512 Megabytes, How To Disable Microsoft Office Upload Center, Office Updates Are Available – Office 2013, Normal template Is Lost After Upgrade To Word 2013, Open A Word 2013 Document In An Earlier Version Of Word, Add A Word To The Dictionary In Word 2013. See screenshot: 3. Create the data that you want to use as follows: 2. Select the data range (in this example, B5:C14). How do you delete a column that doesn't contain any value so there aren't any gaps in the completed chart? The values in the "A" column dictate the X-axis data of your graph. Type in the data into the spreadsheet so it looks like the following, and you will notice that the bar chart changes with every piece of data you type in. Click the chart type and then double-click the chart you want. Click the chart to select it, and then press DELETE. • Step two is the Chart Source Data. You'll also see a small Excel window with cells appear--this is where you'll input your data. Following the below steps, you will find that making two y axes in chart is very easy. Click on "Axis Titles" from within the "Labels" group. 2. Bar charts in Word 2013 are good at displaying values for different groups for comparison. How can I remove the grid from my Microsoft Word graph? % of people told us that this article helped them. Vertical label. Learn the basic steps that everyone needs to know to create a chart in Word, Excel, and PowerPoint—all available in Office 365—from Dummies.com. To do so, click the A1 cell, hold down … Click on the "X" tool. For example, choose either Line, Bar, or Histogram . Please do the following steps to achieve this task. Create a bar chart overlaying another bar chart in Excel. The bar chart is now complete. This article was written by Jack Lloyd. This is where we will put our bird count. A bar graph (or bar chart) displays data using rectangular bars. Bar1 data values Horizontal bars. Click on "Primary Horizontal Axis Title" or "Secondary Horizontal Axis Title" to add a horizontal axis text box to your chart. Use ChartTool to make a cylinder or rectangular bar graph based on statistical data that you input. Click OK. Each of these chart sub-types separates the smaller slices from the main pie chart and displays them in a supplementary pie or stacked bar chart. wikiHow is where trusted research and expert knowledge come together. Free Download Bar Chart Software and View All Templates and Examples. Number of lines. ChartTool gives you several options to customize your bar graph in a step by step interface. For example, clicking below a paragraph of text will set that location as the place to insert your graph. We use cookies to make wikiHow great. Click Chart. Click on the different categories and scroll down to view types of graphs. Top of Page. That format does not support many of the graphic capabilities of the later versions of Mac Office, including Charts. Click Insert > Chart. To create a Pie of Pie or Bar of Pie chart, follow these steps: 1. Its app icon resembles a green box with a white "X" on it. put the cursor where you want place a graph then click on insert object then select on excel so you can do the graph work in excel once … Include your email address to get a message when this question is answered. 1. We’ll need to delete some of the columns and we can do that just like we would if we were in Excel. We know ads can be annoying, but they’re what allow us to make all of wikiHow available for free. Don't get left behind - start the journey to becoming an expert now! After you create a chart, you can change the way that worksheet rows and columns are plotted in the chart by switching rows to columns or vice versa. Please help us continue to provide you with our trusted how-to guides and videos for free by whitelisting wikiHow on your ad blocker. create Draw zoom_out zoom_in save_alt content_copy print clear. Including a chart in your document can help you illustrate numerical data—such as comparisons and trends—so it's easier for the reader to understand. Chart elements – the check boxes control what elements are shown and what elements are hidden (like the axes and their titles). Using the Bar Graphs Solution for ConceptDraw DIAGRAM you can create your own professional looking Bar Charts quick and easy. A plethora of tutorials to get you up to speed with Microsoft Word 2013. After inserting the chart, then, you should insert two helper columns, in the first helper column-Column D, please enter this formula: =B2*1.15 , … Yesterday I sat in my garden and counted all the different kinds of birds that came to feed on the food I’d laid out for them. In the Ribbon bar at the top, click the Insert tab. Open the Microsoft Word program. And then click Insert > Pie > Pie of Pie or Bar of Pie, see screenshot: 3. Make sure that your Word document is not in Compatibility Mode, otherwise your chart capabilities will be severely restricted. Select Insert > Recommended Charts. 5. You need to click "Insert" and then click "Smartapp." Horizontal label. Layout options – controls how text wraps around the chart. Our task now is to get this data into Word and display it as a bar chart. You can also double-click an existing Word document to open it in Word. Once your data is selected, click Insert > Insert Column or Bar Chart. Stacked bars. This wikiHow teaches you how to add a data chart to your Microsoft Word document. Then click on "Relationships" on the left hand side and pick your table. And you will get the following chart: 4. 2. The values in the "1" row each pertain to a different line or bar (e.g., "B1" is a line or bar, "C1" is a different line or bar, and so on). Adding Data to Your Graph: Click a cell in the Excel window. 1. Make sure that your Word document is not in Compatibility Mode, otherwise your chart capabilities will be severely restricted. How do I make a chart on the online version of Word? This article was written by Jack Lloyd. Click the Excel window. Go to Insert > Illustration > Chart. No design skills needed. The Edit Data in Excel 2013 opens up Excel 2013 and presents the data there, thus offering all the powerful features that Excel has. The "Chart Tools" menu. I just want to show the horizontal lines. Chart filters – offers filter controls that you may already have seen in Excel. Note: You can select the data you want in the chart and press ALT + F1 to create a chart immediately, but it might not be the best chart for the data. Then choose Bar from the list. 7. A chart is a tool you can use to communicate information graphically. Choosing this option allows you to edit the data in a smaller spreadsheet within Word 2013. Chart styles – controls how the bar chart looks; its style and colours displayed. Either use Save As or Convert Document from the File menu to create a new version of the file in the current .docx file format. I counted these results: Our task now is to get this data into Word and display it as a bar chart. You can do this manually using your mouse, or you can select a cell in your range and press Ctrl+A to select the data automatically. He is technology enthusiast and an English teacher. Open Microsoft Excel. Bar Chart Template for Word. If you no longer need a chart, you can delete it. Horiz. If you don’t see a chart you like, select the All Charts tab to see all chart … When you’ve finished typing in the data, you can close the spreadsheet down by clicking on the “X” in the top right hand corner. Make a bar graph now. This makes a graph. On Word 2010 or earlier, the Excel window will pop up outside of Microsoft Word as an entirely new Excel document. To do this, right click on the bar chart and select Edit Data > Edit Data. If you really can’t stand to see another ad again, then please consider supporting our work with a contribution to wikiHow. data type. A bar graph is one of the simplest visuals you can make in Excel. You should then find that the Chart features (as well as those for Shapes & SmartArt) are active. On the Insert tab, in the Charts group, choose the Pie and Doughnut … The first step is Chart Type, which has a default setting of a column chart. Select the data range that you want to create a chart but exclude the percentage column, and then click Insert > Insert Column or Bar Chart > 2-D Clustered Column Chart, see screenshot: 2 . Then choose Bar from the list. When the bar chart is inserted you will see a small Excel spreadsheet below it that contains sample data. Anything written in an Excel cell can be re-written to reflect your data. This article has been viewed 612,839 times. The following steps can help you to create a pie of pie or bar of pie chart: 1. Create a Bar Chart for Free with Adobe Spark An intuitive interface makes it easy to plug in your data, mock it up, and share it. Go to the Insert tab and click Chart in the Illustrations group. They … Create a bar chart overlaying another bar chart in Excel. Then, do the following: Open the document where you want to make … Watch the video below to learn more about creating charts. 4. Select Chart . Creating a Graph: Select all of your data. But it’s also one of the most useful. While the amount of data that you can present is limited, there’s nothing clearer than a simple bar … Go to the Insert tab and click Chart in the Illustrations group. Thanks to all authors for creating a page that has been read 612,839 times. Click off the chart onto the Word page to close the Excel window-within-a-window and return to the Word document with the empty line graph on the page. There are many ways to make bar charts. Jack Lloyd is a Technology Writer and Editor for wikiHow. Add graph data. Click where you want to put the graph. This picture shows the Bar Chart … {"smallUrl":"https:\/\/www.wikihow.com\/images\/thumb\/f\/f2\/Add-a-Graph-to-Microsoft-Word-Step-1-Version-4.jpg\/v4-460px-Add-a-Graph-to-Microsoft-Word-Step-1-Version-4.jpg","bigUrl":"\/images\/thumb\/f\/f2\/Add-a-Graph-to-Microsoft-Word-Step-1-Version-4.jpg\/aid1567019-v4-728px-Add-a-Graph-to-Microsoft-Word-Step-1-Version-4.jpg","smallWidth":460,"smallHeight":345,"bigWidth":728,"bigHeight":546,"licensing":"