Answer
Excel charts can be used where;
• Comparing information, you can use column charts
• Showing trends, you can use line charts to show whether values are increasing or decreasing with time
Explanation
Charts are used in excel because they show more than the sheet and numbers contained. Vertical bars are applied in column charts in excel to represent data for comparing information. Different charts can accept a variety of data to be presented for interpretation. Trends are ideally shown by line charts, where a connection of the lines could mean an increase or decrease of a certain trend.
