Activity You have learned about the graphical elements that you can add in a spreadsheet. Create your own spreadsheet using these elements.
Question 1
Create a chart using the sample data in the table below. Recollect the steps on how to create a chart, and explain the necessary steps based on
the data in the table. Mention what the x- and the y-axes state and your interpretation of the data represented in the chart.
Year Percentage Increase in Expenses
2005
25.3
2007
30
2009
35
2011
35.8
2014
40

please help

Here are the steps I followed to create the chart on the Microsoft Excel spreadsheet.

I clicked the Insert option from the top toolbar.

I clicked the Chart option.

I clicked Chart Type, and selected the type of chart I wanted. The table above provides data on the increase in percentage of expenses over the years. I chose the Column chart to display this data graphically. The column chart is the best form of chart that can show variation between items.

I selected the Data Range. I specified the start and end values of the data set that I wanted to plot in the chart.

Under Chart Elements, I specified the title and legend for the chart. A legend makes it easy for a viewer to understand a titled graph.

The x-axis represents the year in my column chart, and the y-axis shows the percentage increase in expenses per year. With the help of this chart, I could see that every year the percentage in expenses has increased steadily, and reached the highest value in 2014.

Explanation:

This is really close to the sample answer, so I would be careful...