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.
Bookmarks