(how) Can I do this graph?

  • Thread starter Thread starter Thomas Andersson
  • Start date Start date
T

Thomas Andersson

Hi!

I've been fiddling about scratching my head and I just can't get what I want
so hopefully someone here can help.


The data I have are 1 column with timestamps, 1 with force type, 1 with
force strength.
The events I'm tracking runs for two hours with diminishing force strength
over time.
What I want is to track each force type separately over time (horizontal)
showing each incidents strength (vertical). I can set it up with one line
with the average force over time, but not with the types separated into
different lines.
Also the horizonatal marks become the timestamps, I want a fixed timeline
horizontal with timestamps properly plotted allong it.

Any advice on how to do this if at all possible?

TIA
Thomas
 
Try to split the force types out by column with a PivotTable:
Put time as a row field, force type as column field, and streng as data field.
You can now copy and paste values and use the chart wizard on this layout.
 
Back
Top