Make a Bar Graph
Jul 10, · To insert a bar chart in Microsoft Excel, open your Excel workbook and select your data. 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. Once your data is selected, click Insert > Insert Column or Bar funslovestory.com: Ben Stockton. Bar Graph. There are all kinds of charts and graphs, some are easy to understand while others can be pretty tricky. There are many different types because each one has a fairly specific use. Bar graphs can be used to show how something changes over time or to compare items. They have an x-axis (horizontal) and a y-axis (vertical).
While you can potentially turn any set of Excel data into a bar chart, It makes more mqke to do this with data when straight comparisons are possible, such as comparing the sales data for a number of products. You can also create combo charts in Excelwhere bar charts can be combined with other chart types to show two types of data together.
For more complex comparisons, alternative chart types like histograms might be better options. To insert a bar chart in Microsoft Excel, open your Excel workbook and select your data. Excel will automatically take the data from your data set to create the chart on the same worksheet, using your column labels to set axis and chart titles.
You can move or resize the chart to another position on the same worksheet, or cut or copy the chart to another worksheet or workbook file. For our example, the sales data has been converted into a bar chart showing a comparison of the number of sales for each electronic product. For this set of data, mice were bought what traditions did the irish bring to america least with 9 sales, while mkae were bought the most with 55 sales.
This comparison is visually obvious from the chart as presented. By default, a bar chart in Excel is created using a set style, with a title for the chart extrapolated from one of the column labels if available. You can make many formatting changes to your chart, should you wish to.
You can change the color and style of your chart, change the chart title, as well as add or edit axis labels on both sides. This would be especially important for sales data, where a trendline could visualize decreasing or increasing number of sales over time. To change the title how to download command mod for minecraft for a bar chart, double-click the title text box above the chart itself.
Axis labels should appear for both the x axis at the bottom and the y axis on the left. These will appear as text boxes. To edit the labels, double-click the text boxes next to each axis. Microsoft Excel offers a number of chart themes named styles that you can apply to your bar chart. Select one of these styles how to make a bar graph change the visual appearance of your chart, including changing the bar layout and background.
Color options are grouped, so select one of the color palette groupings to apply those colors to your chart. You can test each color style by grapu over them with your mouse first. Your chart will change to show how the chart will look with those colors applied. You can also use the pop-up formatting menu that appears above the chart title or axis label text boxes as you edit them.
The Best Tech Newsletter Anywhere. Joinsubscribers and get a daily digest of news, comics, trivia, reviews, and more. Windows Mac iPhone Android. Smarthome Office Security Linux.
The How to make a bar graph Tech Newsletter Anywhere Joinsubscribers and get a daily digest of news, geek trivia, and our feature articles.
Inserting Bar Charts in Microsoft Grpah While you can potentially turn any set of Excel data into a bar chart, It makes more hhow to do this with data when straight comparisons are possible, such as comparing the sales data for a number of products. Formatting Bar Charts in Microsoft Excel By default, a bar chart in Excel is created using a set style, with a title for the chart extrapolated from one of the column labels if available. How-To Geek is where you turn when you want experts to explain technology.
Since we launched inour articles how to create a group calendar in lotus notes been read more than 1 billion times. Want to know more?
How to make a bar graph Create a design Select 'Elements' tab Search 'Charts' Select 'Bar Chart' Add your data. Instructions. Enter values (and labels) separated by commas, your results are shown live. Don't forget to change the Titles too! "Save" shows just the graph in the browser, then right click to save. The old Flash version is still available. Bar Graphs Line Graphs Pie Charts Dot Plots Graphs Index. Bar graph maker online ??. Use underline '_' for space in data labels: 'name_1' will be viewed as 'name 1'.
This article was written by Jack Lloyd. He has over two years of experience writing and editing technology-related articles. He is technology enthusiast and an English teacher. In this case, several readers have written to tell us that this article was helpful to them, earning it our reader-approved status.
Add labels for the graph's X- and Y-axes. To do so, click the A1 cell X-axis and type in a label, then do the same for the B1 cell Y-axis. For example, a graph measuring the temperature over a week's worth of days might have "Days" in A1 and "Temperature" in B1. Enter data for the graph's X- and Y-axes. To do this, you'll type a number or word into the A or B column to apply it to the X- or Y- axis, respectively. For example, typing "Monday" into the A2 cell and "70" into the B2 field might show that it was 70 degrees on Monday.
Finish entering your data. Once your data entry is complete, you're ready to use the data to create a bar graph. Part 2 of Select all of your data. This will select all of your data. Click the Insert tab. It's at the top of the Excel window, just right of the Home tab.
Click the "Bar chart" icon. This icon is in the "Charts" group below and to the right of the Insert tab; it resembles a series of three vertical bars. Click a bar graph option. The templates available to you will vary depending on your operating system and whether or not you've purchased Excel, but some popular options include the following: 2-D Column - Represents your data with simple, vertical bars.
Customize your graph's appearance. Once you decide on a graph format, you can use the "Design" section near the top of the Excel window to select a different template, change the colors used, or change the graph type entirely. The "Design" window only appears when your graph is selected. To select your graph, click it. You can also click the graph's title to select it and then type in a new title. The title is typically at the top of the graph's window.
Support wikiHow and unlock all samples. Sample Vertical Bar Graph. Sample Stacked Bar Graph. Yes No. Not Helpful 13 Helpful You can copy and paste the graph. Do this the same way you'd copy and paste regular text. Not Helpful 7 Helpful Click on the element you want to adjust. For example, if you want to adjust the width of the bars, you would click on the bars.
If that doesn't bring up options, try right clicking. Decreasing the gap width will make the bars appear to widen. If you have more than one set of data i. If you're not satisfied with the automatic layout of the axes, you can adjust these at your own peril. Not Helpful 16 Helpful Double click on it or look at the settings, usually they can be found on the right hand side of the graph.
Not Helpful 10 Helpful How can I create a bar graph template that can be used over and over as a new graph by simply changing the data in the spreadsheet fields? Vasili Karalewich. Make a blank table, then highlight the table and insert the graph. The graph will be blank all white , so just put in fake data to make sure it works. Then, clear the table and copy the document. Make a new copy of the spreadsheet every time you need to use the template. Not Helpful 7 Helpful 8.
If you want to copy from excel and paste to word, for instance, then right click on the graph and select 'copy' from the drop-down menu, and paste it into your word document. Not Helpful 27 Helpful Just add a text box right on top of the graph -- this will automatically group to the graph so when you move it, it moves with it.
Not Helpful 9 Helpful 8. Only highlight the data you want to make a graph for in your selection. Then when you create your graph, only this data will be displayed. Not Helpful 8 Helpful 6.
Use the control button to select the two sets of data - x first and Y after. Not Helpful 1 Helpful 1. Include your email address to get a message when this question is answered. Helpful 0 Not Helpful 0. Related wikiHows How to. How to. About This Article. Written by:. Jack Lloyd. Co-authors: Updated: August 29, Categories: Microsoft Excel Graphs.
Deutsch: Ein Balkendiagramm in Excel erstellen. Nederlands: Een staafdiagram maken in Excel. Thanks to all authors for creating a page that has been read 1,, times. It had been a long time since I used Excel. This was a perfect refresher, and my boss loved the chart I made!
Thank you! More reader stories Hide reader stories. Is this article up to date? Cookies make wikiHow better.