Dates on line graph X-axis not in normal order

Looking for help again.
I have two workbooks. One is for daily data entry. The second, I have pulled data from the data sheet, and this data will be graphed in the same workbook.
The problem I am having is that the x-axis is the dates from the data sheet. They are not always in 1,2,3 order and most of them are duplicated (due to 2 shifts on each day), and I need it to graph that way. If I choose the date format, it goes 1-30 and skips a lot of data. If I choose as text, it shows all the blanks. I know I can manually filter them out and manually select the date span, but I am trying to make this completely dynamic (as some people reviewing the chart may not be excel savvy). It works by choosing the starting date on the "Data" tab on the Chart Sample sheet. On the graph tab I have two sample graphs (using the same data) to show some of the things I have tried.
I have tried the NA() but the graph, graphs the NA. I have tried a bunch of different things.
I have attached the two sheets. The chart sample sheet is protected (so i didn't screw up previous progress) but there is no password.
Any help is greatly appreciated.

Thank you

Edit: I forgot to mention, this will be primarily used in excel 2010.

If I understand what you are trying to do, I think you want to use the second chart (with the text/category axis) coupled with dynamic named ranges for the chart data series (especially the horizontal category axis data). Dynamic charts using dynamic named ranges are an old topic in Excel circles. A couple of pages to get you started:
http://www.excel-easy.com/examples/d...med-range.html
https://peltiertech.com/dynamic-charts/

Most dynamic named ranges are built using the OFFSET() function, so there is value in becoming vary familiar with this function: https://support.office.com/en-us/art...e-b4d906d11b66

A key part of the OFFSET() function will be the "width" parameter, which will usually be some kind of counting function (COUNT() or COUNTIFS(), probably). https://support.office.com/en-us/art...c-aa8c2a866842

Does that help?