Bland Altman plots


    Sponsored Links


  • 1. Creating a Chart from Cells that use a List Box
    Hi, I am trying to create a number of charts (e.g., pie, line etc) based on data that is slelected from a list box (i.e., data validation). What i would like to do is create the charts before any data is entered (if that makes sense) and as data is entered the charts will display this.
  • 2. Hide data labels with "0" values
    Some of my source data contains cells with "0" values that I don't want to show on my chart. How can I get them to now show up? I need to leave those cells in my source data range as I am working with a spreadsheet that is updated monthly so as to automatically update the chart. -- Karen
  • 3. Chart Relative To Worksheet When Copying- Excel 2007
    I'm looking for a technique to make charts automatically reference data on the current worksheet when I copy a worksheet containing a chart. In Excel 2007, the chart references the cells from the original worksheet while Excel 2003 would automatically update the reference. I can manually key in the new worksheet as the reference but this is tedious. any suggestions?
  • 4. Banded chart with Trend
    I have several sets of data more complicated but similar to below where I'd like to chart the best Dept on the upper line, the worst dept on the lower line, the median in the middle and the trend. I want to expand for additional charts to include monthly totals, the % involving a particular category, locations within each dept etc. but thought I'd start out slow. I've looked at most of the posts and can't find anything exactly as I need. Any help would be greatly appreciated. Thanks. Dept FTE Actual 09 Actual 08 Actual 07 Actual 06 Dept 1 169 10 15 16 18 Dept 2 219 4 5 8 10 Dept 3 196 6 9 6 8 Dept 4 68 0 0 2 0 Dept 5 25 0 0 0 0 Dept 6 1 0 0 0 1 Dept 7 6 0 1 0 0 TOTAL 684 20 30 32 37
  • 5. Connection Lines Between Data Points
    I'm trying to show connecting lines between data points. X axis is in dollars for the days of the week, Y axis is date. I do not have figures for each day for the X axis, so my data points will not connect. Below is an example of my data. Any help is appreciated. Thank you! Date Monday Tuesday Wednesday Thursday 12/1 $1,169 12/2 $521 12/3 $2,321 12/4 12/5 12/6 12/7 $3,317 12/8 $2,791 12/9 $776 12/10 $4,772 12/11 12/12 12/13 12/14 $1,391 12/15 $1,501 12/16 $1,322 12/17 $3,688 12/18 12/19 12/20 12/21 $4,403 12/22 $1,415 12/23 $1,327 12/24 12/25 12/26 12/27 12/28 $1,885 12/29 $1,768 12/30 $376 12/31

Bland Altman plots

Postby SlJE » Sun, 19 Aug 2007 23:30:02 GMT

Does anyone know if there is an add in that creates Bland Altman plots?



Re: Bland Altman plots

Postby 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: 

Re: Bland Altman plots

Postby 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):


For several other Excel solutions for statistics, related info and links,
visit our website at


and follow the link on the left to Software (and scroll down to Excel

Gaj Vidmar, PhD
Univ. of Ljubljana, Fac. of Medicine, Inst. of Biomedical Informatics

Similar Threads:

1.Bland Rows

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?


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
        .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


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?

5.plotting long plots

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

7. Excel gives me line plots - I want scatter plots

8. Scatter plot changes to line plot with data gaps

Return to MS EXCEL


Who is online

Users browsing this forum: No registered users and 72 guest