making boxplot in excel 2007

Hey. Got a problem on making a boxplot in excel 2007.
I used to make excel 2003 to make the boxplot, but now I have the 2007 
edition.
I learned from my teacher that I need to use the "High-Low-lines" and the 
"Up/down-bars" to make the boxplot.
The problem is that when I made the "Up/down-bars" it will cover the 
data-points so I can't see median ect.
Is there anyway to change the order of the chart-figures like to show the 
data-point at the top, the up/down-bars in the middle and the high-low-lines 
at the bottom just like when u change the order of several objectives?

Sorry my english! Want to show u guys what I mean but don't know a place 
where I can place pics of the screenshot
0
4/24/2007 11:22:02 PM
excel.charting 18370 articles. 0 followers. Follow

2 Replies
2055 Views

Similar Articles

[PageSpeed] 51

It is not possible to change the arrangement of shapes comprising a chart, 
other than what is possible by changing the series order. Excel 2007 seems 
to have put the up-down bars in front of series markers, unlike Excel 2003 
on back to the dawn of time, or at least back to the first version of Excel 
with charts.

An unsatisfactory way to address the hidden markers is to remove the fill 
from the up-down bars, so the markers under the bars are visible. Another is 
to revert to 2003 for any chart-sensitive applications.

You could also construct the box and whisker plot using stacked columns, as 
I do in this example and in the related utility:

http://peltiertech.com/Excel/Charts/BoxWhisker.html

I was pleased when I tested the utility in Excel 2007 and it worked without 
any adjustments. (At least the vertically aligned one; there is something 
possibly amiss about the horizontally aligned chart.)

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______



"matethemouse" <matethemouse@discussions.microsoft.com> wrote in message 
news:DF6F60CB-FD5E-4413-8C04-66255A185BC4@microsoft.com...
> Hey. Got a problem on making a boxplot in excel 2007.
> I used to make excel 2003 to make the boxplot, but now I have the 2007
> edition.
> I learned from my teacher that I need to use the "High-Low-lines" and the
> "Up/down-bars" to make the boxplot.
> The problem is that when I made the "Up/down-bars" it will cover the
> data-points so I can't see median ect.
> Is there anyway to change the order of the chart-figures like to show the
> data-point at the top, the up/down-bars in the middle and the 
> high-low-lines
> at the bottom just like when u change the order of several objectives?
>
> Sorry my english! Want to show u guys what I mean but don't know a place
> where I can place pics of the screenshot 


0
jonxlmvpNO (4558)
4/25/2007 1:19:28 AM
And what's more bizarre... If the chart is made in Excel 2007, it comes out 
wrong, with the markers hidden behind the bars. If the chart is made in an 
earlier version of Excel, the markers remain in view in front of the bars, 
even when the workbook is saved in Excel 2007 format, closed, and reopened. 
So somehow Excel knows something about the version or history of the chart.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Jon Peltier" <jonxlmvpNO@SPAMpeltiertech.com> wrote in message 
news:%23rgipfthHHA.1312@TK2MSFTNGP03.phx.gbl...
> It is not possible to change the arrangement of shapes comprising a chart, 
> other than what is possible by changing the series order. Excel 2007 seems 
> to have put the up-down bars in front of series markers, unlike Excel 2003 
> on back to the dawn of time, or at least back to the first version of 
> Excel with charts.
>
> An unsatisfactory way to address the hidden markers is to remove the fill 
> from the up-down bars, so the markers under the bars are visible. Another 
> is to revert to 2003 for any chart-sensitive applications.
>
> You could also construct the box and whisker plot using stacked columns, 
> as I do in this example and in the related utility:
>
> http://peltiertech.com/Excel/Charts/BoxWhisker.html
>
> I was pleased when I tested the utility in Excel 2007 and it worked 
> without any adjustments. (At least the vertically aligned one; there is 
> something possibly amiss about the horizontally aligned chart.)
>
> - Jon
> -------
> Jon Peltier, Microsoft Excel MVP
> Tutorials and Custom Solutions
> http://PeltierTech.com
> _______
>
>
>
> "matethemouse" <matethemouse@discussions.microsoft.com> wrote in message 
> news:DF6F60CB-FD5E-4413-8C04-66255A185BC4@microsoft.com...
>> Hey. Got a problem on making a boxplot in excel 2007.
>> I used to make excel 2003 to make the boxplot, but now I have the 2007
>> edition.
>> I learned from my teacher that I need to use the "High-Low-lines" and the
>> "Up/down-bars" to make the boxplot.
>> The problem is that when I made the "Up/down-bars" it will cover the
>> data-points so I can't see median ect.
>> Is there anyway to change the order of the chart-figures like to show the
>> data-point at the top, the up/down-bars in the middle and the 
>> high-low-lines
>> at the bottom just like when u change the order of several objectives?
>>
>> Sorry my english! Want to show u guys what I mean but don't know a place
>> where I can place pics of the screenshot
>
> 


