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.
