Want to protect your cyber security and still get fast solutions? Ask a secure question today.Go Premium

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 218
  • Last Modified:

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
0
PeterBaileyUk
Asked:
PeterBaileyUk
1 Solution
 
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

Featured Post

Get your problem seen by more experts

Be seen. Boost your question’s priority for more expert views and faster solutions

Tackle projects and never again get stuck behind a technical roadblock.
Join Now