How do you make a chart using Text Data??? (Macro??)

Hi,

Not sure if this is what you want but

Define the name 'RecType' as

Formula:

=OFFSET(Recommendations!$O$7,1,0,COUNTA(Recommendations!$O:$O)-1,1)

Then wherever you need the count use formulae like

Formula:

=COUNTIF(RecType,"Compliance")

Formula:

=COUNTIF(RecType,"Improvement")