Excel - how to create income and outcome pie chart?

CLLC

Hi MSE's :hello:

I've totally forget from my high school days how to create pie charts. Basically I'm trying to list all my incomings, outgoings and then put it in a easy to read pie chart.

However, I don't know where to put the appropriate sections on the grid as when i highlight them and then select the pie chart doesn't read it. Can anyone show me an example?

On the grid it's basically got to have incomings, outgoings, and somewhere i can put a small description. I.e Income - wage. Outgoing - sainsburys.

Thanks!

Lokolo

Highlight the numbers and the options

So like:

Car | £100
Rent | £500
Food | £600

then click chart, then click Pie Chart....

---

Don't do it like

Rent | £100
Sainsburys | £6
Sainsburys | £10
Car | £20
Car | £25

( | indicates a new cell )

Lokolo

Example of how I just did one

Lil306

Lazy way of creating a simple chart is also highlight data and press F11 on keyboard IIRC