+ Reply to Thread
Results 1 to 6 of 6

How to recreate this chart in excel?

  1. #1
    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

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,399

    Re: How to recreate this chart in excel?

    cluster column chart with 3 series. Overlap set to 100.
    Cheers
    Andy
    www.andypope.info

  3. #3
    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

  4. #4
    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

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,399

    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

  6. #6
    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 to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1