Help with Plotting Information on Chart

Burkieboy

New member
Joined
Aug 3, 2017
Messages
1
Reaction score
0
Points
0
Hi Guys

I am wondering if you can help me. I am trying to plot some information to a chart on excel that shows the following


5 Fixed Lines horizontally that represent different levels of wind speed. These values do not change


8 Lines representing different work teams wind readings every 30 minutes. These readings are taken from 7:00 - 16:00

The purpose of the graph is to compare each teams wind speed to the horizontal lines over 30 minutes increments daily, Weekly and then Monthly.

Is this possible ?
 
Create a table with 7:00 in B1, 7:30 in C1, etc, until 16:00 in T1

In A2:A6 enter the names of the fixed lines.3

In B2:T2 put the first set of fixed values.

Repeat for B3:T3... B6:T6.

In A7:A14 put your 8 team names and their readings alongside.

Plot the whole lot as a line chart.

I did it for 3 fixed values, 4 teams, and it looked like this

Capture.jpg
 
Back
Top