charts in excel

[Fredrik_Trader]

I'm tracking my trades in an excel sheet. Each row represents a new trade and since I trade on different markets I have a column where I specify which market the trade been initiated on.

My question is if anyone know if theres a possibility to chart the P/L for each market? I've solved how to get a chart for all my trade.

Can anybody help me with this?

Thx in advance.

 

[Sam Mcgee]

Excel has a charting function built in, here's some information on how to use it:
http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=209
That should do what you need.

If you're wanting to chart prices, technical indicators etc and use them in conjunction with Excel, Sierrachart does a great job of it.

 

[PitchBlack]

google "dynamic charting in excel" and you will be busy for a few days with the information you get.

 

[Dell-Boy]

http://www.financial-edu.com/excelcourses.htm

 

[Fredrik_Trader]

Thank you for your fast reply!