0
jonxlmvpNO (4558)
4/25/2007 1:29:35 AM
Reply:

Similar Artilces:

Excel on website
Hi, I have an Excel file which opens maximum at my desk, but it opens minimum when I view it on my company's intranet. I use FrontPage 03 and Excel 07. Please advice! Thanks Chi After moving the file to server and linked it to the page I got it! Thanks Chi "Chi" wrote: > Hi, > > I have an Excel file which opens maximum at my desk, but it opens minimum > when I view it on my company's intranet. I use FrontPage 03 and Excel 07. > > Please advice! > > Thanks > Chi > > > > > > Aft...

Sum
Hi, I just found this "feature" at Excel formulas today. Please, have a look at: http://danielgudang.multiply.com/journal/item/192 (in portuguese, but images show all) Let me explain: some cell C1 = sum (C2:C5) some cell D1 = sum (D2:D5) some cell E1 = sum (E2:E5) A1 = C1 - D1 - E1 B1 = C1 - (D1 + E1) A1 = B1 ??? Oh, not always! Sometimes A1 will be +0, sometimes -0. Really strange! It's a feature of any application that uses IEEE double precision floating point math (e.g., every commercial spreadsheet I know of). It's the result of having finite precision ...

Macro or Function to make text size to suite text Length?
I would like to find Macro or Function that will make text size to suite text Length? eg. if the first cell has "bill smith" then the text size would be 10. But if you had "Christina Vandermear" then the text size would be as small as 7 in order to fit in that same size cell. I know it's a bit of an odd request, but is there a way to do that? thanks Hi only possible with VBA. You may download the following addin for this extension of the conditional format (as Excel's build in format can't change the font size): http://www.xldynamic.com/source/xld.CF...

Online form ~ I have word 2003 and 2007
Hello, I am trying to create an online form that will allow for a limited amount of characters per field. For example: Name: 20 Characters at length and so on Date: 15 Characters Title of the reading: 40 characters Please advise, Thanks -- astro44 ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader an...

Embedded Excel worksheet in PowerPoint
I'm working with an embedded excel worksheet in powerponit. The doc is sent to me and if I have to edit the worksheet, I find that some cells have missing characters once I open the worksheet to edit it. It appears that characters beyond some length (256?) are being truncated off. How do I resolve this so I don't have this problem again? Thanks, Barb Reinhardt This kind of problem may occur if the material was inserted into the embedded worksheet via copy/paste from an external sheet. A reliable approach is to open the embedded sheet first, and from that sheet do: File ...

Excel 2003 01-27-10
Hi all, hopefully you can help me. In cell B21 the user will always input an email address, i have created a button and now need the button to automatically email the email address in cell B21. I then need it to default and save to a specific location with the file name automatically generated from b12. Please help. :) ...

Purge data based on another Excel file???
I am attempting to purge data from a large list based on data in another document. I have the files I want to remaove in on file and the file I want to remove them from. There should be simple way to do this no? ...

OWA 2007 Performance issues
I have been using Exchange 07 for a couple of weeks now and really like it. But, I'm having performance issues with OWA from the outside world. Internally, OWA is lightining fast, but from the outside, it is as slow as a dog. So I don't think it is the server that is causing this, but rather my bandwith to the outside world. Has anyone else experienced this? Does anyone have an idea how much bandwidth is needed for OWA to perform well? OWA 2003 was much faster than 07 and I'm wondering if I made a mistake upgrading. Thanks. Jay Becker "Jay Becker" <JayBe...

