Scatter Graph X Axis Grouping

Feb 28, 2008

I would like to graph the data shown below using a scatter graph. However, when I use the cart wizard it assigns numerical values to each data point and then plots the data accordingly. How can I get the scatter graph to group the assets with the same ratings together? Note, I don't want to have to assign values to assets with the same rating each time. I have attached the spreadsheet so you an see the problem.

View 5 Replies


ADVERTISEMENT

Category X Axis Labels On Scatter Graph

Apr 4, 2007

I have a set of data which I need to plot both unordered and ranked.

For the unordered (as is) data, a line graph is fine, as it gives the category labels along the x axis.

For the ordered data, i have a row with the ranking in, and then plot an xy scatter graph, so the values increase.

This obviously has the rank numbers along the x axis, not the corresponding category labels.

Is there anyway to force this? I know there are chart labelling add-ins on here, but our IT dept blocks the download.

The attched file is a very small example.

View 7 Replies View Related

Make A Scatter Graph That Will Graph The Attached?

Mar 21, 2014

I would like to make a scatter graph that will graph the attached. The score would be on the Y axis and the birth date would be on the X axis. This is simple to do by itself but what I would like to do in addition to this is to have the top 25% of the scores a single color, the middle 50% of the scores a second color and then the bottom 25% of the scores to be a third color. And if it is possible to have the ID visible when you move your cursor over a given dot in the graph. Currently when I make a scatter graph the X,Y coordinates show when I hoover the cursor over a dot.

View 7 Replies View Related

How To Create Engineering Graph With Two X Axis And Single Y Axis

Dec 10, 2012

I need to create a graph with a 2 x axis and a single y axis. For example:

Pressure ( PSIA) Solubility (mol %) Velocity (m/s)
200 0.024 1
300 0.036 1.2
400 0.041 1.8

