Both the Bar and the Column charts display data using rectangular bars where the length of the bar is proportional to the data value. Both are used to compare two or more values. However, their difference lies in their orientation. A Bar chart is oriented horizontally whereas the Column chart is oriented vertically.
Figure : Bar chart
Figure: Column chart
Due to their different orientations, they cannot be always used interchangeably.
Bar charts are good for displaying long data labels:
Column charts have limited space in the category axis. So, when your data labels are long, the category axis may look cluttered.
You can reduce clutter by either slanting or rotating the labels.
However, if you use the Bar chart, it will improve the readability of your chart manifold.
Bar charts are good for displaying large number of data sets on the category axis:
The Column chart is a good fit for a maximum of 10-12 data sets. However, when the number of data sets is larger than that, using a Column chart is not the best way forward.
A Bar chart with the data sets placed one below the other would be a better choice in this case as it makes optimum use of space.
Column charts are good for displaying data sets with negative values:
In a Bar chart negative values are displayed as bars on the left.
However, we associate negative values more with downward direction (as used by the Column chart) than leftward (as used by the Bar chart).
Therefore, use the Column chart when you have negative values in your data set.
To sum up, while the Column chart can be used to facilitate all comparison-based analysis, it is better to use the Bar chart when your data labels are long or you have too many data sets to display.
Keep watching this space for more insights on charting best practices.
Happy Charting till next time 🙂
John Lynch
December 28, 2016, 2:11 amThe bar chart with the negative values are more effective
swarnam
February 24, 2017, 12:37 pmHi John,
As mentioned in the post, column charts would have better visualization when compared to bar charts and for comparison based analysis. Do share your thoughts on why bar chars seems to be more effective.
RANGASWAMY SARLA
January 18, 2017, 11:56 amHi
here i am using the basic version of fusion chart
and is this posible to set a legends in pie chart with out comparison
and in attribute the legends options are workimg or not
swarnam
February 24, 2017, 12:24 pmHi,
Yes, its possible to add legends for Pie charts. Do set the attribute “showLegend” as 1 in the chart element. Check out this fiddle.
Walid Gamal
April 13, 2017, 1:14 pmi use column chart design for ax report in visual studio 2010
i put many question in visual studio and ax Forms
but nothing help me to when i have one column it be very large
i want to control the width of columns
this problem take a lot of time
any help please
anonymous
December 27, 2017, 5:40 amColumn charts are good for displaying data sets with negative values
Noreen Breen
December 29, 2017, 11:15 amThe column chart is definitely a better option for showing negative information, he looks much clearer to the audience. I do like the bar chart when there is a lot of data to communicate its easier to read. Both have pros and cons
Cleta
May 5, 2018, 10:42 amNormally I do not learn article on blogs, however I wish to say that this write-up very forced me to try and do
so! Your writing taste has been surprised me.
Thank you, very great article.
Jonathan
May 7, 2018, 1:08 pmThanks Cleta!
Your kind words will help us push our initiatives to create awareness around data visualization.
Jatin Arora
July 8, 2018, 10:07 amExcellent ExplainAtion?