Hello,
I have about 9,000 lines of data and I am trying to create a pie chart showing 4 different divisions. My data is representative of 4 different names: FSH, RL, PCL, and PTR and is randomized in 1 column.
For example:
FSH
FSH
RL
PTR
FSH
PCL

I simply want to highlight all of these qualitative values and have a pie chart add them up for me from the column to represent the percentage of each one in one in the pie chart. Therefore, it may show something like 53% FSH, 7% RL, 20% PTR, and 20% PCL. However, when I highlight the columns and attempt to turn it into a pie chart, it does not condense all FSH's together and all RL's together and so forth to accomplish an percentage. Any ideas?