I need the two x axis to be pressure and solubility and the y axis to be velocity, with the data being demonstrated by a single plot (I have only managed it with two plots which does not demonstrate solubility's relationship to pressure ).

For example at a pressure of 200 PSIA (lower x-axis) and solubility of 0.024 mol % (upper x-axis) velocity was found to be 1 m/s.

View 1 Replies View Related

Labeling X-axis On X Y Scatter?

Apr 16, 2014

I've got two columns of information plotted against one another in an x,y scatter. I need the x-axis to reflect each of the 42 numbers I've added in the column and not a preset or fixed range of numbers. (I need to see the actual number that I assigned each x-plot point on the x-axis and not on the plot point itself).

View 2 Replies View Related

Change X Axis Of Scatter Chart

Jun 1, 2009

The attached file has a scatter chart in which all of the data is properly displayed except the X axis. How can I get my X axis to reflect the data I have selected?

View 2 Replies View Related

Formatting X Axis On Scatter Plot Chart

Jul 27, 2007

Attached is a chart I am trying to create. So basically, I originally used a line chart but it didn't have the flexibility of the scatter chart, but i am having a very hard time formatting the X axis. First of all - I would like the line in the middle at the 0% point to actually go to the bottom so that the x axis labels aren't in the middle of the graph. Second the x axis labels aren't showing up correctly. They should be quarters: 1Q:02, 2Q:02, 3Q:02, 4Q:02... Finally, how can I show the correlation between these two data points plotted - the R-squared. THANKS!!! Auto Merged Post;I actually was able to figure out most of what I asked. What is remaining: how do I calculate the R-Squared on the chart? Isn't there a way to do it automatically in excel on the chart.

View 3 Replies View Related

Plotting On Scatter Graph

Jul 15, 2009

We have a special testing machine in the lab I work in, and it measures reflectivity from reflective vests etc. A special instrument takes a reflective reading and reports back a X and Y value which is used then as a co-ordinate and gets plotted on a graph.

The machine measures for 8 colours, and takes four readings, so for example the first color will be Flourescent Yellow. and then it produces 4 "X,Y" readings, which get plotted onto a graph, and joins all 4 points to create a box as shown in the link >> Graph with joined plots

This is a small capture of the spreadsheet with the values >> spreadsheet

Basically, I need to know how to take the values in columns X and Y, and then make it plot onto a graph as one point, and then join the four points for that one colour,

end result being the grapgh will have upto 8 boxes on it.

View 7 Replies View Related

Xy Scatter Graph Average Point With (+) Around It

Jun 8, 2014

I am supposed to make an xy scatter graph like the one drawn of paper. The average point need to have a "cross" around it. So far I can just plot the points. I have added the average point as secondary series. I just need to put the "+ sign or cross around" it.

View 1 Replies View Related

Coordinate Lines On Scatter Graph?

Jun 28, 2012

I have the following data points:

A
B

1
X
Y

2
0.18
0.52

[Code] ......

And can create a scatter diagram fine. However, I've been asked if it's possible to show on the graph, for each point a line to it's respective X and Y co-ordinate. For example, for row 4 (in red), on the same scatter graph, I'd like there to be two lines for this point,

Line1 drawn from (0.1, 0) to (0.1, 0.26) and
Line2 drawn from (0,0.26) to (0.1,0.26)

I know it's possible to overlap graphs in Excel, but I can't find how to achieve this with scatter plots

View 3 Replies View Related

How To Plot Scatter Graph With Regression

Nov 20, 2013

Given 100 samples, to calculate: numbers of hours spent on study is dependent on numbers of hours spent on social networking site.

x (social networking site)
y (study)
x^2

xy

6
4
36
16
24

[Code] .......

SUMMARY OUTPUT

SUMMARY OUTPUT

Regression Statistics

Regression Statistics

Multiple R
0.571423290877713

[Code] ....

So, I've got the coefficient of correlation equals to 0.57, how can I plot my scatter graph?

View 1 Replies View Related

Bar Graph With Values On Left Vertical Axis And Percentages On Right Vertical Axis

Jan 19, 2012

how do you create a graph with a field such as vendors on the X-axis, but with dollar values spent on the left side of the y-axis and percentage of total dollars spent on the right side vertical axis?

View 3 Replies View Related

Change All Line Thicknesses In Scatter Graph

Jan 2, 2013

I have an XY scatter with 40 or so different lines displayed.I want to change the thickness of all of the lines. I dont want to have to try and select them individually and change them. Is there any way to do this? Perhaps changing the default thickness of lines for this type of graph?

View 1 Replies View Related

How To Prevent Large Scatter Graph Being Squashed

Apr 1, 2013

I am trying to plot a scattered line graph that contains nearly 4000 points on the y axis. The points represent a day. The x axis is the percentage belonging to that day. The problem that I am having is that the graph looks squashed together and the line is very thick because of this. One of the reasons for this is that a lot of the 4000 points have similar percentages so the line just moves a tiny bit. Is there a way that I can make the graph look more presentable?

The following is a picture of how it looks. You may need to enlarge it to see it properly.

View 5 Replies View Related

Start Scatter Line Data Later In Graph?

Jan 13, 2014

I am reporting on the amount of certificates issued over a period of time. Basically the government stopped released data on the amount of one type of certificate being issued during this period and started releasing data on another type. I am having trouble displaying this other data which starts around half way into the time period. So all the data starts in June 2010... but this other data starts in June 2012.

View 3 Replies View Related

Auto Generate Table For Scatter Graph

Oct 31, 2006

after spending hours searching the forum, I begin to seriously doubt my ability to even formulate a suitable search question. My problem SHOULD be a known one, but I am unable to find any clues. Here we go:

I have made a pretty stright-forward forecasting model. It is used to calculate economics of a coal fuelled power plant (even though that shouldn't matter). The outcome is, among other things, a single number for Profit / MWh in Euros. There are several input data, such as fuel price, price for CO2 emission rights, operational expenditure, capex, etc.

My idea, then, is to lock all in-data parameters except ONE, then let this variable vary incrementally and then produce a new small table with a) the variable data (example: price for CO2 rights ranging from 10 to 50 Euro in 2 euro steps), and b) the resulting net profit in each case. Ideally, I wish to be able to chose which indata to lock and which to vary, i.e. solution need to have certain flexibility.

NB: The calculations are not that simple, i.e. I cannot use a simple formula - I need to use the exising output cell(s) to feed data.

How do I do this?

The outcome should be basically two rows with a suitable number of columns (or the other way around, two columns in X number of rows). The table will then be used to produce illustrative graphs.

I guess I could hard code a table by simply enter data, but heck, that's not the way to use Excel!

View 9 Replies View Related

Grouping In A Graph

Jun 16, 2009

I would like to create a graph where the numbers are grouped in such a way as all numbers between 0 and -1 are shown in one column, all numbers between -1.1 and -2 are shown in the next column, all numbers between -2.1 and 3 are shown in another column etc

The numbers are shown below

11/03/09
-2.5
-3.8
-3.9
-4
-4.1
-4.5
-4.6
-4.9
-5.2
-5.4
-5.4
-5.5.......

View 2 Replies View Related

Calculate Maximum Point On Curve From Xy Scatter Graph

