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
ADVERTISEMENT
Dec 19, 2013
I have a data set that is a spectrum of (y)intensity vs (x)energy I was wanting to add an additional X axis at the top of the graph showing the wavelength conversion for the energy value, is that possible in excel? and if so how?
View 1 Replies
View Related
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
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
Oct 12, 2011
I have a need to present 2 sets of values on the Y ( vertical ) axis but the Scales differ appreciably. I 'd like to know how can I present these so that I can appreciate the changes in both these values.
E.g. X fn of A B ( Y axis )
When I plot X against A & B because B has a HUGE range , variations in A appear minuscule. How can I address this scaling problem so that pictorially I can appreciate both changes in A and B against X.
Is there is Way to Plot A and B on different Y axis like one is on the LHS Y axis and other one on the RHS Y axis .
This is a PIVOT chart using data from another worksheet.
View 1 Replies
View Related
Apr 29, 2014
I am tasked to plot some client satisfaction data on a monthly basis. I want to be able to show the client satisfaction with different aspects of service delivery. Can have a chart with "Good", "Fair", and "Poor" on the vertical axis with months on the horizontal axis?
View 1 Replies
View Related
Dec 11, 2013
how to plot dates which are unequal in interval
the dates that I want to plot are the following:
1/2/13
1/7/13
1/14/13
1/21/13
1/28/13
2/4/13
2/11/13
2/19/13
2/25/13
3/4/13
3/11/13
3/18/13
3/25/13
I want to appear them exactly on my X axis no different dates in between them.
View 3 Replies
View Related
Jul 12, 2009
I use spectrometer in my reesearch. The datas are in (a, b) format in single cell. Is it possible to seperate a and b seperately? like a in seperate cell and b in seperate cell?
View 4 Replies
View Related
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
Mar 26, 2014
nrel25mar.xls
I have attached Excel sheet as above. I wanted to plot graph time vs pic-zenith,pic-azimuth,pic-elevation .
I tried to plot graph but value of point in excel sheet is differ from table value. For single graph no problem,When all put together leading some problem. What kind of char can plotted above reading values.
View 3 Replies
View Related
Oct 22, 2008
I've two collumns, after some index the values of cells are zero
how i can draw a chart without selecting those zero cells?
View 6 Replies
View Related
Aug 29, 2013
How can i exclude Blank or cells that have a 0 when plotting my graph? Right now everything is very small because i have about 50 cells, some with quantities and some with zero quantities.
View 9 Replies
View Related
Feb 15, 2005
Using Excel 2003. I have a data range for a graph. The values in the cells are the results of a simple If function - If(m28>0,n28,0). The results are taken from a larger data input exercise. But, the graph line (a simple graph!) plots the FALSE value (0) when I would like there to really be no value & hence no plotted point if the result is FALSE.
View 4 Replies
View Related
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
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
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
May 3, 2008
how can i make a graph "like a line graph"
to have multiple value axis's?
View 9 Replies
View Related
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
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
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
View Related
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
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
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
Feb 28, 2012
I need to sort a horizontal bar graph, with the Y Axis in alphabetical order.
View 6 Replies
View Related
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
Apr 10, 2014
If I have data that shows one year back information, how do I get my chart to have the last date showing up on the axis (the date label) to always be the most current date?
View 4 Replies
View Related
Oct 16, 2008
I'm trying to make a line graph with specific increments on both the x and y axis. Now, I can make specific increments on one, but have to sacrifice the other in order for me to label the lines. Im not sure how to get around this. I'll just type out what i'm trying to do and maybe you smart people can help me here.
Okay, both the x and y axis must be in increments of 8,10,12.5,16,20,25,30, and 35.
The first line should be labeled "Indicated magnification, and should have the values 8,10,12.5,16,20,25,30, and 35... the same as the x and y values, making the line a straight linear line.
The second line should say "actual m value" and have values of 10,12.5,15.5,20.5,25,31,37.5, and 44.
The third line should say "actual n value" and have values of 10,13,16,21,26,32,38.5, and 45.
View 9 Replies
View Related
Jun 26, 2014
I have been given a task to create a line graph who has 10 categories and each category has 5 different values. I need to plot a line graph, so that those 10 categories should appear on the Y-axis instead of X-axis.
I am using Excel 2010.
View 8 Replies
View Related
Feb 8, 2009
Two questions:
1) How do make values on x-axis as words? E.g. apples, oranges, etc.
2) Is it possible to have the numbers on x-axis in descending order? If I can figure out 1), I can do this as well, but it would be nice to know if it is possible to have the numbers on x-axis in descending order.
View 8 Replies
View Related
Mar 1, 2014
I have a spreadsheet with golfers handicaps, golfers names down the left in column A in rows 3-35. Row 2 has the event numbers titles 1 to 18 (18 events in a year). i need a graph that has the person as the vert axis and the horizontal axis needs to be the event numbers, so i can read down for the person and across to see how there handicaps change from each different event. i have attached the data below.
View 1 Replies
View Related
