Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
Consolidated Values for a Pie chart
Let's say the table begins in A1 (with the label "Supplier")
In some other area, say G1:20, enter a list of suppliers Supplies Total Supplier 1 <formula goes here Supplier 2 In H2 enter =SUMIF(A:A,G2,B:B) to total all the items related to Supplier 1. Copy this down the column This will work provided you know ahead of time who the suppliers are. Failing that, the best bet is to dive into pivot tables. They appear daunting at first but are so useful that the effort to master them is worth the time pivot tables Debra Dalgleish's pictures at Jon Peltier's site: http://peltiertech.com/Excel/Pivots/pivottables.htm And Debra's own site: http://www.contextures.com/xlPivot01.html John Walkenbach also has some at: http://j-walk.com/ss/excel/files/general.htm (look for Tony Gwynn's Hit Database) Chip Pearson keeps Harald Staff's notes at: http://www.cpearson.com/excel/pivots.htm MS has some at (xl2000 and xl2002): http://office.microsoft.com/downloads/2000/XCrtPiv.aspx http://office.microsoft.com/assistan...lconPT101.aspx best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "caz_manc" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Consolidated array | Excel Discussion (Misc queries) | |||
Consolidated Pivot table | Excel Discussion (Misc queries) | |||
Consolidated Workbook | Excel Discussion (Misc queries) | |||
Consolidated Sheets | Excel Worksheet Functions | |||
Creating Consolidated Spreadsheet... | Excel Discussion (Misc queries) |