+ Reply to Thread
Results 1 to 4 of 4

Changing Scatter Data Series to Area Data Series

Hybrid View

  1. #1
    Forum Contributor
    Join Date
    10-25-2010
    Location
    Phoenix, Arizona, USA
    MS-Off Ver
    O365
    Posts
    202

    Changing Scatter Data Series to Area Data Series

    I have a graph that displays data using the 'scatter' data type.

    I also have data that is assigned the secondary y-axis in 'scatter', but would like to change it to 'area' data type.

    I have attempted to change the style by selecting the series, but cannot find how to change it to 'area'.

    Attached are pictures of my graph and toolbar.
    Attached Images Attached Images

  2. #2
    Forum Contributor
    Join Date
    03-08-2016
    Location
    kuala lumpur malaysia
    MS-Off Ver
    365
    Posts
    100

    Re: Changing Scatter Data Series to Area Data Series

    Hi

    Would you please give the raw data?

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

    Re: Changing Scatter Data Series to Area Data Series

    Select the series and use Chart Tools > Design > Change Chart type.
    Cheers
    Andy
    www.andypope.info

  4. #4
    Forum Contributor
    Join Date
    10-25-2010
    Location
    Phoenix, Arizona, USA
    MS-Off Ver
    O365
    Posts
    202

    Re: Changing Scatter Data Series to Area Data Series

    Thank you Andy Pope, worked 'almost' perfectly.

    See my new post with follow-up question.

+ 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: 4
    Last Post: 06-21-2016, 11:47 AM
  2. Replies: 2
    Last Post: 10-30-2015, 02:56 PM
  3. [SOLVED] Data Labels on Scatter Plot VBA -- Looping through code for each data series
    By johnctholen in forum Excel Programming / VBA / Macros
    Replies: 8
    Last Post: 01-22-2015, 07:29 PM
  4. Replies: 2
    Last Post: 11-11-2013, 05:37 PM
  5. Dynamically add series from unsorted data in XY scatter
    By ctosborne89 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-31-2012, 11:32 AM
  6. Scatter plot, multiple series (data) help!
    By LuckiCharmzXP in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 10-01-2011, 06:33 AM
  7. [SOLVED] Changing colors of series on a xy scatter plot
    By JacksonRJones in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-04-2006, 06:10 PM

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