How to Make a Column Chart in Excel
Column Charts are Used to Compare Data
Column Charts are often referred to as bar charts. However, in Microsoft Excel, a column chart has bars that run vertical while a bar chart has bars that run horizontal. Both charts are used to compare data points in one or more series of data. Note: If you are tracking data over time, then use a line graph instead of a column chart.
Column Chart
Bar Chart
Column Charts in Excel
To create a column chart in Excel, select your data, then click on the Insert tab and then Column. There are various choices of bar shapes (2-D, 3-D, Cylinder, etc) and formats (clustered, stacked or 100% stacked.)
Clustered
Stacked
100 % Stacked
Specialized Column Charts for Advanced Analysis
Consider using these types of column charts to better analyze and display your data:
QI Macros Add-in for Excel Makes it Easy to Create All of These Charts
While its possible to create histograms and pareto charts in Excel, its time consuming, complicated, and the charts don't look as nice as the ones created by QI Macros above. Save yourself time and headaches by using QI Macros. Download a 30 day trial and try it now.
