How to combine various date columns for X axis

[brucemc777]

In designing my tables for each individual's performance, I fear I messed up. I created a table for each person and in each table the first column is the date of the observations, then the next 5 or 6 columns are the observations (all numerical). If I was only going to want to show one person's series (columns - chosen from columns 2 through 5 of the table, with column 1 always being a date for the X axis) at a time, that wouldn't be a problem, but I also want to chart comparitives of one specific series (for instance, column 2 in each table) for multiple people. Since they can be in on different days, each Y data point is associated with a date. Person "George" might be here every third day of the month, "Alice" might be here on days starting with the letter "T" - the point I am trying to make is that the X axis values might not line up, and generally don't, though are still within the same basic time frame.

Do I have to recreate all of my tables (not really that many, maybe 15) so that each has all the same dates and simply dummy data for days not present (presumably repeat of the last day observations taken), or is there a way to create an X axis of all the days in a span and then plot each (X,Y) from each person's table of interest? The charts are basic line charts.

To generate the charts I am using the following that first wipes clean all of the series previously charted then checks each person's checkbox, if checked, it will be graphed. iTest is an integer that represents the total number of checkboxes, checked or not, wsData is the worksheet with the data tables, each table is as prior described and it also seeems apparent that presently whatever is in the first column of the last table added to the chart becomes the X axis regardless of where everything else was plotted...:

Please Login or Register  to view this content.

and... if you see any stooopid things, I am just starting to get a handle on charting and gaining a lot of my learning from examining macro generated code, so criticism is welcome!

[brucemc777]

It appears that the solution is to use a Scatter chart, but I still have to fix one major problem (at least one that I so far see), in that all the entries I placed in my table that correspond to dates were under general format and coded 140510 for May 10, 2014, and so on. I need to convert all of the 6 digit references to the proper days or Excel sees these as numbers and creates large gaps from what would be the 30th or 31st of each month to the first of the next month, for it is working with a 1 to 100 "system" and I am working with a 1 to 31 "system".

Creative thoughts?