+ Reply to Thread
Results 1 to 4 of 4

Create spine combo chart challenge. Pic included - can this be done in Excel?

  1. #1
    Registered User
    Join Date
    12-12-2006
    Posts
    17

    Create spine combo chart challenge. Pic included - can this be done in Excel?

    Hi, is it possible to recreate the attached chart (jpg) in Excel - I've been racking my brains for a while on this one.

    Assume I have the percentile figures at 25% and 75%.

    So far I've managed the one in the attached spreadsheet but it doesn't match the pasted pitcure. Basically I used a horizontal chart, reduced gaps and then added a second chart - but it plots it on 2nd vertical axis instead of horizontally (even when changing to scatter plot).

    Many thanks for any suggestions
    Attached Images Attached Images
    Attached Files Attached Files

  2. #2
    Forum Expert Debraj Roy's Avatar
    Join Date
    09-27-2012
    Location
    New Delhi,India
    MS-Off Ver
    Excel 2013
    Posts
    1,469

    Re: Create spine combo chart challenge. Pic included - can this be done in Excel?

    Hi Whitespaces...

    Is this somehow helpful

    http://chandoo.org/wp/2013/02/21/adv...eclines-chart/
    Regards!
    =DEC2HEX(3563)

    If you like someone's answer, click the star to give them a reputation point for that answer...

  3. #3
    Registered User
    Join Date
    12-12-2006
    Posts
    17

    Re: Create spine combo chart challenge. Pic included - can this be done in Excel?

    Thanks Deb, that should sort the first problem out but then I won't be able to plot a circle (or something else) over the top as a second chart to represent the local value?

    Many thanks for your help though.

  4. #4
    Registered User
    Join Date
    12-12-2006
    Posts
    17

    Re: Create spine combo chart challenge. Pic included - can this be done in Excel?

    I've solved this now using bar chart combined with scatter plot. Thanks for your help peeps.

+ 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