Need chart help with changing x values

[eface2face]

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

[eface2face]

Also, I don't necessarily have to have it say AM or PM, if it could just show times between 6:00 and 6:00, that would work for me too.

[ben_hensel]

Also, I don't necessarily have to have it say AM or PM, if it could just show times between 6:00 and 6:00, that would work for me too.

In this case, I think the fastest thing to do would be, subtract 12 from the night data, so they're AM values, move them to their own set of columns, and then change the format of the labels from h:mm:ss AM/PM to just h:mm or something like that.

Anyway, if you want something like two different sets of x-axis, I don't even know how I'd do that; I hazard to guess what you'll probably end up doing is "spoofing" the x-axis no matter what your solution ultimately is, rather than actually having two different x-axis, one layered over another.

[ChemistB]

You could attach a macro to your dropdown box. Something like this

Please Login or Register  to view this content.

It sucks that Excel defaults to 12 midnight on your day shift. :-/

[eface2face]

You could attach a macro to your dropdown box. Something like this

Please Login or Register  to view this content.

It sucks that Excel defaults to 12 midnight on your day shift. :-/

Your code helped out, I was able to mess around with it and get things the way I wanted. Thank you very much.