View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
caz_manc caz_manc is offline
external usenet poster
 
Posts: 1
Default Consolidated Values for a Pie chart

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