Help with Excel

zingo
zingo Posts: 11,258
edited February 2014 in The Clubhouse
I need help with excel as I'm trying to get it to graph a logged number of occurrence. If I'm already tracking AM, PM, and NOC in a spreadsheet, how can I graph the number of times each those are logged so I can look for trends. I'm pretty good with number graphing and chart, but have never done something non-numaric like this in excel.

Thanks for the help!
Jake
Post edited by zingo on
· Share on FacebookShare on Twitter

Comments

  • mantis
    mantis Posts: 17,201
    edited February 2014
    Man good luck with that, I can't use Excel either. I wonder if You tube has some videos on how to use it the way you need? I suggest gong over there.
    Dan
    My personal quest is to save to world of bad audio, one thread at a time.
    · Share on FacebookShare on Twitter
  • zingo
    zingo Posts: 11,258
    edited February 2014
    Thanks and I'll check out YouTube. I'm actually pretty decent at Excel, but I've only graphed from numeric formulas, and this isn't quite that...
    Jake
    · Share on FacebookShare on Twitter
  • halo71
    halo71 Posts: 4,606
    edited February 2014
    Would the TREND function be of any use for this? Like: = INTERCEPT (known Y values, known X values, New X Value, Const)

    I once was a whiz with Excel. Could write a formula for about anything I needed. But that was years ago.
    --Gary--
    Onkyo Integra M504, Bottlehead Foreplay III, Denon SACD, Thiel CS2.3, NHT VT-2, VT-3 and Evolution T6, Infinity RSIIIa, SDA1C and a few dozen other speakers around the house I change in and out.
    · Share on FacebookShare on Twitter
  • Easy Runnin
    Easy Runnin Posts: 501
    edited February 2014
    I'm on a tablet at the moment but I think the function is countif.
    HT- Samsung PN50B860/Integra DTR 30.3/Rt55 Fronts
    Rt35i Surrounds/Cs1000p Center/SVS BP1000 Sub
    2CH - B&K MC-101 pre/B&K EX-442 amp/NAD 2400 amp
    Polk SDA1C, Polk Monitor 7, New Large Advents and Polk RTA 8T
    BR - Yamaha CR800/Polk monitor 5
    · Share on FacebookShare on Twitter