Bar Chart is like a horizontal column chart, It is used when category names are big.
For example if we want to create an email-id wise sales chart. we can showcase email id wise number of sales as given below is the snapshot of a Bar chart.
Below is the email is wise sales data for above chart.
To create this Bar Chart below step to be followed –
Select the data range like “A1:B6”.
Go to Insert>>Charts>>Bar Chart >> 2D Bar>>Clustered Bar
To add the data labels right click on bars and click on Add Data Labels.
To change the chart style-
Click on the charts, “Design” Tab will be visible under “Chart Tools”. We can choose any of the design. I have taken Style 2 from the chart style for this chart.
- Select the chart and go to “Format” tab under “Chart Tools” .
- Go to shape styles and click on “Intense Effect – Black, Dark 1 (First column in last row)