View pareto chart by sorting the max number on the bottom
Is it possible to format the pareto chart by sorting the maximun number show
in the bottom of each bar and ignore sort by Legend item?
The order is determined by the Row Source of the chart.
Microsoft Access MVP
> Is it possible to format the pareto chart by sorting the maximun number show
> in the bottom of each bar and ignore sort by Legend item?
...Sort Order on Order Fulfillment Window
In the sales order fulfillment window you can sort the lines items by Order
Entered or Site/Bin/Item. Does the Site/Bin/Item only sort by Bin if
Multi-bin is used? I am not using multi-bin but have created bin for each
item in each site on the Quantities/Sites window.
...Sales order processing item inquiry windows
Since I have updated to version 10 (from version 9.0) the document are not
showing in any specific order. In version 9 they were sorted by document
For example if you choose "By item number" then include only invoice and
then choose history. You will see that the document are not sorted at all.
Any ideas or suggestions?
Everything scrolling window has a sort order - just maybe not what you
expect. But you can always see it by turning on your dexsql.log and seeing
the query generated.
In this case with your same options marked, i get:
SELECT TOP...Can I set up a calendar lookup for date selection
Is it possible to lookup a calendar for date selection on a cell. I cannot
find any reference to it in the help.
try this url
"Tangoxray" <Tangoxray@discussions.microsoft.com> wrote in message
> Is it possible to lookup a calendar for date selection on a cell. I
> find any reference to it in the help.
...>> Calendar Control drag to select range
Hi, using MS Access 2003, is it possible to allow a user to drag to select a
range of dates and, if 'yes', how do you store the selected date range?
Not that I know of. Storing a range of dates is quite simple though. You
store the start date and the end date and use a calculation to show all the
Arvin Meyer, MCP, MVP
"Jonathan" <Jonathan@discussions.microsoft.com> wrote in message
> ...Sort House Numbers
How can I get excel to sort house numbers as I would like, i.e
1,2,2a,3,4,5,5a,5b, et. etc.
So far I've ailed miserably. Any help out there? TIA
You will have to separate the digits into a separate cell.
Extraction of a Group of Digits and Dashes, from postings by Harlan Grove
Extract the First Set of Digits (#DigitsFirstID)
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvp...Insert Blank Line and Sort
Content-Type: text/plain; charset=iso-8859-15; format=flowed; delsp=yes
Within a worksheet I have an example of data below consisting of four
I need to put a blank line in between the Racecourse (where they change)
and after do a sort on Rating (high to low).
Is it possible?
I could do it with a macro, but am unable to fathom out how to deal with a
differing number of horses at each racecourse.
Time Racecourse Horse Rating
04:30:00 SANDOWN Dare To Dance 0.261
04:30:00 SANDOWN Garud 0.153
04:30:00 SANDOWN Wes...Sorting Issue (Mixde Fields)
I have an issue where I need to sort a worksheet based on a field (Bin
Location)that is sorting as seen below...
How can I get Excel to sort it the following way...
Please help.... I need to get this figured out today.
I appreciate any responses.
One way: add a column showing the length of the column you want to sort, then
sort using the new column then the "real" column.
"Jonathan G." wrote:
> I have an issue where I need to sort a worksheet based on a field (Bin
> Location)that is s...Sorting Stacked Columns
I am trying to sort the columns so that the largest value is on th
bottom each year. This would change the order of the series over eac
year presumably. I have not figured out a way to do this, and fear i
may be VBA related. Any ideas? Thanks.
I attached the file for viewing
Attachment filename: testbook_stackedcols.xls
Download attachment: http://www.excelforum.com/attachment.php?postid=61644
Message posted from http://www.ExcelForum.com
...move selection after enter into cell
Operating System: Mac OS X 10.6 (Snow Leopard)
Upon entering data into a cell, I do not want to move to another cell when I hit Return. In the older version of Excel I used to be able to go into Tools/Options/Edit and uncheck Move Selection after Enter. How can I accomplish this in the 2008 version? thanks
Aha - you've revealed yourself as a Windows user :-) Mac OS has never had
Options, it uses Preferences instead. Go to Excel> Preferences> Edit where
you can specify Up, Down, Left, Right from the list or clear the check to
not have the se...Option to select printer B4 printing Payables Checks
Client recently upgraded from 7.5 to 9.0 and they lost the option to select a
printer after clicking print. From print payables checks In 7.5 when they
would click on print, a window would pop up and give them the option to
select a printer to send their checks to. Now it automatically goes to their
defaulted printer. How do they set up the option in 9.0?
Go to the Named Printers settings, and look at the checkbox to suppress the
printer dialog box. This should solve your problem
"TROOTBMI" <TROOTBMI@discussions.microsoft.com> wrote in message
news:...Large List Sorting
Have a problem. I'm developing an application which reading a large database
file (DBF) and displaying it in the list control. Because of the size of the
file (>15 MB, later it will be increased) I'm using a virtual list (owner
But now I need to sort data in the list. AFAIK to perfirm this I should read
the whole file. In this case my program starts several minutes!!! It doesn't
have to be like this [(C) Pink Floyd]...
Is there any methods to load a large amount of data as quickly as possible?
Or I just should humble, 'cause sorting of large amount of d...formatting selected characters or numbers in each cell within a range of cells
I am sending this to several Excel newsgroups, because I am not sure
which one if the most appropriate. I apologize in advance for the
multiple postings. I have MS Excel 2000 (version 9.0.3821 SR-1). How
can I format only a selected character or number within each cell in a
specific range of cells? For instance if I have a cell containing
�1234234�, how can I format it so that only the 2�s are bold or are
colored? Obviously, I have a range of cells, and I want to format all
the 2�s occurring in any of the cells as either bold or colored.
Conditional formatting does not seem to all...How to sort in Excel with headers link to all body parts
I have a table that have subheaders and each subheader with rows of items
I wanted to sort all subitems from all subheaders according to value (in one
column); and have each subitem link to the subheader as label for that
I guess what I need to do is link a cluster of items to it subheader; so
when I sort each item will include the subheader as label to show what
subheader it came from.
...Select Records that fall in an external set of ranges (subquery)
HiI have not done subqueries before so I am a bit confused. I have twotables1 - Phone Numbers - (converted to be numeric) (with other fields forlater) and2 - Exchange codes - multiple entries for code with 3 fields -Exchange name (duplication) - Start Range and End Range.I want to return a list of phone numbers that fall into the range fora certain exchange.For example - MRSPOO has 4 entries in the Exchange Table with 4distinct ranges. 200-299, 307-788, 997-1102 and 2036-6698. I would like to be able to return all the phone numbers for a singleexchange code that I would select (using a query...Cannot access Outlook on my desk top from my laptop
I have a Roadrunner address with Outlook as my primary, on my desktop. But I
cannot get to my Outlook using a laptop. Note: I can get to Hotmail, my
secondary, using the laptop or another computer. Obivously, the primary is
Can you detail the steps you're taking?
"DCW" <DCW@discussions.microsoft.com> wrote in message
> I have a Roadrunner address with Outlook as my primary, on my desktop.
> cannot get to my Outlook using a laptop. Note: I can get to Hotmail, my
> secondar...Report names in listbox
I recently upgraded to Access 2007 and am having some trouble with the
changes. I have a form with a listbox in which I would like to display the
names of all the reports in the database. I've tried using the following as
the rowsource for the listbox, but in form view nothing is displayed. Does
anyone know how to do this?
WHERE (((Left([Name],1))<"~") AND ((MSysObjects.Type)=-32764))
ORDER BY MSysObjects.Name;"
I think you made a slight typo. Try (((Left([Name],1))<>&quo...Sorting Notes
I use the Outlook Notes program quite a bit. But, there are two problems I
have with it:
1. It sorts most recent to oldest -- is there any way to change the sort
order to alphabetical?
2. I'd like the default "note" size to be a little larger? Is this
I can answer part of this one. To make the note a little larger - Tools,
Options, Note Options, Size.
<EHPorter> wrote in message
> I use the Outlook Notes program quite a bit. But, there are two problems
> have wit...Highlight a selected record
I am trying to highlight a selected record of a continuous form. Conditional
Formatting is not working because it highlights individual fields. If
Conditional Formatting would highlight the entire row, it would be perfect.
I created a txtBackground text box to size of all my fields, sent it the
back—behind the fields. Use the txtBackground as the control, but when it
has focus it covers the data. Below is the code I used:
Sub HighlightControl(ctl As Control)
On Error Resume Next
ctl.BackColor = 65535
Sub UnhighlightControl(ctl As...Suppliers with Top Items List
Can anyone let me know how to show suppliers on Top Item List?
I badly need this. I tried my way but not successful.
Install the RMS Toolkit trial download you requested and check off Custom
Reports/Templates during installation.
Now run Manager, Reports, Custom, Top Items Report. This report includes
Suppliers, Dept, Category, and Sub-Descriptions as columns and filter
There are over 100 free reports and templates included with our RMS Toolkit
Digital Retail Solutions
www.digitalretailer.com/RMSaddins (v1.x and ...Selecting data for charts by criteria
I am in control of a large database of information and I want to be
able to automatically make my charts update to include new data that is
added. I am using a regular excel spreadsheet. I would also like to
be able to select which data is used for a chart depending on a
criteria such as, 0 <= value <= 10.
Any help is appreciated.
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/
If it's an external database, I guess yo..."One or more of the selected senders could not be added to your blocked senders list"
Hey all. I get this when ever I try to killfile anyone at all, regardless of
who they are. I'm on OE6 in XP Home and this has only just started
happening. My KF only has a few spammers in it so I don't think it's full.
Does anyone know what's going on?
Ayatollah of rock 'n' roller wrote:
> Hey all. I get this when ever I try to killfile anyone at all, regardless of
> who they are. I'm on OE6 in XP Home and this has only just started
> happening. My KF only has a few spammers in it so I don't think it's full.
> Does anyone...Sort #2
How do you sort 5 or more columns?
They must be contiguous columns.
Select them all together *before* you choose <Data> <Sort>.
Never, never, never allow XL to choose your sort range for you.
Never, never, never use the sort icons on the tool bar.
Please keep all correspondence within the Group, so all may benefit!
"Jim" <firstname.lastname@example.org> wrote in message
How do you sort 5 or more...Outlook 2003
I have four different accounts setup in Outlook. I know that it is
possible to use a default signature for new messages and replies with
each account. However, when selecting New to start a new message,
naturally, it uses the default mail account and inserts the
However, when changing the sent from account in the Accounts drop
down, one would expect the "default" signature to be used; i.e.
Outlook would delete the signature that it initially inserted and
replace it with the default signature for the selected account.
This is not what happens. Seemingly, ...Saving Selected Cells to a Text File w/o using a VBA script
I am trying to save only a range of cells in a worksheet to a tab-delimited
I have seen entries posted in this discussion group and have implemented a
VBA script (based on some recommnedations posted) that does what I need to do.
But my question is: Is there a way to save only a selected portion of a
worksheet within a workbook to a text file? (i.e., NOT the entire worksheet,
just a selection of cells).
Thanks for any help you can give.
without VBA not possible
"patm" <email@example.com> schrieb im...