Need help setting up excel chart. - Zilvia.net Forums | Nissan 240SX (Silvia) and Z (Fairlady) Car Forum

rancid240 · 10-27-2004, 01:05 AM

I have a lot of info from a survey I just did. I entered it into excel, one side with the name of the info and the other side with the # of results. Now I want to set up a bar chart. It needs to have a comparison as in percentage of total results-i.e., i had 85 males and 15 females answer the survey (question #1). So what I want is a bar that has 85% males, 15% females, and another bar for the next question and so on. If I try to do it automatically excel makes a really big dumb confusing chart-since there are 48 lines of info, it tries to put them all on one bar. If I mess with it by adding series 1 and 2 and so on, It only makes 1 bar...confused? so am i....

aznpoopy · 10-27-2004, 03:26 PM

edit: nevermind i just reread.

u want a graph with one new bar for each question? u need to arrange the data in the order you want it shown on the graph. that's all.

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Hybrid Mode Switch to Threaded Mode

10-27-2004, 01:05 AM	#1
rancid240 Post Whore! Join Date: Jan 2002 Location: Irvine CA Posts: 2,770 Trader Rating: (72) Feedback Score: 72 reviews	Need help setting up excel chart. I have a lot of info from a survey I just did. I entered it into excel, one side with the name of the info and the other side with the # of results. Now I want to set up a bar chart. It needs to have a comparison as in percentage of total results-i.e., i had 85 males and 15 females answer the survey (question #1). So what I want is a bar that has 85% males, 15% females, and another bar for the next question and so on. If I try to do it automatically excel makes a really big dumb confusing chart-since there are 48 lines of info, it tries to put them all on one bar. If I mess with it by adding series 1 and 2 and so on, It only makes 1 bar...confused? so am i....

10-27-2004, 03:26 PM	#2
aznpoopy Post Whore! Join Date: Mar 2003 Location: New Jersey Age: 44 Posts: 5,013 Trader Rating: (1) Feedback Score: 1 reviews	edit: nevermind i just reread. u want a graph with one new bar for each question? u need to arrange the data in the order you want it shown on the graph. that's all.