I have been working with VBA excel for a few months now but have been struggling on one part for a week or so now. I am unable to post my workbook, so bare with me that I am able to explain my problem sufficiently, and I will gladly answer any questions quickly.


I am wishing to plot multiple series dependent on what one column contains. My X data is in M14:last point (I mean the number of data varies each time, so wherever the last point is), and Y data is N14:last point. In cells O14:last point there is a description of the type of fruit the data is for. I have it so the data is sorted so all apple, banana, etc are grouped together, so there is no need to search through the data and group together, they will be in successive cells until the next group appears. I need the series to be dependent on this description. If the data is listed as apple, then those are then plotted as one series, if it is banana then those are all plotted together, etc. These are just example descriptions and I have many more, but again I have faith if I can have this simple work then I can expand it (and besides I like learning how to do it myself).

I hope this description is sufficient, ask questions if need be.

Below is what I have so far, but it seems to only grab the last point, I can't get it to group together or plot multiple points. I think the scount is where I am having trouble, I use the scount portion when I want individual data labels, and it worked like a charm, but I was trying to declare that when you see apple its scount 1, making it the same series each time. 

Please Login or Register  to view this content.