Hi, I have attached an excel file in which I have 4 data sets with morning and night shift values. I have created a chart that graphs the data, and I have check boxes that enable me to display and not display each data set at my leisure. The problem I am having is when I change the shift from Day to Night, the x axis does not change the way I want it to. It shows the night data fine while the day data is all bunched together. Does anyone know how I can get it so that both night and day data can be graphed with the same x axis range ( but at different times)?

Any help is much appreciated.
Graphproblem.xlsm