+ Reply to Thread
Results 1 to 2 of 2

Time Series Chart with Volume

  1. #1
    Registered User
    Join Date
    MS-Off Ver
    Excel 2007

    Time Series Chart with Volume


    my problem is that i need to plot a time series:

    My database is a time series of stock prices with volume (tick data) and i want to plot it as a line chart with a volume bar chart in the lower section.

    Is this possible with Excel?


  2. #2
    Registered User
    Join Date
    MS-Off Ver
    Excel 2010

    Re: Time Series Chart with Volume

    I don't trade stocks, but I trade sport exchanges, and I suppose that's standard graph, which has time scale on X-axis, price as line in one Y-axis, and volume as bars in another Y-axis? If so, look at the attachment.

    All data are on sheet "Data". You create this chart in following way:

    1. Create a standard chart, with column "Time" on "Category X labels", and "Price" and "Volume" as series values (series 1 and 2).

    2. Double click on series you want to be on right side Y-axis (I put price on right side in my example), pop-up window will appear; on tab "Axis", select "Plot series on secondary axis".

    That's it. Then just format lines, colours, etc. as you like.
    Attached Files Attached Files

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)


Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1