Plotting graph excel VBA

**blh** · 08-07-2014, 09:52 AM

Good day,

I would like to plot multiple lines on one line graph. However, the source data all comes from one column range. This gives me an error when using the .Chart.SeriesCollection code.

My source data looks like this:

A B C
Jan-12 Name1 10
Feb-12 Name1 15
Mar-12 Name1 5
Jan-12 Name2 20
Feb-12 Name2 10
Mar-12 Name2 8

Based on the above I would like to plot values (in cloumn C) for name1 and Name 2 for the months jan-mar on the same graph in order to compare them.

How do I define this in vba?

**MrShorty** · 08-07-2014, 10:52 AM

This isn't the kind of program I do much of, so I'm not very good at it. In my experience, whether in VBA or using spreadsheet formulas, these kind of problems are more about the arrangement of data in the spreadsheet. My own approach to this would be to arrange the data differently in the spreadsheet. Something like (comma delimited):

Please Login or Register  to view this content.

Rearranging the data like this in VBA might be easiest using filters. If you examine the sample code at the end of this help document (http://msdn.microsoft.com/en-us/libr.../ff838238.aspx ), he uses the advanced filter tool to copy subsets of the larger data set into another range. You may want to do something similar with your project: filter and copy the various subsets of the data into a table like I show above. Then you should be able to easily use this range as the data source for you chart.