![Make a bar graph Make a bar graph](/uploads/1/2/5/4/125457422/527043058.jpg)
Open the spreadsheet with the data you want to graph. Open Excel (it’s in the All Apps area of the Start menu in Windows and the Applications folder in macOS), then click the file you want to edit. Exploring charts in Excel and finding that the one you pick isn’t working well for your data is a thing of the past! Try the Recommended Charts command on the Insert tab to quickly create a chart that’s just right for your data. Select the data you want to chart.
![How How](/uploads/1/2/5/4/125457422/648689588.jpg)
I need to plot a graph based on 3 variables. I have seen such graphs in Excel, so know it's possible. The rundown: Can easily create a bar graph based on 2 variables in a given set of data, eg, age of participants and number of yrs playing sports. Assuming a sample of 25 people, the excel graph will have 25 bars, with age on the y-axis and playing time on the x-axis. Now I want to color code the bars to indicate the particular sport played by each member of the group: blue for tennis, green for baseball, etc. The only way I've found to do this is to manually change each bar color.
This cheat may be reasonable for 25 data points, but not for hundreds. This should be a fairly basic graphing function, given what Excel is supposed to do, ie, sort and present data. Yet, can find absolutely NO explanation of how to do it. @ Jon, You are going to have a problem as your vertical axis (normally your value) isn't standard - you have millions, Billions and then an average (which looks to be in units).
For something like this you are best off doing a panel of 3 small graphs one for returns, one for Total and one for Average. By putting the 3 panel graphs in a sequence alongside each other - a reader should be able to see that Returns and Total show a spike in 2013, however it isn't reflected in the Average, and that Returns has significantly dropped in 14 compared to Total and Average.
If you want to follow along with this tutorial, download the example spreadsheet. Steps to Create a Column Chart To create a column chart in Excel 2016, you will need to do the following steps:. Highlight the data that you would like to use for the column chart.
In this example, we have selected the range A1:C7. Select the Insert tab in the toolbar at the top of the screen. Click on the Column Chart button in the Charts group and then select a chart from the drop down menu. In this example, we have selected the first column chart (called Clustered Column) in the 2-D Column section. TIP: As you hover over each choice in the drop down menu, it will show you a preview of your data in the highlighted chart format.
Now you will see the column chart appear in your spreadsheet with rectangular bars to represent both the sales and the expense numbers. The sales values are displayed as blue vertical bars and the expenses are displayed as orange vertical bars. You can see the axis values on the left side of the graph for these vertical bars. Finally, let's update the title for the column chart.
To change the title, click on 'Chart Title' at the top of the graph object. You should see the title become editable. Enter the text that you would like to see as the title.
In this tutorial, we have entered 'Sales and Expenses' as the title for the column chart. Congratulations, you have finished creating your first column chart in Excel 2016!