Hi all,
I'm struggling a little with excel, I am trying to plot some data on a scatter graph. Essentially I have a few months of call data with a date column and time column. What I want to do is on the X axis plot the day of the week e.g Monday - Sunday and on the Y axis I want to plot the time of the day. Any ideas, I have given it a try but the X axis seems to want to plot on a time scale jan - march rather than monday - sunday. I tried creating a column with the days of the week, and plot that instead of the date but get the similar results.
Any ideas help would be greatly appreciated.