Assignment 7 – Excel Graphing
Saturday April 06th 2024, 4:12 am
Filed under: DL 10,Grade 9

Pie Graph:

For this project I decided to list the ingredients needed to make a cheesecake which is my favorite dessert alongside the ingredient’s measurements. I listed the cheesecake ingredients and the crust ingredients separately, but I also made a chart where the cheesecake and crust ingredients are listed together. The data used for this project is separated into much more than 5 categories which is what was recommended but since I did not have anything better data or information to use, I used this. (The measurements used for the ingredients are all in milliliters (ml)).

Bar Graph:

I asked my close friends and family members what their favorite. (I miss spelled Favorite 🙂 Using Microsoft Forms, I asked 16 people what their favorite season was, and I entered the information in the cells, and I later colored them blue. Using the data that I had received I created a column chart. (I e-mailed the form to them). I also inserted sparklines in column C. I also made a pivot chart and slicers to filter the information easily on another sheet in the workbook.

My Form:

https://forms.office.com/Pages/ShareFormPage.aspx?id=DQSIkWdsW0yxEjajBLZtrQAAAAAAAAAAAAMAACs4OY5UNEpKVTNON0FHVk83U1czMUwzSjlBNjdWMC4u&sharetoken=OnbKXrjlEpIdtv2CLLTP

Line Graph:

I used this website -> https://www.omnicalculator.com/biology/bacteria-growth that was listed in the document. This website was quite hard for me to navigate around. The number of bacteria at the time 0, N (0) equals 1 at all times for all the categories.

MY EXCEL DOCUMENT:





     
No Comments so far



Leave a comment

Line and paragraph breaks automatic, e-mail address never displayed, HTML allowed: <a href="" title=""> <abbr title=""> <acronym title=""> <b> <blockquote cite=""> <cite> <code> <del datetime=""> <em> <i> <q cite=""> <s> <strike> <strong>

(required)

(required)


Skip to toolbar