I have the same task. I would like to plot both date and time on the x-axis
to track deviations in data over time. My problem is I have the date and the
time in two different columns foor the incoming data. How can I make these to
variables appear in the same cell?

Christina

"Raja" wrote:

Hi there

What do you think would be best chart format to analyse some data that
consists of:
Date of Call out
Day of call out
Time Of Call out
Call out Reference

I am trying to see if there is any pattern in the days & times of call outs
to improve rosters.

Basically I want the time of callout & day of week mapped across
dates/months to see any trends.
For example if Fridays at 1am are a recurring callout time (after the pub!)
or every other Friday etc.

Do yo uthink Pivot tabe and charts is relevant or can normal chart provide
me with the results?

Many thanks