chart various categories in excel for each client

Posted on 2012-08-12
Last Modified: 2012-08-13
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?
Question by:PeterBaileyUk
    1 Comment
    LVL 25

    Accepted Solution

    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.

    Featured Post

    How your wiki can always stay up-to-date

    Quip doubles as a “living” wiki and a project management tool that evolves with your organization. As you finish projects in Quip, the work remains, easily accessible to all team members, new and old.
    - Increase transparency
    - Onboard new hires faster
    - Access from mobile/offline

    Join & Write a Comment

    Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
    Introduction This Article is a follow-up to my Mappit! Addin Article (, it was inspired by an email posting I made to EUSPRIG (, I will briefly cover: 1) An overvie…
    The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
    This Micro Tutorial will demonstrate in Google Sheets how to use the HYPERLINK function to create live links inside your spreadsheet.

    745 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    16 Experts available now in Live!

    Get 1:1 Help Now