+ Reply to Thread
Results 1 to 5 of 5

how to add a line chat to a stock chart

  1. #1
    Valued Forum Contributor luv2glyd's Avatar
    Join Date
    07-13-2008
    Location
    Seattle, WA, US
    MS-Off Ver
    Excel 2010
    Posts
    679

    how to add a line chat to a stock chart

    It's easy to add a line chart to a stock Open-High-Low-Close chart b/c that chart type allows you to put the line chart onto the secondary axis. I'm having trouble, though, adding a line chart to a stock Volume-Open-High-Low-Close chart. Is that possible to do?

    Thanks
    You either quit or become really good at it. There are no other choices.

  2. #2
    Forum Expert dflak's Avatar
    Join Date
    11-24-2015
    Location
    North Carolina
    MS-Off Ver
    2013 / 2016 / 365
    Posts
    7,140

    Re: how to add a line chat to a stock chart

    Without a sample workbook the best I can do is describe it verbally. Right click on the chart and select Select Data. Then click on Add Series and fill in what you can. Then click on the series and right click and select Changes Series Chart type.
    One spreadsheet to rule them all. One spreadsheet to find them. One spreadsheet to bring them all and at corporate, bind them.

    A picture is worth a thousand words, but a sample spreadsheet is more likely to be worked on.

  3. #3
    Valued Forum Contributor luv2glyd's Avatar
    Join Date
    07-13-2008
    Location
    Seattle, WA, US
    MS-Off Ver
    Excel 2010
    Posts
    679

    Re: how to add a line chat to a stock chart

    I tried that.... get the dreaded "Can't combine chart types" error.


    Here's a sample worksheet. Any other suggestions?
    Attached Files Attached Files

  4. #4
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    13,462

    Re: how to add a line chat to a stock chart

    I would make the same suggestion I made over the weekend (http://www.excelforum.com/excel-prog...-with-vba.html ). The built in stock charts don't seem to like to be combined with other chart types. If your "stock" chart were a "box and whiskers" chart (basically a stacked column chart), then it would be fairly easy to combine that with a column (for volume) and a line (for average) chart.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  5. #5
    Valued Forum Contributor luv2glyd's Avatar
    Join Date
    07-13-2008
    Location
    Seattle, WA, US
    MS-Off Ver
    Excel 2010
    Posts
    679

    Re: how to add a line chat to a stock chart

    Quote Originally Posted by MrShorty View Post
    I would make the same suggestion I made over the weekend (http://www.excelforum.com/excel-prog...-with-vba.html ).
    Yeah, in OHLC stock chart I can do what you and I talked about above to show grid lines exactly where I want to see them. I can also easily plot as may line charts as I want to b/c it allows use of secondary axis. Was just wondering if there's some other kind of work-around trick for the VOHLC chart without having to split it up into two separate charts: OHLC and V (Volume).

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Stock chart, format the line
    By William... in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 01-11-2017, 04:43 AM
  2. How to add DowJones Line Chart on to Yahoo Stock Chart
    By HerryMarkowitz in forum Excel Charting & Pivots
    Replies: 24
    Last Post: 02-10-2015, 05:49 PM
  3. Add Horizontal line to stock chart
    By 4dplane in forum Excel General
    Replies: 6
    Last Post: 12-19-2012, 08:51 PM
  4. Stock chart - combo of line and bar chart
    By cw56 in forum Excel General
    Replies: 2
    Last Post: 11-15-2010, 06:19 AM
  5. Line Chart (Stock Intraday Chart)
    By prabs in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 02-25-2007, 06:19 PM
  6. [SOLVED] Vertical line in stock chart
    By wittmaennle in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-21-2006, 11:10 PM
  7. [SOLVED] How to add a line to a stock chart
    By Kingshuk in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 05-19-2005, 09:06 AM

Bookmarks

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