+ Reply to Thread
Results 1 to 6 of 6

I'm trying to create a min/max chart with values for width and length.

  1. #1
    Registered User
    Join Date
    04-12-2018
    Location
    United Snakes
    MS-Off Ver
    2016
    Posts
    4

    I'm trying to create a min/max chart with values for width and length.

    I'd like to recreate this graph with new data.

    Capture.PNG

    Thanks for your help.

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

    Re: I'm trying to create a min/max chart with values for width and length.

    It will be important to identify which elements of your picture are essential to the chart you create and which are not. Basically, your picture looks like a standard XY Scatter chart with 5 data series and custom error bars.

    Basics of creating a scatter chart: https://support.office.com/en-us/art...5-104a9018b86e
    Adding data series to an existing chart (in your case, I expect it will be easier to use the Select Data Source dialog to add the additional series): https://support.office.com/en-US/Art...f-79983125df12
    Adding error bars: https://support.office.com/en-us/art...5-864049a145f0

    Those help files should walk you through the steps for recreating the major elements of your picture. What part or steps do you have difficulty understanding or following?
    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-12-2018
    Location
    United Snakes
    MS-Off Ver
    2016
    Posts
    4

    Re: I'm trying to create a min/max chart with values for width and length.

    I'm having trouble getting the X-axis to use the same unit of measurement as the Y-axis. This is an example data set I've been using.

    Length Width
    Min Max Min Max
    Sample 1 300 400 201 301
    Sample 2 350 450 251 351

  4. #4
    Registered User
    Join Date
    04-12-2018
    Location
    United Snakes
    MS-Off Ver
    2016
    Posts
    4

    Re: I'm trying to create a min/max chart with values for width and length.

    These show that same data set along with the graph I keep ending up with.

    Capture2.PNG

    Capture4.PNG
    Attached Images Attached Images
    Last edited by p00d00p; 04-23-2018 at 11:41 PM.

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

    Re: I'm trying to create a min/max chart with values for width and length.

    It is difficult to work with a picture. A sample file would help us help you better.

    Assuming the upper left corner of the picture of your spreadsheet is A1, it looks like you selected A2:E5, inserted the scatter chart, and let Excel do the rest. Excel chose to use row 2 as the X axis values, and rows 3, 4, and 5 as the Y axis values. Because the text in row 2 has no numeric meaning, Excel used count numbers (1,2,3,...) for the X values. So you have a scatter chart, but the data are not arranged in a way that Excel can identify the X and Y values on its own. The first picture is exactly what I would expect up to this stage for the pictured table. For the second picture, it looks like you sorted the data in descending order.

    The next step would be to bring up the "select data dialog" (help file again: https://support.office.com/en-US/Art...f-79983125df12 ) and edit/add/remove data series as needed so that Excel will use the desired values for X and Y values for each data series (colored center point). It is not clear to me what you want to use for the X and Y values. Your data are labeled as "max" and "min", so I would guess that these values represent the ends of the error bars. In that case, your pictured tables do not include the "center" x and y values for the main data marker for each point. Since I can't tell what values should be used, I can't comment on how best to do this.

    Once you have the appropriate x and y values identified and paired up in appropriate data series, then you will need to calculate the length of the error bars. I would expect this should be simple subtraction formulas subtracting the given min and max values from the "center" values for that point (probably need an ABS() function to force these to positive values). These differences will be used to tell Excel how long each error bar should be.



    If I may, I would suggest that there is a better way to arrange the data in the spreadsheet, that will make this easier. Something like:
    Please Login or Register  to view this content.
    Note how I combined all of the X values into a single column, with each data series/color in its own column (I only typed out three data series/colors, expand as needed). Note also the columns for the X and Y errors that would be used for the error bars. I don't know if you want to rearrange your data like this. I think this will make creating the chart a lot easier, but it is up to you.

  6. #6
    Registered User
    Join Date
    04-12-2018
    Location
    United Snakes
    MS-Off Ver
    2016
    Posts
    4

    Re: I'm trying to create a min/max chart with values for width and length.

    Thanks for all your help, I finally got it to work.

    Capture7.PNG

+ 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: 1
    Last Post: 10-22-2015, 08:55 AM
  2. [SOLVED] Formatting Width and Length of Shapes
    By Heva in forum Excel Formulas & Functions
    Replies: 9
    Last Post: 09-15-2013, 11:53 AM
  3. [SOLVED] How to Create Chart type Length and time as attach in excel 2007
    By jamril in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 02-20-2013, 03:48 AM
  4. [SOLVED] Length and width from four columns to one
    By Christopher Lynch in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 02-19-2013, 07:30 PM
  5. How to autoformat cell length/width to your data set?
    By cmf0106 in forum Excel General
    Replies: 1
    Last Post: 10-22-2009, 04:01 PM
  6. How to autoformat cell length/width to your data set?
    By cmf0106 in forum Excel General
    Replies: 1
    Last Post: 10-22-2009, 02:56 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