I'd like to recreate this graph with new data.
Capture.PNG
Thanks for your help.
I'd like to recreate this graph with new data.
Capture.PNG
Thanks for your help.
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?
Originally Posted by shg
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
These show that same data set along with the graph I keep ending up with.
Capture2.PNG
Capture4.PNG
Last edited by p00d00p; 04-23-2018 at 11:41 PM.
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: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.Please Login or Register to view this content.
Thanks for all your help, I finally got it to work.
Capture7.PNG
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks