Biz_Excel

We all tossed a dice untill the outcome turn 6-6.
God bless us all
Keep believing

Line charts/graph are used to track changes over short & long periods of time, when smaller changes exist, line graphs are better to use than bar graphs.
It can also be used to compare changes over the same period of time for more than one group.
Ex: Average price by hour, profit by quarter.
Note: Line and column charts can be used to trend two variables over time.

Bar and column chart are used for comparing numerical data across categories or to track changes over time between different groups. E.g Sales by product, Income by Age etc.
The difference between bar and column chart, bar chart is oriented horizontally, where as a column chart is oriented vertically.
BAR CHART are suitable for displaying long data labels while COLUMN CHART are good for displaying large number of DATA sets on category axis or data sets with Negative/inverted.
Note: BAR CHART used when the DATA labels are long or so many DATASETS to display.