• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

How to convert data to Barchart....

unak

New Member
Hi Chandon /every one,
I have been enjoying post for long time but never use forum this is my first time.

i have attached a data file of my trading activity, like to convert data in bar chart using Green color for positive, Red for negative, and bar value in $ 1234.56 at top of bar.
Using Jan 1 to Dec 31 date , Id each END of bar with abbreviate like oil,cattle,bean , whet,gold,silver et. all commodities in alphabetic order.

Also like to draw a line to check win / loos Green/Red for draw down with 12 months columns to view to pin point win/lose months.
 

Attachments

vletm

Excel Ninja
unak
Did You attached a correct data file?
Some terms that You use do not match ... to that doc-file.
Of course, You would make a sample layout of Your charts.
 

vletm

Excel Ninja
unak
Yes ... I found some connections with original file,
but some ... would come somewhere?
Try to reread You original post ...
 

vletm

Excel Ninja
unak
You sent same file (#3 Reply) again...
It's challenge,
if You won't give clear vision of Your 'wish' and data which would support that.
You could try to use paper and pencil to draw ...
 

unak

New Member
Capture bar chart 6-25-18.JPG here is the sample file:
there are several commodity future i currently trade few see the abbreviations below. these are future options side of symbols.

oil= CL, GOLD=GC,SILVER=SI, CORN=C, SOY BEANS=S, LIVE CATTLE= LC,
WHEAT=W, S&P 500=ES, DOW JONES= YM, NASDAQ= NQ, US $= $,
AUSTRALIAN $=6A, , BRITISH POUND= B6, EURO = E6,SWISS=S6, YEN=J6,30 YEAR BOND= ZB, 10 YEAR NOTE=ZN.

i want price at top of the bar, symbols at bottom
also line chart of each symbol

if possible you can email me your phone # country code ETL i can call you , time reference to New york usa time
 
Top