Visulaization of customer test data and time using scroll bars and dropdown menu

[Alex_a]

Hi,

I have a list of customers and their respective product test dates (day and time of the test) fro different months. I need a time serious type data visualization that can filter out the month of the year and particular department showing the names of customers and their performed test dates. Since these test dates may range form hours to days, a scroll bar for the X and Y axis is needed for tracking purposes. I have attached the file with description how this data should be visualized. Any hints or help will be greatly appreciated. No macros please.

 

[GraH - Guido]

Do you mean like this?

 

[Alex_a]

Great job. solved!

 

[Alex_a]

GraH - Guido,

This is the new file... Thanks.

 

[GraH - Guido]

For the format, you can select the cells and format accordingly.

 

[GraH - Guido]

Look at PM for the new file.