Office 2007 Professional: Help Files Issues
Gents, I cannot find a solution to this odd issue and before I submit a support ticket I thought I would ask the community. We have office 2007 professional (volume licensing) on a Window 2003 terminal server. We have a few users out of a bunch that get the "This page is unavailable" I have tried the Refresh and back. I've tried online and offline modes. In offline I get the table of contents to the left but same unavailable message when I click the links. I noticed on testing some other users, that apparently never used the help. That there are some prompts...

EXCEL 2007
I have a GIS application which uses .dbf files (not sure if they are actually Dbase files). When I need to append data (fields) to the files, I have a big problem in that excel 2007 no longer allows save as / export to .dbf files. If I try bring the data in MS Access and save as .dbf files, I have untold problems with the GIS application... The only way I have been successful with this is to find a user with an older version of excel, insert the data as database columns and then save as .dbf Any suggestions as to how I can get around this with out purchasing a converter? ...

in Excel: How do I change "selected cells" highlight color?
When I select cells in Excel the shading is so light (blue) that I can barely tell which cells are selected from those that are not. Can I change the background color of cells that are selected? Thanks. Assuming Excel 2007 this is a known problem and as yet no patch for it. I don't have Excel 2007 but I have read that playing with your Contrast can help some. Gord Dibben MS Excel MVP On Tue, 10 Jun 2008 12:51:00 -0700, flameretired <flameretired@discussions.microsoft.com> wrote: >When I select cells in Excel the shading is so light (blue) that I can barely >tell whic...

How to make A1 the active cell in all visible worksheets ?
This is a multi-part message in MIME format. ------=_NextPart_000_0028_01CA8164.76257740 Content-Type: text/plain; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable ......so that when i activate the sheet A1 is the cell in the upper left = corner of my screen. Thanx ------=_NextPart_000_0028_01CA8164.76257740 Content-Type: text/html; charset="iso-8859-1" Content-Transfer-Encoding: quoted-printable <!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN"> <HTML><HEAD> <META content=3D"text/html; ...

email from excel workbook button does nothing
In my old version of excel(2003) as long as i had outlook open i could email directly from the worksheet. Now i have office 2007 with "windows mail" when i press the button in the "quick access" tool bar it does nothing. I have tried having widows mail open when I do it too but the only way i can send is by making file attachments. seems like the long way around. Is there something I am doing wrong? I have tried to read some of the previous posts and dont understand anything about codes ect. Please help, Mark hi Mark Is Windows Mail your default m...

Delete duplicate rows from a list in Excel
Hi, Below are instructions on how to "delete duplicate rows from a list in Excel". I learned about this tip from the Microsoft Office Assistant website. However, each time I try step 4, my list is not filtered and no records are hidden. Is there a secret I am missing to make this work? Thanks for your help! -Greg http://office.microsoft.com/en-us/assistance/HA010346261033.aspx Applies to Microsoft Office Excel 2003 Microsoft Excel 2002 A duplicate row (also called a record) in a list is one where all values in the row are an exact match of all the values in another row. To delet...

How to tell Excel to insert cells and shift down from Access
Hi all, I have Access 2003. I am trying to tell Excel to insert cells and shift cells down from Access, with this line of code: oWksh.Cells.Insert Shift:=xlDown But Access does not like that line. It gave me run-time error 1004. I know if has to do with the part Shift:=xlDown Can you suggestion what I can do? Thank you in advance, Ben "Ben" <Ben@NoSpam.com> wrote in message news:eSZuzcDpKHA.1892@TK2MSFTNGP02.phx.gbl... > Hi all, > > I have Access 2003. I am trying to tell Excel to insert cells and shift > cells down from Access,...

Text Wrap in Excel 2002
I have been having difficultly wrapping text. I merge several cells and wrap text sucessfully. However, if I go into one of the cells and add a couple of sentences and enter, my text that was wrapped perfectly is simply a string of #########'s and I can't view the text correctly by changing the row height or reformatting (even though it is all still there - as I can see in the edit box - when my cursor is on the text box). Any suggestions? Try formatting the cell as General. bdean wrote: > > I have been having difficultly wrapping text. I merge > several cells an...

