Hi,
I have been able to write the following VBA code to loop through the data in my spread sheet and add each Series to a separate Chart.
What I would like to do now is instead of creating a separate Chart for each series, I would like all Series to be added to the same Chart (as they all have the same X Value range).Please Login or Register to view this content.
The data I have is in the following format:
In this file if Column 3 = "0" this is a header Row where by:Please Login or Register to view this content.
The rest of the Rows are the data:Please Login or Register to view this content.
Also, an example data file is attached (example_data.txt).Please Login or Register to view this content.
Please let me know if you have any suggestions on how to create one chart with all the series added to it.
Thank you
Bookmarks