+ Reply to Thread
Results 1 to 5 of 5

Redo graph from image

  1. #1
    Registered User
    Join Date
    04-24-2015
    Location
    Manila, Philippines
    MS-Off Ver
    2016
    Posts
    6

    Redo graph from image

    Picture2.png

    Any ideas how to redo this graph image? I know it's a stacked area graph. But how can you make it behave like an xy scatter plot (ladder-type)?

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,827

    Re: Redo graph from image

    By making sure that you use dates (or days since starting ART) for the x axis data so that you can use a date axis for the horizontal axis. I would expect a data layout something like:
    days since starting ART -- series 1 -- series 2 --...
    0 -- 1 -- 0 --...
    10 -- .99 -- .01 --...
    ...
    800 -- .5 -- .2 --...
    and so on[/code]

    There will probably be some tinkering around to get used to the date axis options and to tinker around until you get something you like. This may help: https://support.office.com/en-us/art...2-c1d23c96d650

    That should get you started. Let us know what you have trouble with.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Registered User
    Join Date
    04-24-2015
    Location
    Manila, Philippines
    MS-Off Ver
    2016
    Posts
    6

    Re: Redo graph from image

    Hi there. Thanks for your reply. However, I've managed to redo this graph as an xy scatter plot like the photo below. Trying hard to figure out how to fill the areas like the one on the right. Can you help me?
    Picture4.png

  4. #4
    Registered User
    Join Date
    04-24-2015
    Location
    Manila, Philippines
    MS-Off Ver
    2016
    Posts
    6

    Re: Redo graph from image

    Hi there. Thanks for your reply. However, I've managed to redo this graph as an xy scatter plot like the photo below. Trying hard to figure out how to fill the areas like the one on the right. Can you help me?Picture4.png

  5. #5
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,827

    Re: Redo graph from image

    In order to fill the areas below and between the series, you will need to create a stacked area chart to combine with the XY scatter chart (so your attempt to use the XY scatter in order to avoid the stacked area chart has failed). Tutorial here: https://peltiertech.com/fill-under-b...n-excel-chart/

+ 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. Image of Graph Distorted
    By rdespres41 in forum Excel General
    Replies: 3
    Last Post: 10-14-2015, 12:14 PM
  2. Replies: 2
    Last Post: 07-24-2013, 11:42 AM
  3. Replies: 0
    Last Post: 05-23-2008, 09:49 PM
  4. Unod/Redo
    By tofer11 in forum Excel General
    Replies: 13
    Last Post: 05-03-2007, 09:04 PM
  5. graph in image
    By Zygan in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-04-2007, 06:19 PM
  6. how to make a CMYK image from an Excel graph
    By Michel in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-16-2005, 11:44 AM
  7. How to create a CMYK colour image from an Excel graph?
    By Michel in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-16-2005, 08:54 AM

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