how to make a bar graph in excel
Answers
Answer:
sorry what are you saying
NOTE
Column chart means bar graph .
Overview
Present your data in a column chart
Column charts are useful for showing data changes over a period of time or for illustrating comparisons among items. In column charts, categories are typically organized along the horizontal axis and values along the vertical axis
.
To create a column chart, follow these steps:
1)Enter data in a spreadsheet.
2) Select the data.
3) Depending on the Excel version you're using, select one of the following options:
- Excel 2016: Click Insert > Insert Column or Bar Chart icon, and select a column chart option of your choice.
- Excel 2013: Click Insert > Insert Column Chart icon, and select a column chart option of your choice.
- Excel 2010 and Excel 2007: Click Insert > Column, and select a column chart option of your choice.
You can optionally format the chart a little further. See the list below for a few options
NOTE
Make sure you click on the chart first before applying a formatting option
- To apply a different chart layout, click Design > Charts Layout, and select a layout.
- To apply a different chart style, click Design > Chart Styles, and pick a style.
- To apply a different shape style, click Format > Shape Styles, and pick a style.
Note:
A chart style is different from a shape style. A shape style is a formatting option that applies to the chart’s border only, whereas the chart style is a formatting option that applies to the entire chart.
- To apply different shape effects, click Format > Shape Effects, and pick an option such as Bevel or Glow, and then a sub option.
- To apply a theme, click Page Layout > Themes, and select a theme.
- To apply a formatting option to a specific component of a chart (such as Vertical (Value) Axis, Horizontal (Category) Axis, Chart Area, to name a few), click Format > pick a component in the Chart Elements dropdown box, click Format Selection, and make any necessary changes. Repeat the step for each component you want to modify.
Note:
If you are comfortable working in charts, you can also select and right-click on a specific area on the chart and select a formatting option.
This completes the answer of this question .