Does anyone know if there is an add in that creates Bland Altman plots? Thanks John
Bland Altman plots
3 posts
• Page 1 of 1
- acorn
- windows 64bit
- Windows XP
- Digital Signal Processing
- cad
- Windows XP
- Smartphone
- sharepoint
- Windows
- msdn
Jump to:
Sponsored Links
- 1. Just want a plain graph -- heeeeelp!
I know this is possible because I did it many years ago, but now I can't figure out how for anything. I just have a plain table with 2 columns. One is supposed to be the x axis and one is supposed to be the y axis. But I cannot plot them versus each other! All it wants to do is to make two unrelated lines of each column on its own versus nothing. I don't quite know what good that would do, but whatever. I just want them versus each other. Pleeeeez help, TIA! Julie - 2. Custom chart gallery and range name conflicts
When I create a user-defined chart type, Excel seems to copy lots of range names to the file xlusrgal.xls. Is there a way to stop it doing this because it is triggering lots of problems. It creates a range name conflict when I try to create a new user-defined chart type, unless I run a macro like: Sub deletenames() For Each myname In ActiveWorkbook.Names myname.Delete Next myname End Sub in xlusrgal.xls Is there any way round this? I get this problem using Excel 97 and 2000 (I don't have XP or 2003). (let me know if this question should have been asked to microsoft.public.excel.programming) Thanks Stephen - 3. More help needed re entry on 19/2
Thanks for your earlier advice. I can only seem to get it to work if I use column + line chart combinations. Is there any way I can combine stacked bar + line chart, as my data is better presented in bar format? - 4. More than one vertical axis?
Hello, I am plotting year on the x-axis and trying to plot interest rate of the left vertical axis and dollars on the right vertical axis of a line graph. How do I set up a two (left and right) vertical axis chart? Please let me know, Thanks for your time - 5. help with line graph
i accidently and unknowingly tuned off the line on my line graph, when i try to do the line graph the line isn't there. please help!!!!!!!!!
Next
Bland Altman plots
by SlJE » Sun, 19 Aug 2007 23:30:02 GMT
Re: Bland Altman plots
by James Silverton » Mon, 20 Aug 2007 00:09:45 GMT
JRD wrote on Sat, 18 Aug 2007 07:30:02 -0700: J> Thanks It does not seem that it would be too difficult to set up Excel to do what you want. See the Wikipedia stub on Bland Altman. That's just what I did since I had not realized that Bland and Altman had arrogated the standard Tukey mean-difference plot, as is it is still known as in other fields. James Silverton Potomac, Maryland E-mail, with obvious alterations: not.jim.silverton.at.verizon.not
Re: Bland Altman plots
by Gaj Vidmar » Tue, 21 Aug 2007 19:43:50 GMT
I didn't follow the previous discussion, but here's a ready-made macro solution (from 2004): http://www.**--****.com/ For several other Excel solutions for statistics, related info and links, visit our website at http://www.**--****.com/ and follow the link on the left to Software (and scroll down to Excel workbooks). Regards, Gaj Vidmar, PhD Univ. of Ljubljana, Fac. of Medicine, Inst. of Biomedical Informatics
Similar Threads:
My spreadsheet has 250 rows and A thru AG in columns, all cells are bordered. All of the columns are used if a row is used. My sheet has 15% more rows than our highest use this year so that I am sure our office does not run short of rows (my workbook has 12 of these sheets because we track the info monthly and forward the sheets as filled out to other personel). My question is how do I print the sheets (only one month is printed at a time) to print only the rows that has been filled out, all of the sheet rows are continuous, we have no unused rows except for the ones left at the bottom that are unused. when ever I print the sheets it always prints a few extra pages from the bottom that are just the gridding. I don't want to have to delete all of the unused row before I print the sheet.
2.Eliminating bland from Data Validation list?
Hi,
I looked around other postings but could not find the answer -- what I'm
having a problem with is thta in my data validation list, I have a range set
(which refers to column H) -- the number within the range can change, and I
sort it every time it does change so that there are no spaces between values.
The problem is that there are numerous blanks in the list at bottom, after
the last actual value in the range. Is there any way to get rid of those
blanks? I tried deleting (delete shift up) all blank cells after the last
value and through the last cell (H65536), but this doesn't help. Below is my
code. Thanks!
With .Range("B2").Validation
.Delete
.Add Type:=xlValidateList, AlertStyle:=xlValidAlertStop, Operator:= _
xlBetween, Formula1:="=dvrange"
.IgnoreBlank = True
.InCellDropdown = True
.InputTitle = ""
.ErrorTitle = "Please select value"
.InputMessage = ""
.ErrorMessage = "Please select a value from the drop down menu."
.ShowInput = True
.ShowError = True
End With
--
Robert
3.plots sent to to a chart tab do not show plot & I loss the plot
I have a spreadsheet that has a chart tab with a plot of data from another part of the spreadsheet. Now, however, the chart is empty and when I try to send any plot to a chart tab the plot is lost and the chart tab is empty. This is happening now in all my spreadsheets the plot can be created within a spreadsheet but as soon as I move it to a tab the plot is lost and the chart tab has nothing in it. !!!????!!!!
4.Removing Plot lines between plot points on a line chart
A 2003 file being opened in 2007. Contains a line graph. I wish to remove a plot line between two points. The lines right now or dotted, when I go through the process of entering into the chart options and click on "No plot line" nothing happens and the dotted lines remain. ANy suggestions? Or is this a converting issue going from 2003 to 2007?
I have a HP designjet 110 nr plotter. I've created a plot that we nee to show drilling activity. My first plot was 24"x36". Plot works grea and to scale. My next plot was to be 24"x72". Now the charts will no even display in Print Preview. I can scale back the plot where it i about 48" and it will preview and plot, but I need it to go out eve futher than 72 inches. I may go out as far as 30 feet. I have images on the plot area and it will print it just fine at th farther distances
6. Plotting X axis as the log in a semilog plot
3 posts
• Page 1 of 1
Who is online
Users browsing this forum: No registered users and 91 guest