1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

    Yours,
    Chandoo
  2. 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...

  3. 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....

Discussion in 'Discuss Data Visualizations and Charting' started by unak, Jun 23, 2018.

  1. unak

    unak New Member

    Messages:
    4
    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.

    Attached Files:

  2. vletm

    vletm Excel Ninja

    Messages:
    3,678
    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.
  3. unak

    unak New Member

    Messages:
    4

    Attached Files:

  4. vletm

    vletm Excel Ninja

    Messages:
    3,678
    unak
    Yes ... I found some connections with original file,
    but some ... would come somewhere?
    Try to reread You original post ...
  5. unak

    unak New Member

    Messages:
    4
    Here is the simple file in XL attached hope that works, I am not computer savvy person to began with

    Attached Files:

  6. vletm

    vletm Excel Ninja

    Messages:
    3,678
    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 ...
  7. unak

    unak New Member

    Messages:
    4
    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
  8. vletm

    vletm Excel Ninja

    Messages:
    3,678
    unak
    It would be something like this ...
    Some of You 'wishes' won't open for me.
    I would use only written 'wishes'.

    Attached Files:

Share This Page