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

--
Message posted from http://www.ExcelForum.com

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.
'==================================

gunjani < wrote:
> 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 I
> acheive this. What do I select as Row,Column and Data in the Pivotchart
> Wizard?
>
> Many Thanks
> Gunjani
>
>
> ---
> Message posted from http://www.ExcelForum.com/
>


--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html