I have a macro question I was hoping someone could help me out with. I am very knowledgeable about Excel itself, but I have only just begun to actually use macros...I know essentially nothing at all about programming, in Excel or otherwise. Anyways, what I am trying to do is create a macro that will create graphs for me. I have attached a sample Excel sheet to demonstrate what I am trying to do. Anyways, as can be seen I have three columns of data. I am trying to make a macro that creates a graph with the numbers in column B on the X axis and the numbers in column C on the y axis. I want for each individual data series in the graph to be equal to the number in column A. In other words, if the numbers in column A are the same, I want for those data points to be in the same data series in the graph. There is an example graph in the file that is set up exactly how I want it.

I know how to create a macro to do this using the record macro feature, but that only seems to be valid if there are the same number of values. What I would like to be able to do is select a range of rows (ex: rows 11-200), and then automatically create an individual data series for all values in the "A" column that are the same. Because while sometimes I may have 5 rows of #35, sometimes I may only have 2, and other times I may have 15.

I greatly appreciate any help that you can provide! Please let me know if I need to clarify anything.



TestGraph.xlsx