The easiest way to make a bar graph in Microsoft Excel is to use the quick analysis menu. This allows you to quickly take your data and create a graph with the relevant information. Once you have selected your data the quick analysis icon will automatically appear, allowing you to make a bar graph quickly.
Alternative Method to Make a Bar Graph
1. Select the data you want to make into a bar graph.
2. Switch to the Insert tab.
3. Select the insert column or bar chart option.
How to Resize a Bar Graph in Excel
Fortunately, bar graphs are easy to resize in Microsoft Excel. All you need to do is select the graph and drag one of the corner points in or out. If you are trying to make the bar graph smaller then you will want to drag the corner in towards the center of the graph. Alternatively, you can drag the corner out to make the graph bigger.
How to Change Color of a Bar Graph in Excel
If you are looking to change the color of a bar graph in Excel then you can use the Format Data options. Once you have an element of your graph selected the format data menu may open on the side. However, if it doesn’t then you can open the menu manually.
1. Select an element of your bar graph.
2. Switch to the Format tab then select Format Selection.
3. Select Fill & Line from the top.
4. Click the bucket icon then select a color.
