Stacked Column Graph
I have data that counts in two separrate ways. How can I put two stacked
columns next to each other on the same graph (X is in days, Y1 is # of
incidents, Y2 is currently an average of days used for a line above the
Have a look at the resources referred to by Jon.
> I have data that counts in two separrate ways. How can I put two stacked
> columns next to each other on the same graph (X is in days, Y1 is # of
> incidents, Y2 is currently an average of days used for a line a...Using TM Interscan as a smart host for outgoing mail
I'm trying to set up my SMTP Gateway for outgoing mail, in addition to
I have configured the gateway as a smart host on my Exchange 2000 box
by going to the properties of my SMTP connector.
Additionally, on Trend Interscan E-mail Virus Wall v3.53 I have allowed
The options are (my config in brackets);
Enable Outgoing Mail processing (ticked)
Specify the IP address of any mail server that will be sending mail to
the InterScan machine (192.168.1.1)
Specify how outgoing mail will be delivered;
Either forward mail to SMTP server or Use DNS (use DNS selec...Can I convert columns to rows?
I need to convert address information, which is on word and listed
vertically, to an excel spreadsheet, and have the information list out
horizontally. Is this possible to do? I am familiar with the basics of each
program, but using "range,formula,value" options in excel confuses me.
Here's an example:
(My data in word)
Mel's Tire Store, Inc.
300 Culbertson Avenue
Worland, WY 82401
Need to copy and paste so data spreads horizontally in Excel, under these
"Business Name" "Address" "City&qu...Windows 7 upgrade of XP Pro with IE 8 and getting Certificate Erro
My PC was recently upgraded from XP Pro with Windows 7 Pro and I also had IE
running on my machine under XP. now when I browse to many sites I am getting
a certificate warning message in IE. I can choose to continue on to the site
(even though it says that is not recommended.). But this is VERY ANNOYING!
Pleas help! I have tried adjusting many different IE settings, and verified
the date-time is correct on my PC. This is happening on valid web sites. So
far not very happy with this upgrade!
Below is the error message I am seeing in IE:
-----------------------------------...which should I use: Outlook or ACCESS?
I'm a long-time ACT user and want to change. With 5,000 contacts I want to
see contacts and their respective histories, todo's, calls, meetings,
attachments, etc.. ... and i'd like to use template to write letters, emails,
I'm using Outlook for my currently over 5'500 contacts. If there's something
I want to write about a contact and there's no such field (like history) I
use the big comment field. If you need to do more things (what Outlook
doesn't support) go with Access. Or you could start with Outlook and later
export the data if you really ne...Excel 2003: How to make transparent columns in Excel chart?
If you create a bar plot froma given dataset you can format the
columns by right clicking and choosing the desired options. In the tab
that opens there is a slider which is supposed tho set the level of
transparency of the column (selceted area). But so far i couldn't find
a way how to use this slider.
I know that there is an alternative way to get transparent bars by
creating a rectangular object formating it and the use copy -> paste.
But i wonder what is the slider for if you can't use it?
Does anybody know have an idea?
...Reset recently used files in Publisher to higher number
I want to set the number of recently used files in Publisher to nine from the
four that it shows me at present. I can't find anywhere to change this. I'm
using Publisher 2003.
I don't think you can do that in Publisher but I'm sure that someone will
chirp up if I'm mistaken.
MVP Microsoft [Publisher]
"Ken" <Ken@discussions.microsoft.com> wrote in message
>I want to set the number of recently used files in Publisher to nine from
> four that it shows me at prese...Free 'absolute beginners' guide for making charts using Excel
If you are want the ABC's of making charts and a new way to look at the
chart-making process, try this free book at http://www.vgupta.com
...data sort is not including all columns in sort
I have a list with name, company, address, city.....etc. When I click on
data sort (i do check the box to include column headings) and do a sort by
say address, it will sometimes exclude a column such as name from the sort.
It does not always do this. Is this a glitch? Do I need to highlight the
entire list before I sort?
Also, sometimes if I just use the Ascending or Descending icon rather that
going to data, sort it will only sort that column and not the rest of the
data with it.
Those are the reasons that I don't trust excel to guess at the range I want
I am tracking the response from suppliers, the status is: "On time" or
[D3Date] is I received the response from suppliers.
=IIf([D3Date] Is Null,IIf(Now()-[issueDate]>1,"Late","
When I issue a ticket, shold be reponse in the following work date, if not
But if I issue on Friday, then the following work date is Monday, then the
expression doesn't work right, how can I avoid the Staturday and Sunday.
...VB.net select column and format
I am using VB.net 2005 with Excel 2003. I need to select a single column
and apply formating to it. Can someone please explain how to do this?
What sort of formatting do you mean? The basic code would be something
Dim RangeToFormat As Excel.Range
Dim WS As Excel.Worksheet
RangeToFormat = DirectCast( _
Worksheets.Item("Sheet1"), Excel.Worksheet). _
WS = RangeToFormat.Worksheet
RangeToFormat = _
RangeToForma...how to protect appointed rows or columns to use the mouse and keyboard
You could include some text in your post.
Maybe then we could figure out what you mean by "appointed"??
"To use the mouse and keyboard" makes absolutely no sense whatsoever.
Maybe you're a new poster???
If so, take a look here before reposting:
Most anything that could be asked in the newsgroups has already been
Take a look here and you may just find what you're looking for (whatever
"hzh" <email@example.com> wrote in message
news:7A2382EE-00E6-4679...Word 2007 how to get data from forms to Excel
I have forms that have been filled out by various people and would like to
export the data into an Excel worksheet. This seemed straightforward in Word
2003, but I cannot get it to work in Word 2007.
The actual form is a Word 2003 document. When I save the file as a txt file
(after Word options / Advanced / Preserve fidelity / check "save form data as
delimited text file") it creates the delimited file, but it gets overwritten
when I close the original filled form.
I am having a similar problem, but the "save form data as delimited
text...why csv fields converted into dates
I have a csv file with fields that look like this
this is being interpreted as a date when i open it in Excel.
what do i need to do with this filed in order to make Excel consider it
I tried replacing the double quotes with a single quote like this:
but that makes the single quote appear in the cell in Excel, which is
not what i want.
> I have a csv file with fields that look like this
> this is being interpreted as a date when i open it in Excel.
Hmm, that...Use Outlook 2000 to retrieve Hotmail email?
Can someone tell me how to Use Outlook 2000 to retrieve
Hotmail email? It keeps asking for a POP3 account info,
when hotmail uses HTTP instead, very frustating. Thanks
I don't think you can do this - you need to use either Outlook Express or
Outlook XP (2002).
"John Luton" <JL112055@yahoo.com> wrote in message
> Can someone tell me how to Use Outlook 2000 to retrieve
> Hotmail email? It keeps asking for a POP3 account info,
> when hotmail uses HTTP instead, very frustating. Thanks
...getting all data about search subject
I have a client that had CRM installed on a server and
migrated their ACT database over to it(i came into this on
the tail end so i didn't set it up)--whenever they do an
account lookup they want to get all the info surrounding
that client--emails, images , past correspondances,
invoices, quotes etc... they want all this in one click so
to speak---in reading these posts two things popped out at
me "searchpac 360" and"only the user can bring up what
they own or produced" since this firm has several
employees on the system all saving and sending info to and
abou...attach an excel workbook using send object method
I am sending emails from Access using SendObject and would like to attach an
Excel workbook to the email. Any suggestions?
SendObject will not work in this case, since it is only designed to send an
object *within* the database (table, query, report, etc.). If you are using
Outlook, you can try the method that I show on page 19 of a Word document
that I call Access Links.doc. You are welcome to download a zipped copy, here:
Microsoft Access MVP
http://www.access.qbuilt.com/htm...Column Sum in Footer
I have created a Tabular report that lists names and weights for different
people. I want to create a stand-alone field in the page footer that will
display the SUM of all the weights on the report. Can somebody please help
me? (I'm using Access 2000 btw)
I have tried creating a text box with the Control Source property set as
"=Sum(weight)". However, this just produces an error.
Thanks in advance.
Julie Smith wrote:
>I have created a Tabular report that lists names and weights for different
>people. I want to create a stand-alone field in the page f...Insert date en time with onchange function
I have a ntext field in a service indenity . When it is edited i want
automaticly insert date en time.
Can anyone help?
In your onChange event for that field, you may add
var currentTime =3D new Date()
var month =3D currentTime.getMonth() + 1
var day =3D currentTime.getDate()
var year =3D currentTime.getFullYear()
crmForm.all.[Your Field].DataValue =3D month + "/" + day + "/" + year;
hope this helps.
Darren Liu, Microso...How to group similar column titles together????
I have an excel spreadsheet with 6 column titles as follows:
1st column title = ob1
2nd column title = ob2
3rd column title = ab1
4th column title = ob3
5th column title = ab2
6th column title = ob4
I have about 200 lines of information on each column. I want to run a macro
/ function on this spreadsheet and my spreadsheet should regroup similar
titles together as follows:
1st column title = ob1
2nd column title = ob2
3rd column title = ob3
4th column title = ob4
5th column title = ab1
6th column title = ab2
Can someone think of any way to do this? (A macro ...Adding using conditional cell
I have a two cells one with a 'number' value and another with a 'text'
i would like to have the number cell add up based on the text value.
1 2 3 4
A 2 S
B 2 S
C 3 SM
So then, because row A and B's text is S they will be added together to
is there a way where i can make a formula or a table to calculate this?
First, sort your data by that second column, so all the S's are grouped
Then add a single header row at the top of your data.
Select that range (all the rows and all the columns you need) and do:...Inventory report that shows how much of an item was used over time
Howdy. Not overly well-versed in how to pull various reports, but we are
looking to find a report that will show us how much of an item was used (in
assemblies) over any given time period. Is this something that is found in
Reports or would it be a Smartlist view. And, how do we get there? Thanks
in advance for any help!
...How do I use auto fill to add information from an existing source?
I am trying to figure out how to use some type of auto fill. What I have to
do is put in a customer name and then I need to have the address, city,
state, zip and phone number automatically fill in. How would I do that?
Assume Sheet2's cols A to F is the existing reference, where col A contains
the names, cols B to F contain the other info, eg: address, city, state, zip
and phone number
you have the names listed in A2 down
Put in B2:
Copy B2 across to F2, fill down as far as required
...julian date #3
Is there a formula or line of code that, in a date cell, would automatically
convert a date entered in the 07/16/04 format into the 04188 julian format?
You can't have a formula in a cell and make an entry in it - the
formula is overwritten. You can use an event macro:
Put this in the worksheet code module (right-click the worksheet tab and
choose View Code):
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
Dim nYear As Long
Dim nDays As Long
If .Count > 1 Then Exit Sub
If Not Intersect(.Cells, Ra...Opening an old Word document, date changed to current date
When I open old Word documents, the date gets automatically changed to the
current date and I can't view the date that the document actually had. I am
using MS Office 2007, but the old document was created in Word 2003. I can
see the date that the file was last modified in the details of the file, but
I cant guarantee that the date of the document is the same as the date last
modified for the file.
Press Alt+F9 to toggle the field code display and edit the DATE field code
to read CREATEDATE. Then Alt+F9 to toggle back and F9 to update. The date
displayed will be the date th...