how to use microsoft excel to make a bar graph

HOW TO USE MICROSOFT EXCEL TO MAKE A BAR GRAPH HOW TO
HOW TO USE MICROSOFT EXCEL TO MAKE A BAR GRAPH UPDATE

I have chosen different colors, and my chart is looking like this. Similarly, you can choose different colors for each bar separately. Step 9: To add Labels to the bar Right click on bar > Add Data Labels click on it. Step 8: To give the Chart Heading, go to layout>Chart Title > Select Above chart.Ĭhart Heading will be displayed as here it is Sales by Region.

Right, click on the first bar > go to Fill > Gradient Fill and apply the below format. Step 7: Moreover, we can make the bar colors look attractive by right click on each bar separately. Step 6: Go to fill and select Vary Colours by Point. Step 5: select the bar, right-click on the bar, and select format data series. Select the chart go to layout > gridlines > primary vertical gridlines > none. Note: Chart Filters are only available for certain types of charts.Step 4: Remove gridlines.

HOW TO USE MICROSOFT EXCEL TO MAKE A BAR GRAPH UPDATE

Check the boxes under Series or Categories and click “Apply” at the bottom to update your chart and only include your selections. Or choose a color scheme from colorful and monochromatic color palettes.Ĭhart Filters: For viewing particular parts of the data in your chart, you can use filters. From top to bottom, you have Chart Elements, Chart Styles, and Chart Filters.Ĭhart Elements: Add, remove, or position elements of the chart such as the axis titles, data labels, gridlines, trendline, and legend.Ĭhart Styles: Select a theme for your chart with different effects and backgrounds. If you use Excel on Windows, you’ll get a bonus of three helpful buttons to the right when you select your chart. Simply expand to customize that particular item.Īs an example, if you choose to create a Pareto chart, you can customize the Pareto line with the type, color, transparency, width, and more. You can choose things like Horizontal or Vertical Axis, Plot Area, or a Series of data.Ĭlick “Text Options” for any of the above Chart Options areas and the sidebar tabs change to Text Fill & Outline, Text Effects, and Textbox.įor whichever area you work with, each tab has its options directly below. These apply to the base of your chart.Ĭlick the drop-down arrow next to Chart Options to select a specific part of the chart.

HOW TO USE MICROSOFT EXCEL TO MAKE A BAR GRAPH HOW TO

RELATED: How to Lock the Position of a Chart in ExcelĬlick “Chart Options” and you’ll see three tabs for Fill & Line, Effects, and Size & Properties. To work with the different areas of your chart, go to the top of the sidebar.

Either double-click the chart or right-click it and pick “Format Chart Area” from the shortcut menu. So you can easily switch from a column chart to a combo chart, for instance.įor customizing the font, size, positioning, border, series, and axes, the sidebar is your go-to spot. If you believe a different type of graph would work better for your data, simply click “Change Chart Type” and you’ll see the same options as when you created the chart. You’ll then see many tools in the ribbon for adding chart elements, changing the layout, colors, or style, choosing different data, and switching rows and columns. To display the Chart Design tab, select the chart. You can use the Chart Design tab, the Format Chart sidebar, and on Windows, you can use the handy buttons on the right of the chart. Just like there are various ways to select the type of chart you want to use in Excel, there are different methods for customizing it.

RELATED: How to Make a Bar Chart in Microsoft Excel How to Customize a Graph or Chart in Excel Whichever way you go about choosing the chart you want to use, it will pop right onto your sheet after you select it.įrom there, you can customize everything from the colors and style to the elements that appear on the chart. For example, if you choose a column or bar chart, you can select 2-D or 3-D column or 2-D or 3-D bar. There is a drop-down arrow next to each chart type for you to pick the style.

Another way to choose the type of chart you want to use is by selecting it in the Charts section of the ribbon.

How to use microsoft excel to make a bar graph