+ Reply to Thread
Results 1 to 3 of 3

A Type of Stock Chart

  1. #1
    Registered User
    Join Date
    03-22-2016
    Location
    Ireland
    MS-Off Ver
    2010
    Posts
    18

    A Type of Stock Chart

    Hello all,
    This may be straightforward but I'm missing something!

    I have a test where I take a count. I use that number to lookup an expected upper and lower range applicable for that number and that day. Then later I do a second count and I expect, in most cases, that the second count will also be within the limits that I found from the lookup of the first count. Sometimes count 1 will be higher than count 2 and vice versa but the same limits will be applied based on count 1. Also there may be times when count 2 is outside the upper or lower limit from the lookup but that's OK.

    I've found an example of what I was trying to get (attached) and thought it was a version of a stock chart but that keeps advising me that the results need to be in a specific order to graph and with my process I can't guarantee a set order every time that so it doesn't seem to be working for me. (Obviously the data in the attached doesn't match with the example chart that I found but the principle that I want to apply is the same)
    Attached Files Attached Files

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

    Re: A Type of Stock Chart

    I'm not sure what you tried, but I used a basic line chart for this.

    1) Select B1:G1 (ctrl) B3:G4
    2) Insert a regular Line chart
    3) Select each data series -> format data series -> No line -> Choose the "horizontal bar" marker from the list of built in markers -> size of marker set at 10 points. Color of marker as desired (I used the default blue for series 1 and red for series 2).
    4) Select series 1 -> Add error bars with the custom value option -> Select B7:G7 for the positive error bar value and B8:G8 for the negative error bar value.
    5) Return to the spreadsheet and enter the formula to calculate the length of the error bars. B7 =B2-B3. B8 =B3-B5. Copy across.
    6) Any other formatting you want to apply.

    That should be pretty close to the picture you show in the file.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    03-22-2016
    Location
    Ireland
    MS-Off Ver
    2010
    Posts
    18

    Re: A Type of Stock Chart

    Thanks shg.
    No wonder I was having problems, I never would have looked at this type of chart as a line type. It makes sense now that the stock type wouldn't work for me. I used your reply and everything is looking good.
    Thanks

+ 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] Overlay Moving Average on Stock Chart Type Starting with First Bar
    By lbroxterman in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-24-2019, 03:33 PM
  2. Have stock chart update stock and clear itself
    By Normonious in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 09-01-2017, 11:49 AM
  3. Stock Chart combined Dow Jones Stock Chart ?
    By HerryMarkowitz in forum Excel Charting & Pivots
    Replies: 17
    Last Post: 10-14-2014, 07:30 AM
  4. Replies: 3
    Last Post: 01-02-2014, 07:56 AM
  5. Stock-type chart with 5 data series
    By josh83 in forum Excel General
    Replies: 2
    Last Post: 01-07-2011, 12:40 AM
  6. Replies: 6
    Last Post: 06-04-2010, 11:55 AM
  7. [SOLVED] Adding a line Chart Type to a stacked-clustered Chart Type
    By Debbie in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-05-2005, 08:06 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