+ Reply to Thread
Results 1 to 3 of 3

Stock-type chart with 5 data series

  1. #1
    Registered User
    Join Date
    01-06-2011
    Location
    Toronto, Canada
    MS-Off Ver
    Excel 2003
    Posts
    1

    Stock-type chart with 5 data series

    Hi,

    For my job I was asked to create a chart showing a loss tolerance range, expressed in basis points, with next year's expected loss rate plotted as a point within the range. Until today I was able to do this using the stock chart (high-low-close), with high and low representing either ends of the loss tolerance range, and "close" representing next year's planned losses.

    Today I was asked to add the last two years' actual loss rates to the range as well, and I can't for the life of me figure out how to do this without manually dropping an auto shape on the range to approximate where it would be.

    Is it possible to accomplish what I'm trying to do?

    I quickly drew up what the final product should look like in Paint, which you can find attached.

    Any help with this would be hugely appreciated! Thanks in advance!
    Attached Files Attached Files

  2. #2
    Administrator 6StringJazzer's Avatar
    Join Date
    01-27-2010
    Location
    Tysons Corner, VA, USA
    MS-Off Ver
    MS365 Family 64-bit
    Posts
    24,532

    Re: Stock-type chart with 5 data series

    I was not able to figure out a way to show multiple series groups on a hi-lo-close chart. There may yet be a way if Andy Pope comes to have a look. However, a workaround is to make one chart for each year then overlay them. For the ones to go on the top layers, set chart area and plot area to "no fill" and set Axis Labels to None. See attached for an example.

    BTW your rendering in Word looks more like an open-hi-lo-close.
    Jeff
    | | |會 |會 |會 |會 | |:| | |會 |會
    Read the rules
    Use code tags to [code]enclose your code![/code]

  3. #3
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,164

    Re: Stock-type chart with 5 data series

    It seems the question is - is this type of chart possible....

    Another resource might be http://peltiertech.com/Excel/Charts/stock.html

    I always wonder if the newer versions of Excel (2010) make more charts possible?
    Read http://blogs.msdn.com/b/excel/archiv...xcel-2010.aspx
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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