Jan 18, 2008

I have put my values into a XY scatter graph but need to find the maximum point i.e when the gradient is zero. I am using visual basic to obtain my data and draw my graph.

View 7 Replies View Related

VBA Needed To Make Separate XY Scatter Graph For Each Group At A Time And Must Be Unique

Aug 19, 2014

I have 5 different groups for that i have to make XY scatter graphs and my data looks like this

XY
125
13
156
145
134
234
248
260
2102
2105
3125
3148
3198
3298
3245
4386
4369
4234
4465
4898
5902
5907
5345
5234
5209

now i want to make 5 different graphs one per each group. Now i am making them manually in excel but it is taking lot of time to format each graphs to get unique graphs. I am attching sample file and graph for better understanding.

View 3 Replies View Related

VBA Changing Y-Axis Graph?

Apr 8, 2012

I am able to change the X-Axis with:

Code:

ActiveChart.Axes(xlCategory).TicketLables.Orientation = 45

How I change the Y-Axis?

View 1 Replies View Related

How To Add Secondary Axis For A Graph

Apr 24, 2012

I am trying to add a secondary axis for a graph but it is not displaying as it normally does, instead of the columns remaining side by side they overlap. I don't normally have any issue with this so I'm not sure what I'm doing wrong. I've attached images to show what i mean.

Before I add secondary axis

After adding secondary axis

View 1 Replies View Related

Graph With Multiple Value Axis

May 3, 2008

how can i make a graph "like a line graph"
to have multiple value axis's?

View 9 Replies View Related

Plotting Graph With Text On X Axis

Mar 27, 2014

There is probably a really simple solution to this, but I have a column 'A' of data, with various numbers, and a column of data 'B' with letters from A to Z. However when I try and plot this on a scatter graph, the x axis uses numbers rather than letters, with data points all over the place?? I'd like the X axis to have the letters A to Z, and the data to stack up vertically when there is a few different numbers correpdoing to 1 letter. Specifically, a scatter graph

View 3 Replies View Related

Reverse Graph Axis Text?

Dec 17, 2013

On my graph the bottem axis shows 1-30, I'd like to change this to 30-1 as I track change over the last 30 days. I tried selecting reverse axis but it reverse's the data as well. Is it possible to change the axis text only, eg latest entry will be one and the 30 day old data will be 30.

View 2 Replies View Related

Bar Graph With Two Seperate X Axis Labels

Jan 31, 2010

Hey guys, been searching around for a while now, yet to find an answer to this.

I have 3 columns of data ......

View 9 Replies View Related

Third Axis Data - Line Graph

Apr 24, 2007

I have a line graph that contains information for the following products,

Boats , Cars & Bikes.

The chart works well but i would like to show the numbered scale of each product & i can't work out if this is possible in excel.

Currently i can only get two data showing for the axis.

I would like to show all three & just use a color to indicate which data corresponds to which product.

In my attached example: I have data for both Cars (blue) & Bikes (green) but i would like to also show data for the graph scaling for Boats (pink).

View 4 Replies View Related

Graphing With Proportional Intervals On X-axis Line Graph

Aug 14, 2014

I'm simply trying to graph my data on a line graph in Excel. see the attached.

The issue is that the spacing on the x-axis is all equivalent. I want the space between the initial and 1st month to be very small while the space between 6 month and 12 month be larger.

So at the end of the day, the line will be kind of crunched down from the beginning and goes up at the 6 month data point.

Is Excel capable of handling such simple request?

View 3 Replies View Related

How To Show Vertical Axis On Both Right And Left Side Of Graph

Nov 22, 2011

Is there a way to show the Vertical axis on both right and left side of the graph or at least on the Right hand side?

View 5 Replies View Related

Sorting Horizontal Bar Graph With Y Axis In Alphabetical Order

Feb 28, 2012

I need to sort a horizontal bar graph, with the Y Axis in alphabetical order.

View 6 Replies View Related

Format Simple Graph Y Axis Of Pivot Chart?

Nov 19, 2013

I have a pivot chart which has one Axis field (Cell Ref2) and one Sum of Values field (which is a table series of percentages calculated from formulas)

I see the graph like I'd expect, but I'm struggling to get it to show percentages rather than basic integer units on the y-axis? Usually I would imagine to just right click on the y-axis : Format Axis, and expect to see something to change the display units, but it is only for hundredths thousands etc rather than a percentage ? The units themselves in the table for that value series are in percentages so I don't see why it isnt showing the percentage units in the first place.

View 1 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved