Creating a Chart using Pivotchart wizard

  • Thread starter Thread starter gunjani
  • Start date Start date
G

gunjani

This Pivottable /Chart wizard has confused me...
I have the following Table:

Name Day1 Day2 Day3 Day4 Day5
Tom E L R N S
Dick L N S E R
Harry N S E L E
Jane S E R L N

I like to create a chart to view who has the most E,L,N, etc. How do
acheive this. What do I select as Row,Column and Data in the Pivotchar
Wizard?
:)
Many Thanks
Gunjan
 
As answered in .worksheet.functions --

'================================
Your table isn't set up to create a pivot table and pivot chart. You
could reorganize the data, e.g.:

Name Day Code
Tom Day1 E
Tom Day2 L

Then create a pivot table with Name in the Row Area, Day in the Column
Area, and Code in the Data area, where it will become Count of Code.

Or, create a summary table, and base a normal chart on the summary. For
example, enter the names in cells A8:A11, and enter the codes in cells B7:F7

In cell B8, enter the formula:

=SUMPRODUCT(($A$2:$A$5=$A8)*($B$2:$F$5=B$7))

Copy the formula across to column F, and down to row 11
Select a cell in the summary table, and run the chart wizard to create a
column chart.
'==================================
 
Back
Top