Friday Challenge – The Right Graph Style For What I Want to do

A newer Excel Chart creator had this question:

“This is a scatter with smooth line and markers graph. What I would like to have displayed, is everything above the blue line one colour, between the blue and green line another colour, and between the green line and the base a final third colour.
Friday Challenge Sample
Is this possible with the graph style I chose? If so, how? Perhaps there is a more appropriate graph? (I like the smooth line)”

– Ark, Ontario, Canada


How would you recommend the user create the chart that they are looking to do?


a) Vertical Axis must start and end at the times 5:31PM and 7:55PM

b) From the Horizontal Axis to the Green Line should be one color

c) From the Green Line to the Blue Line should be one color

d) From the Blue Line to the top of the chart at 7:55PM should be one color

e) Start with this as your Sunset and Sunset Off Data Series:

You should just be able to copy and paste the data directly into a blank Excel Workbook.

1Sunset OffSunset
215:35 PM5:55 PM
325:36 PM5:56 PM
435:37 PM5:57 PM
545:38 PM5:58 PM
655:39 PM5:59 PM
765:40 PM6:00 PM
875:41 PM6:01 PM
985:42 PM6:02 PM
1095:43 PM6:03 PM
11105:44 PM6:04 PM
12115:45 PM6:05 PM
13125:46 PM6:06 PM
14136:50 PM7:10 PM
15146:51 PM7:11 PM
16156:52 PM7:12 PM
17166:53 PM7:13 PM
18176:54 PM7:14 PM
19186:55 PM7:15 PM
20196:56 PM7:16 PM
21206:57 PM7:17 PM
22216:58 PM7:18 PM
23226:59 PM7:19 PM
24237:00 PM7:20 PM
25247:01 PM7:21 PM
26257:02 PM7:22 PM
27267:03 PM7:23 PM
28277:04 PM7:24 PM
29287:05 PM7:25 PM
30297:06 PM7:26 PM
31307:07 PM7:27 PM


Can you solve this request?  Leave me how you would create the chart in the comments below or drop me a comment with your email address if you want to send in your solution.

Good luck!  But you don’t need luck as you are sure to complete this one quickly.



Please enter your comment!
Please enter your name here