I need to create an Excel chart with 5 sets of variables
 

I have an Excel spreadsheets that lists information about a survey conducted
for projected T-shirt sales. The variables are Gender, GPA, Preference of
the two t-shirts available, age of the participants, income, and whether
someone is left-handed or right handed. I need to prepare a chart that will
reveal the preferences revealed by the data, do most people prefer the red or
the white t-shirt, does gender make a difference in preference? does age?
income?

I need to create an Excel chart with 5 sets of variables
 

Hi,

Maybe a tornado chart would be of use.
http://peltiertech.com/Excel/Charts/tornadochart.html

Although the Age question maybe a problem depending on whether you can
create age groups from your data.

Cheers
Andy

Marsh2114 wrote:
I have an Excel spreadsheets that lists information about a survey conducted
for projected T-shirt sales. The variables are Gender, GPA, Preference of
the two t-shirts available, age of the participants, income, and whether
someone is left-handed or right handed. I need to prepare a chart that will
reveal the preferences revealed by the data, do most people prefer the red or
the white t-shirt, does gender make a difference in preference? does age?
income?

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info