+ Reply to Thread
Results 1 to 3 of 3

Issues with plotting values: creating a few series, X-axis values are not stored

  1. #1
    Forum Contributor
    Join Date
    05-20-2017
    Location
    Boston, US
    MS-Off Ver
    Mac 2011
    Posts
    139

    Issues with plotting values: creating a few series, X-axis values are not stored

    Hello!

    I have two questions.

    First question.
    I am trying to replicate the graph, which in the yellowish box, and shows 3 scenarios - worst, base, best. When I try to create series based on the same table "Scratch work for chart", I get bizarre results:

    (1) when I add new series, say, worst case, I put the name in the name box, then select correct values for Y and X axis (just like they did in the yellowish box);
    (2) then I add a second one, base case, select X and Y values for this series, just like in the yellowish box, but then immediately X-axis values I added in the previous step for the worst case change to the new set of X-axis values I set in this second step;
    (3) same happens when I add the best case - now X-axis values for all series are set to this new set of X-axis values.

    Why does this happen? What is my mistake, and how can I plot these series to replicate the original graph? Please, see the Excel file attached, and a screen shot. My graphing attempt is below the correct one - you will see it; looks rather bad.

    Second question.

    How did they "draw" this nice green circle with the number one in it, and three arrows coming out of it? It seems that these are outside pictures attached, is it correct? Is it possible to do the same using Excel tools?

    Thank you very much!
    Attached Images Attached Images
    Attached Files Attached Files

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

    Re: Issues with plotting values: creating a few series, X-axis values are not stored

    I tend to use XY scatter charts (with a value X axis) in my work rather than column/line/etc (with a category/text axis), so I am not as experienced with these column charts. However, what I have seen when I have used them -- Excel does not like a different category X axis range for each data series (like it does so easily for scatter charts). What I have found that works best for column charts (and others with a category axis) is to have a single range/column for all of the x axis data. To get different series, use separate columns (with appropriate blank cells) for the y axis data:
    Please Login or Register  to view this content.
    The first column of this range is then used as the category x axis range for all of the data series, and each column is used for the values range.
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

  3. #3
    Forum Contributor
    Join Date
    05-20-2017
    Location
    Boston, US
    MS-Off Ver
    Mac 2011
    Posts
    139

    Re: Issues with plotting values: creating a few series, X-axis values are not stored

    Quote Originally Posted by MrShorty View Post
    I tend to use XY scatter charts (with a value X axis) in my work rather than column/line/etc (with a category/text axis), so I am not as experienced with these column charts. However, what I have seen when I have used them -- Excel does not like a different category X axis range for each data series (like it does so easily for scatter charts). What I have found that works best for column charts (and others with a category axis) is to have a single range/column for all of the x axis data. To get different series, use separate columns (with appropriate blank cells) for the y axis data:
    Please Login or Register  to view this content.
    The first column of this range is then used as the category x axis range for all of the data series, and each column is used for the values range.
    I am truly sorry, but you lost me here. I don't understand what I have to do because I don't understand what you mean, and I don't understand the code part.

+ 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: 07-30-2015, 01:58 PM
  2. Replies: 3
    Last Post: 04-14-2015, 04:21 PM
  3. [SOLVED] Plotting graph with 2 data series(Trouble with y-axis values)
    By mtg90 in forum Excel Charting & Pivots
    Replies: 8
    Last Post: 09-05-2012, 07:24 AM
  4. Plotting: Offsetting series with same x axis values
    By x12179x in forum Excel General
    Replies: 1
    Last Post: 09-10-2011, 07:19 AM
  5. Replies: 1
    Last Post: 02-25-2011, 06:27 AM
  6. Ignore plotting a series if all y-values are NA()
    By michaelbails in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 05-20-2010, 02:33 PM
  7. Plotting values in order on x-axis
    By YYM in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 04-10-2008, 10:41 AM

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