Excel Guru's

[TheCake]

I am trying to create a graph from some verticle data.

In column 1 I have 1 answer on each row, either yes, or no, for 27 rows.

Looks like

Yes
No
Yes
Yes
Yes
No
No
Yes
etc... etc...

I'd like to do a pie chart to show all the Yes's and all the No's but I can't work out how to do it.

Help!

Thanks

 

[run115]

There is a graph button on the toolbar, then it opens up a wizard for you, where it will ask you what are the values for the y and x axis, then input values. After you finish you can change to pie chart or whatever graph you want.

Vince

 

[MarkCup]

Playing about with the database functions in Excel is a pain in the a***...so try it this way...

In a 2nd column (cell B1) enter =IF(A1="YES",1,0)
In the 3rd column (cell C1) enter =IF(A1="NO",1,0)

At the bottom of these two columns, put a heading (Yes/No) and a total - that'll give you the graph number/ratio/data that you'll need for the chart wizard to take effect.

The reason it's greyed out is you're only selecting one set/column of data, and it doesn't know what you want to do with it.

 

[TheCake]

Yes Vince I know but it doesn't work - its greyed out. You try it.

 

[MarkCup]

 

[TheCake]

Nice one Mark. How annoying is that! Have a nice fat pie chart now exactly what i needed for my report. ta bud - must catch up soon when I pick up the new beast.

 

[MarkCup]

Get to Brands on 21/08?

 

[TheCake]

Yeah. See you there. Will bring toy which I should have by then hehe.

 

[run115]

Sorry bout that, didnt reply cos I was a bit busy at work then, could have explained better though, but as long as you got it...........

Vince