• 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

  • Analysis June 17 2018.doc
    273 KB · Views: 3
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.
 
unak
Yes ... I found some connections with original file,
but some ... would come somewhere?
Try to reread You original post ...
 
Here is the simple file in XL attached hope that works, I am not computer savvy person to began with
unak
Yes ... I found some connections with original file,
but some ... would come somewhere?
Try to reread You original post ...
 

Attachments

  • Book1 for bar chart.xlsx
    15.2 KB · Views: 2
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 ...
 
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
 
unak
It would be something like this ...
Some of You 'wishes' won't open for me.
I would use only written 'wishes'.
 

Attachments

  • Book1 for bar chart.xlsx
    36.3 KB · Views: 3
Back
Top