Question

Excel help

Answer 1

@Ultrilliam

Answer 2

Sorry, didn't see this until now. Go to the insert tab on excel, select the data from the previous assignment (A3-C15) and hit "recommend charts" You should see a clustered column, choose that one.

Answer 3

You should see something like this:

Answer 4

Don't forgot to change the name of the chart.
For the next graph go to insert again, select your data, and next to recommend charts you should see something resembling a bar graph, click that (it's a small icon) and on the 2D bar charts, choose the clustered bar one (should be the first one)

Answer 5

You should have something akin to this:

Answer 6

@rootbeer003

Answer 7

The first part of part 2 seems self-explanatory

Answer 8

So I suppose lemme know when you have your votes

Answer 9

@Ultrilliam

Answer 10

Now, next to where we previously had data lets make a table out of that, in columns E and F, and starting at row 3, put the data there like this (coloring will come after this)

Answer 11

can u show where i should put that

Answer 12

It's kinda up to person preference I suppose, but this is where I have it:

Answer 13

Perfect, now select the data of the first table, (A3-C15) then go back to the insert tab and hit "table"

do the same for the other table (but choose a different color) This isn't actually required but makes it look a bit nicer

Answer 14

If you want to just skip that, next off go to insert and we're going to insert a pie graph

Answer 15

not sure how to make the second table a different color

Answer 16

At the very top you should see different table styles, if you hover over them it will show how it will look if you clicked it/applied it

Answer 17

i cant find that

Answer 18

Ah, you deselected the table. Click any of the cells in the table and you should see a new tab at the very top called "design" with "table tools" above it

Answer 19

okay got it

Answer 20

Do you have the pie graph as well or no?

Answer 21

Perfect, and with that you're done! This is the file I ended up with at the end:

Answer 22

Thank you very much ;3

Answer 23

No prob bob