I have a lot of data within a table. I am trying to create a pie
chart, which I will need to update on a monthly basic, so really I
don't want to have to create a separate table of data which then needs
to be inserted in a chart.

My information goes along the lines of:
Supplier Value
Supplier 1 £10.00
Supplier 1 £10.00
Supplier 1 £9.00
Supplier 1 £9.00
Supplier 1 £9.00
Supplier 1 £9.00
Supplier 1 £9.00
Supplier 1 £9.00
Supplier 1 £9.00
Supplier 1 £9.00
Supplier 1 £9.00
Supplier 1 £9.00
Supplier 2 £9.00
Supplier 2 £9.00
Supplier 2 £9.00
Supplier 2 £9.00
Supplier 2 £9.00
Supplier 2 £9.00
Supplier 2 £9.00
Supplier 2 £9.00
Supplier 2 £9.00
Supplier 2 £9.00
Supplier 2 £9.00
Supplier 2 £9.00
Supplier 2 £9.00
Supplier 2 £9.00
Supplier 3 £10.00

Can I create a pie chart out of this?

I have tried to create three separate series with the value field
container the values for that one supplier, but this does not seem to
work.

Any suggestions would be greatly appreciated.

Caroline