+ Reply to Thread
Results 1 to 2 of 2

stock chart with extra series

Hybrid View

  1. #1
    Registered User
    Join Date
    03-14-2016
    Location
    Poland
    MS-Off Ver
    2014
    Posts
    1

    Question stock chart with extra series

    Hi,

    I don't know if similar topic was but I didn't find it..

    I want stock chart with extra lines and bar chart in
    sample data:

    Time Open High Low ExtraLine Close BarChart extraLine2
    9:31 1353.25 1353.50 1352.00 1352.00 1352.75 13388.00 1353.50
    9:32 1352.50 1353.00 1352.50 #N/A 1353.00 4770.00 #N/A
    9:33 1353.00 1354.25 1352.75 #N/A 1354.00 7424.00 #N/A
    9:34 1354.00 1354.50 1353.75 1355.25 1354.00 7475.00 1383.75
    9:35 1354.00 1355.00 1353.75 #N/A 1355.00 14765.00 #N/A
    9:36 1355.00 1355.50 1354.25 #N/A 1355.50 9902.00 #N/A
    9:37 1355.50 1356.75 1355.25 #N/A 1356.25 12661.00 #N/A
    9:38 1356.25 1357.50 1356.00 1356.00 1357.50 10116.00 1357.50

    Axis Y for Open,High,Low,ExtraLine,Close, extraLine2 are the same
    for barChar i add secondary axis and
    The main problem is that when I adding ExtraLine and ExtraLine2 to main axis stock chart is replaced with min-max chart...
    Everything have to be on one chart

  2. #2
    Valued Forum Contributor
    Join Date
    02-09-2006
    Location
    Melbourne, Australia
    MS-Off Ver
    Office 2016
    Posts
    1,075

    Re: stock chart with extra series

    Please attach a copy of your workbook to help others find a solution. Remember to remove/replace any sensitive info before uploading the file.
    Trish in Oz
    -------------
    A problem well defined is a puzzle half solved


    If you attach a sample of your workbook it will be easier to find a solution. Remember to remove/replace sensitive data before uploading the file. Look here if you need help with attachments:
    http://www.excelforum.com/faq.php?fa...b3_attachments

+ 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. Stock charts - adding extra data series
    By alexisjohansen in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 08-24-2014, 12:24 PM
  2. Replies: 0
    Last Post: 11-01-2012, 11:34 AM
  3. [SOLVED] Excel Stock Chart - "Close marker" refers to incorrect data series
    By MartinShort in forum Excel Charting & Pivots
    Replies: 5
    Last Post: 10-07-2012, 10:50 AM
  4. Stock-type chart with 5 data series
    By josh83 in forum Excel General
    Replies: 2
    Last Post: 01-07-2011, 12:40 AM
  5. Writing a macro for stock chart with scroll and 4-6 additional series
    By mayur553 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 09-30-2010, 07:47 AM
  6. Adding series to stock chart in 2007
    By rhudgins in forum Excel General
    Replies: 3
    Last Post: 05-25-2010, 02:03 PM
  7. Stock charts - adding extra data series
    By steven723 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-04-2008, 05:58 PM

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