chart various categories in excel for each client

I would like to know how to create a chart.

I have for 8 clients data for each month:

                                                                      Jan                                Feb                
New Codes Match Cars SMMT
New Codes Match Cars CW
New Codes Match Bikes SMMT
New Codes Match Bikes CW
New Codes Match LCV SMMT
New Codes Match LCV CW
New Codes Match Others SMMT
New Codes Match Others CW                  C1    C2     C3                    C1    C2     C3

How do I get the chart to put the clients months data side by side against each category for each month?
ee-ex-excel.PNG
PeterBaileyUkAsked:
Who is Participating?
 
lwadwellCommented:
What do you mean by chart?  It seems to me like a pivot table would do, please look at the attached and confirm or clarify further.
Q-27826392.xlsx
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.