How To Use Excel Bar Graph

Insert in cell bar chart with rept function this method will apply the rept function to insert an in cell bar chart in excel easily.

How to use excel bar graph. In the charts section of the insert toolbar click the visual representation of the type of graph that you want to use. To insert a bar chart in microsoft excel open your excel workbook and select your data. If you want to create a graph from pre existing data instead double click the excel document that contains the data to open it and proceed to the next section step 2 click blank workbook pc or excel workbook mac. Select a blank cell beside the source data type the formula rept g b2 200 into it and drag the autofill handle down to other cells. For the title we can use a.

I have sales data for 4 different regions east west south and north. First highlight the data you want to put in your chart. Once you ve formatted your data creating a bar chart is as simple as clicking a couple buttons. Step 1 open microsoft excel. Select a graph type.

First i ll resize and align the chart with the alt key down this causes the chart to snap to the grid below and makes it easier to align things. Go to insert and click on bar chart and select the first chart. Now overall this chart looks pretty good but we can tidy things up and simplify. Then head to the insert tab of the ribbon. 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 you click on the chart it will insert the chart as shown in the below image. A bar graph resembles a series of vertical bars. It s in the top left side of the template window step 3 add labels for the graph s x and y axes. Other versions of excel. To do so click the a1 cell x axis and type in a label then do the same for the b1 cell y axis.

In the charts section you ll see a variety of chart symbols. Learn one of the most basic operations of excel using a bar chart to represent your data. It resembles a white x on a green background. A drop down menu with different options will appear. The chart will appear on the same page as the data.