Graph help - in Excel 2010

[Collette]

Hi Guys, I was wondering if you could help me, I'm good with formulas etc but seem to be struggling with this graph which is quite embarrasing.

I want to plot a graph which shows the times of visits, split by days. So it would be like a scatter graph, time and day of the week.

X axis
00:00
01:00
02:00
to
24:00

Y axis

Mon Tue Wed Thur Fri Sat Sun

Each day would have multiple visits.

I don't know what it is that i'm doing wrong but i can seem to create this.

Please can you give any advice?

Many thanks,

Collette
xx

 

[Steve=True]

Hi Collette,

Welcome to the forums.

Here is a screen shot that show i think what you want to do:

Steps:
1) Create your data with 1's and Zero's. 1=Worked 0=Not Worked
2) Notice the formula for the Fill's columns is such that if the hour it relates to = 1, then make it 0 or else 1 c2=IF(B2=1,0,1)
3) Create Chart
4) Change Fill Series to NO FILL
5) Change Numbered Series to same fill color
6) udpate 1's/zeros as needed

Please let me know if this helps or if you need more of a tutorial on the process. THanks

Steve=True