Graduate Count per Program per Year
Hello:
I have a Graduation Data table that includes the following fields:
Term - Text-Multiple Choice Field
Program Title -Text Field
Count - Numeric Field
Data
2...
Forum Discussion
To expand on Chayce's suggestion:
You can extract the year (as he is stating) with a formula: [Term Year] = Trim(Left([Term]," "))
Bar chart on x axis will sort by Term Year (equal values).
Data values on y axis will be the Count, Summed.
In series you select the Program Title.
------------------------------
Mike Tamoush
------------------------------
Thank you, Mike. I appreciate your detailed message. I am one step closer to my goal, and my new chart looks good, except the legend displays numbers rather than the program names. How can I display the program names instead of numbers in the legend?
------------------------------
Roula Habbal
------------------------------Update - I figured it out.
Thank you, gentlemen, for your help and time.
------------------------------
Roula Habbal
------------------------------
