Results 1 to 7 of 7
  1. #1
    2 Star Lounger
    Join Date
    Oct 2008
    Posts
    141
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Data Plotting (Excel 2003)

    Hi,

    I have a data of showing the month, the name of the client, and the number of lessons given to each client. I created a Column chart showing the number of lessons for each client that was given in each month. An example sheet is attached. Note that the actual data contains other months and more client names.

    1) What I would like to do is colour the columns according to the client's name. For example, for Alex, the colour will be red, for Craig it will be Blue, for Doug it will be Green, etc. How can I go about to do that?

    2) In the Plot Area I would like to have a line seperating the months, sort of like a divider, so that it would show up better when I present this information. How do I do that?

    Any help would be appriciated. Thanks.
    Attached Files Attached Files

  2. #2
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    If you can rearrange the data into a table, it's simple - see attached.
    Attached Files Attached Files
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    2 Star Lounger
    Join Date
    Oct 2008
    Posts
    141
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks Rory, that's what I wanted. I tried to recreate what you've done (so that I can do it myself in the future), but I was not able to get the same chart that you got. The attached file is what I got. Can you explain to me what you did different than me?
    Attached Files Attached Files

  4. #4
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    When choosing the source data for the chart in the wizard, you need to plot by columns, not by rows.
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    2 Star Lounger
    Join Date
    Oct 2008
    Posts
    141
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Excellent, this worked. Last question, how did you get the nice chart colours (for the columns and the legend)? The colours that I get are the standard fill colours and they are pretty plain.

  6. #6
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    I changed the colour palette in the workbook. (Jon Peltier has an add-in for this on his site here.).
    Last edited by rory; 2011-03-11 at 11:17.
    Regards,
    Rory

    Microsoft MVP - Excel

  7. #7
    2 Star Lounger
    Join Date
    Oct 2008
    Posts
    141
    Thanks
    0
    Thanked 0 Times in 0 Posts
    Thanks for your help.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •