Excel macro for multiple series in a single scatter graph using 3 columns
Hi. I am new to this forum and also new to macros to MS Excel. However, I do have a basic understanding of C++/VB codes and structures. So I really appreciate any help anyone can offer.
I currently am working on writing a macro for Excel to open a text data file and using the the data to make a graph. I already finished writing the part for opening and importing the file. However I am having trouble do the graphing part.
The data is in 3 columns. One is for x-axis (Column 1), one is for y-axis (Column 2) and one is for the IDs (Column 3). There are undefined number of IDs and the number entries under the same the IDs can vary, however they are all grouped together.
For example, the three columns would look like something below (sorry, I don't know how to embed the file in...):
Col1 (x)______Col2 (y)______Col3 (ID)
...and so on. There could be as few as one ID that only have one entry in the file or as many as 100 IDs with 100 entries under each of them. The part I cannot figure out is how to graph all the Column 1 vs Column 2 data with the same IDs (same values in Column 3) on the same graph.
Thanks for any help that you guys can offer.
By Pass0 in forum VB Classic
Last Post: 10-24-2005, 01:26 PM
Last Post: 10-23-2002, 10:35 AM
Last Post: 08-12-2002, 10:40 PM
By Rob Teixeira in forum .NET
Last Post: 06-06-2002, 05:23 AM
Top DevX Stories
Easy Web Services with SQL Server 2005 HTTP Endpoints
JavaOne 2005: Java Platform Roadmap Focuses on Ease of Development, Sun Focuses on the "Free" in F.O.S.S.
Wed Yourself to UML with the Power of Associations
Microsoft to Add AJAX Capabilities to ASP.NET
IBM's Cloudscape Versus MySQL