Plotting graph excel VBA

**blh** · 08-08-2014, 02:20 AM

Good day,

I am trying to plot multiple line graphs on one chart but am having trouble setting the SeriesCollection values. I think the problem is because data set it in one column only

eg

A B C

Jan-12 Name1 3
Feb-12 Name1 9
Mar-12 Name1 4
Jan-12 Name2 5
Feb-12 Name2 8
Mar-12 Name2 12

Hence, I would like to plot Name1 and Name2 data on one chart for each month.

How do I do this in vba?

**MrShorty** · 08-08-2014, 10:24 AM

I think the problem is because data set it in one column only

As I suggested yesterday, I agree with this assessment -- I think much of the difficulty is related to having the data in a single "list". I suggested that you put the data into a different format, and suggested that you review Dennis Wallentin's code for filtering and copying data. Did you judge Mr. Wallentin's code unsuitable, or did you not understand enough of it to implement his code? It might help us help you if we understood what about the previous suggestions you found unsuitable.

If you are simply unfamiliar with Excel's filtering functions, I might suggest that you start by doing the task manually (http://office.microsoft.com/en-us/ex...616.aspx?CTT=1 ). In the process of automating Excel's features, I often find that I need to understand how to use the feature manually before I can effectively write code to automate the same process.

**blh** · 08-10-2014, 12:03 PM

Thank you everyone, I did consider the use of filtering however, this did not suit the data source I am using.

I did find a solution by using .Chart.SeriesCollection.NewSeries.Values for each of the charts I want to add.

Thanks!