converting rows of cells containing "X" into pie chart

[wootcat]

I have a table with a set of columns indicating devices being used by participants, like so...

[TABLE="width: 300"]
<tbody>[TR]
[TD="align: center"]Smartphone[/TD]
[TD]Tablet[/TD]
[TD="align: center"]Laptop[/TD]
[TD="align: center"]PC[/TD]
[TD="align: center"]Other[/TD]
[/TR]
[TR]
[TD="align: center"]x[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]x[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]x[/TD]
[TD="align: center"]x[/TD]
[TD="align: center"][/TD]
[TD="align: center"]x[/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"]x[/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[/TR]
[TR]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"][/TD]
[TD="align: center"]x[/TD]
[TD="align: center"][/TD]
[/TR]
</tbody>[/TABLE]

What chart would you recommend ( if any ) to show that Person1 uses Smartphone; Person2 uses Laptop; Person3 uses Smartphone, Tablet, PC; etc.?

If no chart is really appropriate, that's okay. I was just looking for a more visual way to present this information.

Thanks!

 

[wootcat]

Oops. Title should read "into chart" not "into pie chart"

 

[wootcat]

I should have thought about this more before posting...

Maybe what I want is a chart (bar?) showing % of use for each device? X% use Smartphones, Y% use Tablets, etc.?

I've created a "charts" sheet, where I've used COUNTA to create a small table of device counts...

[TABLE="class: grid, width: 200"]
<tbody>[TR]
[TD][/TD]
[TD]Device Usage[/TD]
[/TR]
[TR]
[TD]Other[/TD]
[TD]0[/TD]
[/TR]
[TR]
[TD]PC[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Laptop[/TD]
[TD]4[/TD]
[/TR]
[TR]
[TD]Tablet[/TD]
[TD]2[/TD]
[/TR]
[TR]
[TD]Smartphone[/TD]
[TD]5[/TD]
[/TR]
</tbody>[/TABLE]

...but I am unsure how to turn this into a chart showing percentages.

Thanks!

 

[VBA Geek]

A column chart of bar chart sounds about right. You can use one axis to show the quantity and the other to show % of total