Plotting A Function Without Values In Cells
Sep 6, 2008
Is there a way to plot a function, for example y = a + x*b or y = e^x in a graph without it having x and y values in cells of the spreadsheet?
That is, in y = a + x*b, for example, what I'd like to do is have an input cell for a and b, but no cells that show a value of y for every corresponding value of x , and a graph on a chart showing what the function looks like. Thus, the graph would only rely on inputs of a and b and on nothing else. A program called MathCAD does this, but I'm not sure how to do this in excel.
View 14 Replies
ADVERTISEMENT
Jun 12, 2014
I'm trying to make a scatter plot from two columns of data; the first, a series of decimals between 0 and 1, the second, a series of percentages between -40 and 140%. Essentially, I'm charting a performance (%) vs. a 'batting average' (decimal between 0 and 1).
However, when I plot these data points, the x-values the chart takes are, I suppose, the relative position of the data within the column (i.e., 5, 9, 32) as opposed to the actual values (.33, .71, .92, etc). I've tried manually selecting the data, copying only the values into different cells...nothing seems to work. Each time, I get points like (11, 61%) instead of the desired (.48, 61%).
View 2 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
Nov 19, 2006
Say I have a line graph pic in jpeg. Can I plot the critical points (by clicking) on the line graph plot, so as to be able to get the (x,y) data, and thus, have all the data points to be able to re-produce the charts in XLS?
Basically, in other words, I would like to reproduce the line graph in XLS.
Or has anyone developed this kind of application, or can anyone redirect me to the right direction?
View 9 Replies
View Related
Dec 7, 2007
I want to do almost exactly this, but when I assign null using "", and plot the result on a graph, the graph thinks that cell is populated with a 0. Let me try to be a bit clearer. I have a range of dates in Col A, and percentages in B and C, but my last 3 dates in Col A have empty cells in B. Cols B and C are separate series. The line graph is (correctly) plotting series C, and series B, whose line stops where there is no more data.
What I need to do now is replace those empty cells with a formula like the one above. Ie, IF(ISBLANK(x1),<null>, <formula>), but using IF(ISBLANK(x1),"", <formula>) doesn't make the line on my graph stop.
View 3 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
Mar 25, 2014
Excel Version : MS Excel 2010
Attachment filename : <Forum to plot the values.xls>
My requirement is i want to plot the values V1, V2, V3 and V4 from the given condition (A1 / A2 / A3 / A4) and the given date.
If the given date is not available then the formula should take the older date than it not next date. For example if the given date is 10-Mar-14 and the date is not available for the given condition then it should take the older / earlier dates like 09-Mar-14 or 08-Mar-14 like and it should not take 11-Mar-14, 12-Mar-14.
The values should be plotted in the yellow cells.
View 1 Replies
View Related
Jul 14, 2014
Plotting of bar and line graphs given an arrays of x and y values in VBA? I want to plot the rDateRange and rOEERange.
Code:
Dim rInitialDate As Range, rFinalDate As Range, rDateRange As Range, Calculation As Worksheet
With Worksheets("Calculation")
Set rInitialDate = .UsedRange.Find(What:=DateValue(InitialDate), After:=.Cells(1, 4), LookIn:=xlFormulas, LookAt:=xlWhole, SearchDirection:=xlNext, SearchFormat:=False)
[Code] .........
View 2 Replies
View Related
Jan 21, 2014
I have some data that I'm plotting on a bar chart and I'm trying to "HIDE" the columns with zero or null values. Basically, if the column is blank, I don't want a "gap" on the chart. I'm not getting this to work.
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
Dec 12, 2006
i am creaing a chart in excell but i have a problem. i would like to have a chart like this one http://shrani.si/?screenshotow31.jpg. but when i create my chart it looks like this http://shrani.si/?screenshotow2t.jpg. first chart is created with some macro so i dont know how is it working but i think the problem is in blank cells because if cell is blank the chart line will go to 0 but i dont whant that :s
View 2 Replies
View Related
Nov 15, 2010
This was so easy to do in excel 2003...However im now using 2010 and i cant figure out how to tell excel to ignore the empty cells for a scatter plot.
View 3 Replies
View Related
Oct 11, 2011
I'm currently working on a test matrix that has high level and mid level test cases. The High level results cell is tracking all mid level test cases below it. If all mid level test cases are displayed as "Pass" then the High level test cases displays "PASS". If any of the mid level test cases is not displayed as "PASS" then the High level test case result is displayed as "FAIL" However, "PASS" and "FAIL" do not accurately represent the status of the test cases in the instance of them not being filled out. Mid Level test cases start off in the "Select Result" state which basically says it that test has not been performed. I would like to have a third value displayed as "NOT COMPLETED" or "IN PROGRESS". Below is the current formula that I am using.
=IF(AND(C50="Pass",C51="Pass", C52="Pass", C53="Pass", C54="Pass", C55="Pass", C56="Pass"),"PASS","FAIL")
On thing to keep in mind that may or may not make a difference is that one of the High level test cases has 30 mid level test cases and from my understanding, IF / AND function only allows up to 30 logic inputs (not sure if that is the correct terminology or correct at all).
View 8 Replies
View Related
Jun 20, 2006
I am trying to write a formula that will look at an array (containing text strings) and then for each occurrence of a particular value return the text string from another cell in another column but which matches the row of the occurring value. I would prefer all returned values to be entered into different cells in a column but I would be happy if they were all in one cell separated by a comma or whatever.
View 7 Replies
View Related
Nov 21, 2006
i m given 12 max value of my 292 cells. now im asked to find number of cells that falls within each of these max values?? im asked t use histogram. how will i do it?
View 3 Replies
View Related
Apr 30, 2014
I am trying to find some missing values compared to 6 base values. For instance, I have a sheet with some names translated to another language, I am trying to find the languages some names have not been translated too.
For example, if I have six languages, Arabic, Japanese, Russian, Chinese-Simplified, Chinese- Traditional, and Korean to compare too, I want to find any names that are not translated in certain languages.
Sample:
John Japanese
John Chinese - Simplified
John Korean
Martin Arabic
Martin Chinese - Simplified
Martin Russian
Ramon Arabic
Ramon Russian
Sam Arabic
Sam Chinese- Traditional
View 1 Replies
View Related
May 13, 2008
how do I plot the axis data in my graph in an increasing order, when I have my datas in a random order?
In other words, I have bunch of data to be plotted as my x-axis. All numbers are within [0;1], but they all in a random order, like (0.001, 0.923, 0.120, ...). And I want them to be in an increasing order.
View 9 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
Aug 6, 2008
i have this set of data (d.jpg). each cell is 2ms.
I want to compute how much is spent on each set (shown as one color) until the sate changes. In other word, the values are voltages, so i want to know how often the voltage toggles. then plot the toggling instances.
View 14 Replies
View Related
Mar 27, 2014
I have a set of data containing "N/A" in some cells, and when I try to plot the chart using stacked lines chart type, the chart is completely off. if the "N/A" are causing this problem and how to fix this.
View 5 Replies
View Related
Jan 25, 2014
I have a data for sedimentation along a pipe. I measured sediment concentrations at different lengths of the pipe, after different intervals of time. So I have 35 concentration values, take at 5 different points along the pipe, at 7 different times. Is it possible to plot a chart with these 35 points, with depth on y-axis, time on x-axis? These 35 points are percent removals (0-100). .
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 4, 2007
I have the following data in excel (just an example):
X | Y1 | Y2
-3 | 9 | 1
-2 | 4 |
-1 | 1 | 1.5
0 | 0 |
1 | 1 | 1.5
2 | 4 |
3 | 9 | 1
I want to play Y1 and Y2 against X. Y2 does not appear on the chart because it's not continuous. I would like to plot Y1 (as a continuous graph) and a Y2 as dots (or scattered as excel lables it).
View 4 Replies
View Related
Mar 21, 2008
My chart with dynamic ranges still plots empty ranges despite using the following for empty cells:
Use of NA()
Use of #NA
Use of ""
Use of 0
What else am I missing?
View 9 Replies
View Related
Feb 24, 2009
I want to calculate various quantities from a set of data and I also want to plot the same data. When I have empty cells in the y-value range, but a value in the x-value range, I do not want these to be plotted, however, unless I insert a #N/A into the empty cell, excel plots them, even if you uncheck the option under Tools->Options->Chart, I guess because there is still an x-value.
I wanted to be able to post an example worksheet, but I'm not allowed to post attachments. Basically as I need to do a lot of these plots for different data sets, I don't want to individually have to tailor each one to account for the empty cells. The only solution I have found so far is to have one column that has blank cells, on which I use functions like Slope() and Intercept(), then I have another cell that has the formula
=IF(D36="",#N/A,D36)
this column is then used as the y-values to plot from, as this prevents excel from plotting them (if I were to use the #N/A column in the functions, I would just get #N/A returned). I then hide the column with #N/As in and allow the chart to plot from hidden columns. This seems ridiculously complicated for such a simple requirement,
View 9 Replies
View Related
Mar 23, 2007
if and/or how an hypercube surface can be plotted?
View 5 Replies
View Related
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
Jan 17, 2014
I have 3 different series: S, J, and D. Each series has a list of different dates, and I need to plot the results for each date, while comparing the 3 series. I have created 3 different charts to display the results for each series - list of dates. However, I'd really like to chart all 3 series on one chart, so that you can see how the 3 compare.
I believe my obstacle is that the list of dates are not consistent between the 3. I tried to get around this by creating one table with all the dates, and leaving blanks where necessary (on Sheet 2). However, this created a problem because the blanks showed on the charts as 0s.
View 5 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
