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

Smartphone	Tablet	Laptop	PC	Other
x
		x
x	x		x
x
			x

<tbody>
</tbody>

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

	Device Usage
Other	0
PC	2
Laptop	4
Tablet	2
Smartphone	5

<tbody>
</tbody>

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