Data to plot the Bar chart:
No. of Consumers
Multiple Bar Charts
|Juice||No. of Consumers|
Repeat the above same steps to create Multiple column bar chart:
Stacked Bar Chart
Repeat the same steps as above but select the chart type as Stacked Bar Chart
Percentage Stacked Column
This graph represents the percentage value for each of the items A,B,C for a specific fruit
For Column A: Select Column Juice & Column A as data range and then select chart type as 3D Pie Chart
Histogram is used to represent continuous frequency Distribution. There is no gap between the bars and it has a continuous appearance.
Select Column chart and Format Data Series to select Gap width as 0%
In Part 2(coming soon), We will learn how to plot the Histogram using Excel Data Analysis ToolPak and Polygons, Curves, Line Diagrams and also Series Data.