Excel charting alpha 3

[cjbrown815]

Hello, Excel 2007

I have values A,B,C,D,AA that are from a sediment test

I need to chart the percentage of each value entered from the beginning of the year to today. No clue where to start. Thanks

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931

 

[SkipVought]

Then, your formula is an EQUALITY rather than a quotient calculation, according to your stated True/False results!!!

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[cjbrown815]

It is returning True/False but I need the percentage. How do I change it?

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931

 

[SkipVought]

What happens in the Formula Bar, if you select as indicated and hit F9 -- observe value -- hit ESC?
[tt]
=[highlight]COUNTIF(Table1[RESULT],A2)/COUNTA(Table1[RESULT])[/highlight]
[/tt]


Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[SkipVought]

keyboard mapping???

enter this in an empty cell
[tt]
'/
[/tt]
assuming that this value is in A1, enter this formula in an adjacent cell
[tt]
=CODE(A1)
[/tt]
What value is returned?

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[cjbrown815]

Its working!!! I was working on a bunch of graphs and was getting permission issues when I tried saving, when I rebooted I checked this thread and when I opened the workbook...its working!!!!! WTH


Thanks for hanging in there for me Skip. I owe you one.

-CJ

SQL2005// CRXIr2// XP Pro

"Progress lies not in enhancing what is, but in advancing toward what will be"
-KHALIL GIBRAN 1883-1931