Excel Version When Posting Please State Your Excel Version!!!
On Jan 8, 6:58=A0pm, "Tyro" <T...@hotmail.com> wrote: > Subject: Excel Version When Posting Please State Your > Excel Version!!! And Please Include Your Questions and Comments In the Body of Your Posting!!! Not just in the subject line, even if it simply duplicates the subject line. Some news readers truncate the subject line. Some news servers do not permit you to reply to articles with empty bodies. Some news servers seem to reject such articles when they come in from the network, or perhaps the originating news server does not push them into the network. That ...

Outlook 2007 Coplor Printing
Can I print my calendar in color and if so how? it should print in the colors you see on screen but there is a problem with some printers and the shading outlook uses. Try the calendar printing assistant. It and other printing tools are linked at http://slipstick.me/calprint "BC" <BC@discussions.microsoft.com> wrote in message news:BA594246-0FCD-46BC-AFE6-7637FE564822@microsoft.com... > Can I print my calendar in color and if so how? ...

Excel Formulas
I have a spreadsheet showing whether customers have paid their debts or not. Each row represents a customer and details of the debt and the last cell in the row states whether the debt is "PAID" OR "UNPAID". Where the word "PAID" appears in a cell, I want to write a formula that will move that whole row to a different location on my sheet. I eventually want to record this action on a MACRO, so that every time I run a MACRO on my accounts spreadsheet it will take the updated information of customers marked "paid" and put in a seperate spreadsheet. Ple...

Microdoft Publisher 2007 trial on Vista
Hi Just downloaded the trial Publishwer 2007 version onto my HP Pavillion notebook pc and cannot find it! I have got a validation code but no programme to insert it in. Have tried searchin gfor the programme but can't see it anywhere. Any clues? Many thanks Jayney ...

How to retrieve old occurrences in MS 2007 Outlook
I logged migrain info and am going to my 6 month check up tomorrow. I just went to get my old migraine journals that I had put into Outlook and noticed that all my headache journals that are from before November are GONE! In fact, almost all occurrences are gone (it seems "all day" occurrences or "recurring" occurrences are intact). How can I retrieve these old recurrences? Thanks. Are you syncing with a blackberry or other smartphone? Do you have a backup of your pst? If the items are not in your deleted items folder, you'll need a backup to get them ba...

Copy/Paste Excel Macro
Hello, What I'm trying to do is automate a process using an excel macro. What I need the macro to do is to look for a blank cell in a range of data in Column A, and whenever there is a blank space within that range, paste some specific above information into this row. (I'm formatting an excel file after taking it from another program). I would greatly appreciate any help! Thank you! You could record a macro to filter on blank in coloum A then paste a formula +cell above- this would then fill in your blanks -- Thanks for your help "Justin" wrote: >...

How do I print excel doc from an email
I dont have excell but I received an excell document by email. I am trying to find a way to print the doc. Is this possible? Thanks for any help. Get the free Excel viewer http://www.microsoft.com/downloads/details.aspx?FamilyID=c8378bf4-996c-4569-b547-75edbd03aaf0&displaylang=EN -- Regards Ron de Bruin http://www.rondebruin.nl "kevinb" <kevinb@discussions.microsoft.com> wrote in message news:BB654C4D-8AB3-4D98-89C7-49DA1BDE0C42@microsoft.com... >I dont have excell but I received an excell document by email. I am trying to > find a way to print the doc. Is this ...

EXCEL Cell Formatting: Custom or Conditional
At work I have Excel 2002 and I have some cells that I import data in from the mainframe. I have a table where there is a column for GENDER (MALE or FEMALE) that I would like to see shown as "Male" or "Female" (mixed case). Is there a way to change all upper case to mixed case using either CUSTOM formatting or CONDITIONAL formatting? I would prefer not using a macro if there is something simpler. I know that =PROPER() produces the correct result, but I don't see how I can use this unless I'm referencing another cell. I would like to be able to just change what fa...

Access 2007 Runtime on Machine With Older Version?
A client of mine likes some of the new bells and whistles in Access 2007, and is thinking about converting our A03 format MDB to an A07 format file. However, while some of the users have A07, many do not, and it's not clear when they would get it. His thought was to use the upcoming Access 2007 runtime to allow the users who are still running Office 2003 to be able to run the database. While I use multiple versions of Access on my development machine, I advised him against this, as I recall from years ago with the Access 97 runtime that it caused problems when run on a machine that...