+ Reply to Thread
Results 1 to 6 of 6

what type of chart is this?

  1. #1
    Registered User
    Join Date
    05-01-2015
    Location
    New Jersey USA
    MS-Off Ver
    MS Office Home and Business 2010
    Posts
    4

    Question what type of chart is this?

    http://www.advisorperspectives.com/d...since-2007.gifSample Chart to Duplicate.pdf

    Can anyone tell me what type of chart this is? I have to duplicate it with data that is currently in a different type of chart....the existing chart has an x axis as a bar chart and a secondary axis as a line chart, and a trend line on the x axis data. I'm unclear how to get that data to look like the attached sample.

    Any help is greatly appreciated.

    Thanks!

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

    Re: what type of chart is this?

    xy-scatter with 2 series. 1 for the dots and 1 for the line.

    shaded area can be done with another series as area or columns
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    05-01-2015
    Location
    New Jersey USA
    MS-Off Ver
    MS Office Home and Business 2010
    Posts
    4

    Re: what type of chart is this?

    Thank you Andy Pope! I've attached the same chart as a scatter - looks funny...is this correct? Should the x asis be the scatter line and then the y axis be a scatter with only markers?

  4. #4
    Registered User
    Join Date
    05-01-2015
    Location
    New Jersey USA
    MS-Off Ver
    MS Office Home and Business 2010
    Posts
    4

    Re: what type of chart is this?

    Thank you Andy Pope! I've attached the same chart as a scatter - looks funny...is this correct? Should the x asis be the scatter line and then the y axis be a scatter with only markers?Sample Chart New.xlsx

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

    Re: what type of chart is this?

    Your x axis data is not a true date, which is why the horizontal axis reads zero to 14.
    Your 2 sets of data are in different units ($ and %), unlike the example picture you posted.
    finally the trend line in the picture is a moving average where as you have a linear one.

  6. #6
    Registered User
    Join Date
    05-01-2015
    Location
    New Jersey USA
    MS-Off Ver
    MS Office Home and Business 2010
    Posts
    4

    Re: what type of chart is this?

    Thank you again Andy, very helpful!

+ 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. Replies: 3
    Last Post: 01-02-2014, 07:56 AM
  2. Replies: 1
    Last Post: 06-14-2011, 09:50 AM
  3. How do I stop Pivot Chart changing chart type by itself?
    By lealea1982 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 04-03-2008, 07:49 AM
  4. Pivot Chart: cannot apply the default chart type...
    By doco in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 01-17-2005, 01:06 PM
  5. [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

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