How can I change the order that the series appear in the legend k.
I know it is possible to move the series within a legend key in an excel
chart into an order that you require as I have done this before but I can't
remember how! Any help would be appreciated.
To change the legend order you need to change the data series order.
Select a data series and press CTRL+1 to display the format dialog.
There should be a Series Order tab with a listbox of data series.
> I know it is possible to move the series within a legend key in an excel
> chart into an order that you require as I have done this before but I can...freeserve have changed my outlook
Since I joined Freeserve, they've changed Outlook so that it has their In
and Out box and Bin etc. How do I remove this?
Tommy Glassford <firstname.lastname@example.org> wrote:
> Since I joined Freeserve, they've changed Outlook so that it has
> their In and Out box and Bin etc. How do I remove this?
...Charting changes in altitude
I am involved as an administrator of an adventure race.
The event is 388km (242 miles)in length and I wish to
produce a chart showing the changes in altitude that take
place over the course.
Any ideas on how to achieve this?
Put the distance in one column, the corresponding altitude in the
adjacent column, and create a XY Scatter chart with the resulting data.
Business solutions leveraging technology
Microsoft Most Valuable Professional (MVP) 2000-2004
In article <1d4eb01c42368$cbb4c810$a501280a@phx...Win CE 6.0 and Bluetooth
i tried to enable the Bluetooth function on a Windows Embedded CE 6.0 R2 (i.
MX-based device). For connecting an USB-BT dongle I activated these SYSGENs:
I also tried to additionally add the SYSGEN_BTH, but this seems to make no
After a clean SYSGEN I copied the image to the CE-system, started the system,
put the USB-dongle (Anycom USB-500 or Delock EDR) in the port and oppend the
BT-manager and pressed 'scan'. There were some BT devices found. So the
'basics' of the BT connection should work. But if i...Help filling in form from 2 different tables
I have two tables, CustomerData and EmployeeData. CustomerData has all the
address, phn, name, empid# of last employee to help em and custid (primary
key) and employeedata has name addr phn and empid (primarykey) I have a combo
box that pulls up custdata (by Custid sorting by Lastname & ", " & Firstname)
I wanna do an Afterupdate event to fill out the following textboxes (based on
the Custid it fills out the Lastname, Firstname, Address, Phnnumber) and then
based on the Empid of the last Employee that helped em it will fill out the
textboxes witht he first and last na...Problems calculating a converted html table to Excel XP (2002)
I have a generated report off the web that must be converted into Excel. When the report comes up initially it is in a .asp format. I save the report off the web in HTML format. Then open excel, then go to file -> open and browse for the file that I just saved.
The report opens fine with all data showing up as is. However when I try to go and calculate a column of numbers, the answer that I get is 0. So if I go and add up say this list of numbers which is : 5, 7, and 8. The sum should be 20. Instead I get 0 everytime. I have tried to format the cells to be numbers instead of gen...Attachments #9
I have recently purchased several new systems running XP
Professional and have found that now emails
containing .exe attachments are being blocked because
potential virus problems. My company sends programs to
end users all the time how can I avoid this problem?
>I have recently purchased several new systems running XP
>Professional and have found that now emails
>containing .exe attachments are being blocked because
>potential virus problems. My company sends programs to
>end users all the time how can I avoid this problem?
>....Outlook 2003 & CRM 3.0 connection error after install.
I am having trouble getting Outlook to connect to my crm server using the
laptop installation version. When opening Outlook, I get the error "There is
a problem communicating with the Microsoft CRM Server." I have tried
uninstall and then reinstall but no luck. Does anyone have any suggestions
on getting this issue resolved?
I have found that if you have any kind of pop-up blocker, the Outlook client
will throw an error like that (after waiting for a long time). In my case,
I disabled the built-in pop-up blocker that comes with XPsp2 and then it was
fine. To ch...Pivot Tables and Charts
Is there a way to make a table and then when i change the chart have it to
where it does not turn around and change the table
Create another pivot table, based on the first one. Then, create the
pivot chart from the second pivot table. You can hide the sheet that
contains the second pivot table.
When you change the pivot chart, only the hidden pivot table will be
> Is there a way to make a table and then when i change the chart have it to
> where it does not turn around and change the table
http://www.contextures.com/tipte...Mouse pointer changes to hourglass shape
I've just put up the trial version of visio. Very frequently, when stuffing
around trying to get a connection line organized the way I want it, the
mouse pointer changes to an hourglass shape. I can continue to use it
(treating the middle of the hourglass as the tip of the pointer) but it's
very irritating. I can clear it back to the standard arrowhead pointer by
right-clicking, but that brings up the context menu, which I then have to
My system is a fully-updated Windows 2000 Professional. Graphics card is a
Matrox G550 with the latest driver.
Any ...Change color of the border..
There are some components as the combobox that doesn't give option to change
the color of the border, there is some form of making it
consider an examle of data and a pivot table like in the page of famous jon:
http://peltiertech.com/Excel/Pivots/pivottables.htm, namely the most left
table in the third row.
I want to report all product that have sales above 8000. Other product i do
not want to see in the table.
I know how to report 3 best products but it is not i need.
...CRM 3.0 & SQL 2005 Database Mirroring
Could anyone settle this.
Can CRM 3.0 make use of SQL Database Mirroring as a high availability
I believe that this is only possible with CRM 4.0 but a colleague assures me
that it will work with CRM 3.0?
...table not getting updated
I have a form with info derived from a query. It opens from another form
with default data in some of the fields.
While trying to save information programmably, i can not get this to happen.
The only time that I can get the info to update in a table is when I
actually change one of the default values.
Can anyone help we determine a method to use to force the action of data
moving to the table?
> I have a form with info derived from a query. It opens from another
> form with default data in some of the fields.
> While trying to save information programmabl...GP Dynamics 9 and Windows 2003 Service Pack 2
If we install Windows 2003 service pack 2, would this interfer with our
current version of GP Dynamics 9.0?
Should be no problem, we have customers running it with GP 9.0.
Dynamics GP MVP
Flexible Solutions, Inc.
"Chris" <Chris@discussions.microsoft.com> wrote in message
> If we install Windows 2003 service pack 2, would this interfer with our
> current version of GP Dynamics 9.0?
thank you for quick response.... much appreciated!
"Victoria [MVP]" wrote:
...possible to change field code color?
Operating System: Mac OS X 10.6 (Snow Leopard)
It's currently set to medium/dark gray and I'd like to change it to something less visually jarring... light gray would even do it. <br><br>Of course I know that the field codes will not print / they're only for on-screen use... but 99% of the time, I work with my docs on screen. <br><br>Thanks!
I don't know of any way to change the color of the Field Shading, but in
Word> Preferences> View you can select an option to either not have them
Shaded or to have them S...How do I change the contact information I gave when I registered?
I have a new email address - How can I change my email address that i gave
when i registered publisher?
...How can I allow users to sort a protected table using dropdowns?
I'm trying to create a table where users can't edit the content of the cells
but can edit the ordering of the table- what's the best way to achieve this?
I've written this code some time back for one of my users and it works
perfectly for them. Maybe you would like to adapt to suit your needs..
ActiveSheet.Unprotect 'Unprotect the sheet
Range("A1:F100").Sort Key1:=Range("B1"), _ 'where "B1" will be the sort
Order1:=xlAscending, Header:=xlGuess, _
OrderCustom:=1, MatchCase...How to change transaction date?
I'm using Money 2003 Deluxe and Business. I use online bill payment through
my bank. There is a recurring rental payment each month. It is processed
on the 20th for a due payment on the 25th. Money will see it and enter it
into my Money account as an electronically cleared item. Sometimes the
item will clear so that I have two rent payments occuring in the same month.
This skews my expense report because the next month has no rental payment.
I'd like to see one rent payment each month for budgeting purposes.
Right now, I'm subtracting one of the rental payments manually to g...Macro #9
Each Month I receive a CD with an excel spreadsheet( call it Input
Spreadsheet). Each row contains certain fields that I need to use to build a
spreadsheet( call it Load Spreadsheet) that I will use to import/export
into Access. However, there is a different number of rows each month. For
example one month may have 500 records/rows and the next month may have 600
When I create a Macro I turn on the recorder and make the moves of columns
from input spreadsheet to load spreadsheet. However the next month may have
more or less records/rows and the macro does not work. It moves the
i...End of table
I have several workbooks that were created by someone else. They all
have one characteristic that I would like to change.
When I create a worksheet, the Ctrl-End key combination jumps to the
bottom of the table -- the lower right cell. If my table has 200 rows
and 10 columns, Ctrl-End will jump to J200.
In these worksheets, Ctlr-End jumps several hundred, and in some cases
several thousand, rows beyond the last data cell.
I have tried deleting the rows below the last data cell and deleting
the cell contents, which appear empty.
How can I find out why it is doing this and correct it?
how can i make a #DIV/0! message either hide, or appear as a 0.00 or
something else that would look better in a spreadsheet?
...Dynamics GP 9.0
When you install Dynamics GP 9.0 from the CD, in the Insallation Type window
you will see Server Option or Client Option.
The first option should technically say "Server & Client", not just Server.
Needless to say, when you Install Server, it installs Client as well.
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...Date and Time Table Modified
I have 4 forms used by managers to enter data. When they enter data, the data
is saved in tables. I would like to include a date and time stamp so that I
know when they entered each piece of new data. Do I need to have a field in
my table to collect the date and time? How do I collect that in my form?
Yes, you need to add a field to your table.
In the form's BeforeUpdate event, put code to update that field. Assuming
that you named the field LastUpdated and that you included the field in the
form's RecordSource, the code would look something like:
Private Sub Form_Bef...Help with Populating StringMap table
I have a user request that I'm sure is made with some frequency, so I'd like
to see if anyone lse has solved a similar probelm, and/or if my solution
My users requested that we replace the State/Province text box with a State
drop-down list. Since this textbox appears in several places, and since the
tools for populating and maintaining picklist are poor (to be generous), I
decided to look into automating the process.
I created a stagin database for just such things, with a mirror stringmap
table. Through a query, I can populate the CRM stringmap table quite easily,