+ Reply to Thread
Results 1 to 6 of 6

How to recreate this chart in excel?

  1. 11-14-2011, 03:08 AM #1
    bermandl
    bermandl is offline
    Registered User
    Join Date
    10-21-2011
    Location
    Shanghai
    MS-Off Ver
    Excel Mac 2011
    Posts
    16

    How to recreate this chart in excel?

    Dear All,

    I am trying to recreate the attached chart in excel but seem to running across some difficulties. Please help!

    Best,

    DLB
    Attached Images Attached Images
    Reply With QuoteRegister To Reply
  2. 11-14-2011, 04:37 AM #2
    Andy Pope
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,476

    Re: How to recreate this chart in excel?

    cluster column chart with 3 series. Overlap set to 100.
    Cheers
    Andy
    www.andypope.info
    Reply With QuoteRegister To Reply
  3. 11-14-2011, 06:43 AM #3
    bermandl
    bermandl is offline
    Registered User
    Join Date
    10-21-2011
    Location
    Shanghai
    MS-Off Ver
    Excel Mac 2011
    Posts
    16

    Re: How to recreate this chart in excel?

    I don't know why i still can't seem to get it to look the way I want. Please help... This is extremely frustrating.

    Here are the data points:
    Price 43 50 60 63 65 73 80 90 100 120 130
    Mt 0 400 700 750 800 850 950 1000 1050 1100 1150

    PLEASE SEND A EXCEL FILE.

    Thank you
    Reply With QuoteRegister To Reply
  4. 11-14-2011, 06:45 AM #4
    pike
    pike is offline
    Forum Expert pike's Avatar
    Join Date
    12-11-2005
    Location
    Alstonville, Australia
    MS-Off Ver
    2016
    Posts
    5,330

    Re: How to recreate this chart in excel?

    moved to Chart forum
    If the solution helped please donate to RSPCA

    Site worth visiting: Rabbitohs
    Reply With QuoteRegister To Reply
  5. 11-14-2011, 06:51 AM #5
    Andy Pope
    Andy Pope is offline
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,476

    Re: How to recreate this chart in excel?

    You need to use formula to determine which 1 of the 3 series a sepcific data point should populate.

    Overlap=100
    GapWidth=0
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  6. 11-14-2011, 07:05 AM #6
    bermandl
    bermandl is offline
    Registered User
    Join Date
    10-21-2011
    Location
    Shanghai
    MS-Off Ver
    Excel Mac 2011
    Posts
    16

    Re: How to recreate this chart in excel?

    I got it. Cheers
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1