Question 9I have a table that contains the data of the monthly sales figures of my company. I was tasked with creating a chart to display the change in sales on a monthly basis. What is the best chart to use to effectively display the change over time of monthly sales?1 pointBubble ChartPie ChartLine ChartBar Chart

Rory has collected data on how much his horse weighs each month over a 12 12 -month period. What type of data display would be best suited to displaying the data above? Column graph Divided bar graph Pie chart Line graph

Pick up the corresponding answersPossible answers:To show change over time (trend)To show frequency of different categoriesTo show part of the whole (usually in percentage)Bar chartDonut chartLine chart

Which type of chart in Excel is commonly used to show trends over time or compare values across categories?Answer areaRadar ChartArea ChartBubble ChartLine Chart

What are column charts best used for? Showing changes in data over time. Comparing the size of each category with one another. Comparing parts of the total data. Plotting individual points of data.

You are creating a chart using the data shown below. What is the best chart type and style to use in order to make the upward sales trend most obvious? Select an answer:Create a line chart and make the chart wider than the default.Create a bar chart and make the chart narrower than the default.Create a line chart and make the chart narrower than the default.Create a bar chart and make the chart wider than the default.