Question

What would be a situation in which you could use an excel chart to present your data

Answer 1

Having to compare results on experiments or lab tests to each other.

Answer 2

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

Step-by-step 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.