I am attempting to draw a graph and want to put on the graph what the base
level this data will be compared against, ie 100,000 units is the base that
is to be met so if the numbers are showing 56,000 75,000 and 100,000 where
on the chart will the volumes be higher than requested and where are they
Add horizontal line to chart
Bernard V Liengme
Micro...Columns showing up as thin vertical lines
We have a chart that is showing the thin vertical lines for the columns. We
tried resetting the default settings and it changed several things, but not
the columns . . . they remained thin vertical lines.
We have tried changing the gaps and have tried deleting/recreating the
chart. There are several other charts which were created in this file that
are just fine. Oh, and our chart does not preview any different. We have
found that if we remove enough data points the lines ever so slightly widen
to thin columns. This chart is not showing any greater amount of data than
the others i...Can't logon, keeps cycling Logon process
For some reason we can not log on to a Windows XP, sp3 laptop. This machine
should be free of viruses, spyware, etc... as it was scanned extensively last
week. But for some strange reason today it will not allow us to logon either
in regular mode or Safe mode. It will boot to Windows in both modes and
accept the logon credentials, but after accepting those credentials it will
immediately logoff (before Windows loads) and go back to the WinXP Logon
TIA for any help on this one ...
When at the logon screen try:
Ctrl + Alt + Del
This will call up the ...GP printing PM checks to Acuprint using ACL command line
Looking for experience of printing Great Plains PM checks to Acuprint. Have
client that is trying to do this by adding ACL command line in check format
report writer to tell Acuprint which template to use. Anyone successful in
doing this? Thanks.
...Text box set to memo vs. Lines Coded on a report
I have a report which looks like a legal pad with lines. 24 actual spaces.
The number of lines can not change. I have duplicated a form from Excel to
eliminate using it altogether. So it looks just like the Excel Report. I
coded the lines into the report. I am using a text box with data type set to
memo. I have several issues.
1. If the data entered into the textbox from my form fits in to the text box
on one line, then there is no problem. I can just move the page footer to
more or less the right position to allow it to fit inside the coded lines.
(It is not exact, but close...Multiple lines of criteria without repeating header
I'm using the database functions DMAX etc and want to have a variety o
criteria in a column. However I believe the "criteria" range has to b
a minimum of 2 rows with the top row containing headers. If I want t
reference a row of the range of criteria, I am then lacking th
headers. Including the headers would then include all rows of criteri
in between too - creating an undesirable OR condition.
6...keeping outlook open but hidden.
Is there some way instead of minimize to keep outlook open and checking mail
Office xp Small Biz
On Fri, 8 Aug 2003 11:02:45 -0400, "Geek" <firstname.lastname@example.org> wrote:
>Is there some way instead of minimize to keep outlook open and checking mail
I believe this is the best you can do for OL2000 and OL2002:
Don't know what they're up to for OL2003.
"Geek" <email@example.com> wrote in message
n...Watching a macro execute itself line by line.
I need to debug a long macro that I have recorded
I would like to be able to see it execute each instruction or line one by one
I'm totally new to Vba and I would gratefully appreciate step by step instructions
Thanks in advance
Start macro running vrom VB editor with the F8 button or
insert the command STOP at whatever point you wish to step from then
press F8 to step one through each command
~~ Message posted from http://www.ExcelTip.com/
~~View and post usenet messages directly from http://www.ExcelForum.com/
You can size your wor...How do I arch a line of text within a banner?
I am trying to design a banner that will have two lines of text. Rather than
both lines being straight, I would like to arch the top line over the second
line so that I can insert artwork between the two lines of text. Can this be
accomplished with this program? If not, is there a program available the I
could use instead.
> I am trying to design a banner that will have two lines of text.
> Rather than both lines being straight, I would like to arch the top
> line over the second line so that I can insert artwork between the
> two...on a scatter graph, how do i insert a line indicating the mean?
Create corresponding cells that each contain the mean, then "Chart|Add
Data" to add this new data series to the chart.
> as above
...Contract Line Deletion
I have a contract line that is no longer needed, how can I delete it?
...Paste to next free column
Using excel 10.
Row 1 - 5 is free to incert a logo bit map.
A:A contains a list income and expenditure.
Row 6 has month date
Row 7 has Actual & Budget
Row 8 has =A3k.
The main information is in F9:G40 which is the current months
Now comes the problem. I want a button with a macro, to copy F9:G40
and paste it in the next available column, which will be I9:J40. Then
I can re-enter data
in F9:G40, for the new month. Then at month end click button to
transfer data. However
the I:J columns will be used now so I will need a blank column, this
is the issue,
to find macro data to find t...Forecast available on site : http://www.forecastmarket.com, Next Forecasts at midday
BEA SYSTEMS INC MIDDAY 35%
MONSTER WORLDWIDE MIDDAY 20%
SIRIUS SATELLITE R MIDDAY 20%
APPLIED MATERIALS MIDDAY 15%
GEN ELECTRIC CO MIDDAY 15%
DISCOVERY HLDNG A MIDDAY 15%
UNITED TECH MIDDAY 15%
EXPRESS SCRIPTS C MIDDAY 15%
CEPHALON INC MIDDAY 15%
TEVA PHARM INDS AD 10H30 15%
...message routing based on subject line
Our firewall inserts [SPAM] at the beginning of each spam message
subject line. I would like to route those tagged messages to a public
folder. I have not found a way to control message routing based on
subject line. Any assistance would be appreciated.
"Milton" <firstname.lastname@example.org> wrote in message
> Our firewall inserts [SPAM] at the beginning of each spam message
> subject line. I would like to route those tagged messages to a
> folder. I have not found a way to control...Line Weight does not Print correctly
I have a document that I have several data graphics used. I use a callout
circle for my shape and then I like data using the data graphics. I select a
line weight of 9 and all looks great on the screen. But then when I go to
print it, the lines weights on a couple of the data graphics are correct, but
the rest print in what appears to be a line weight 1. Does any one know why
...sub tot column to next blank cell when blank cell exists in both c
I have posted this again to hope that someone will give me further assistance
- I "ticked" the last post because it did work and well, but I realised what
I actually need is slightly different.
I asked for some coding that would search for each blank cell in a column
and subtotal below it until the next blank cell. Stefi gave me this:
> Range("S" & ActiveCell.Row - 1).Activate
> Do While ActiveCell.Row <> Range("S" & Rows.Count).End(xlUp).Row + 1
> ...Windows 7 Keeps chanting date time
I am located in Brazil and set my date/time defaults to Brasilia capital of
When I go and synchronize my clock from the internet, any of the servers
will give me the correct local time, but after a few minutes windows 7 will
change the time to 3 hours before. Yes, always 3 hours exactly. Since my
local time is about 1 hour in front of New York, 3 hours should be somewhere
in US pacific time.
I tried to leave the wrong time for 2 days, but the clock change wasn't
recursive. In other words, once the clock is rolled back, it will remain 3
hour...I keep receiving an email error message 0x800CCC90
It appears that I am still able to send and receive messages in Outlook but I
keep getting this internal error message. My ISP has checked their system and
figures it has something to do with the Outlook program itself.
> It appears that I am still able to send and receive messages in Outlook but I
> keep getting this internal error message. My ISP has checked their system and
> figures it has something to do with the Outlook program itself.
And what might be the FULL and EXACT content of "this" error message? And
what might be your VERSION of ...Entering a date that then gets changed to next weekday Thursday's date, say?
I don't want to make the current sheet I'm working on too complicated, so
prefer not to go the macro route. Was hoping a formula would take care of
If I enter a date via "^;", it would be so nice if the sheet knew to change
the date to the following Thursday's date. i.e., when I type ^; into the
currently empty date cell, it puts today's date of "2006.12.27.Wed" which I
then stop to fix to nearest Thursday. Instead, it would be very helpful if
a formula or something non-macro did that for me and changed it to the
nearest Thursday's date, in...How do I add grid lines to a LONG list with 3 columns?
I am trying to switch from my old PC that used works to this new
Hewlett-Packard that uses Excel. When I downloaded my file of this use list
of library books (Column 1 = Author's last name, Column 2 = authors 1st name,
Column 3 = Book title), it didn't include the grid lines to separate the
columns and the rows (of which there are over 1,000). How do I get it to do
so?....and, how do I get it to keep each row numbered?
I've really tried to find the answer to such a simple question, but it's not
happening. Your help would be appreciated.
You can number each row by addin...Outlook keeps asking for Exchange password
I'm currently evaluating an offer of 1&1. They give me an Exchange account
for free for one month. I've setup everything and my folders have been
But: everytime I start my Outlook 2003 I have to enter my passsword! That's
annoying! A dialog pops up. The username is already in there but I have to
type in my password.
Is there a way around this?
Rene Ruppert <email@example.com> typed:
> I'm currently evaluating an offer of 1&1. They give me an Exchange
> account for free for one month....get value from cell next to that of searched text
I have some tables where there is a veriable in a cell next to searchable
text. So if I search for the desired text and want to take the value of the
cell to the left of it what would that formula look like?
Look in the help index for MATCH and then for INDEX
Microsoft MVP Excel
"SBS user" <firstname.lastname@example.org> wrote in message
>I have some tables where there is a veriable in a cell next to searchable
>text. So if I search for the desired text and want to take t...how to preserve line breaks in the message
Hi, I'm generating email message from my web app using asp.net 2.0 mail
objects. Each line in the message displays certain info and they all lined up
one under another.To achive that in c# I add "\n" to the string to creat a
new line. Resulting message display exactly what I need in yahoo mail but
outlook strips out extra line breaks following its own logic by leaving some
and removing some. The result is a total mess. Ex:
Date: 07/27/2007 - 07/28/2007
Location: Eric P. Newman Education Center (new line is here) Amount Paid($):
980.00 (new line is here)Transaction ID: V78...Problems with ClipARt on line
I am trying to download new Clip Art from Microsoft website. After
doing so, a Clip Art file shows up in my desktop, but not in my
clipart gallery as it was supposed to. I was wondering if this was not
because I didn't install the Active X software they mention. The
proble is where can I find it?
Thank you very much in advance
On 16/08/2007 3:49 pm, in article
> Hello guys.
> I am trying to download new Clip Art from Micros...How to delete/not-add Workstation2 line to Dex.Ini
I have a set file has two location IDs that asks user to select a
location from the drop down list when they launch Great Plains. Once
they make the selection, this name gets updated in Dex.Ini file under
Workstation2 line. I'd always like to have an option when they log in
to GP that they can select the location of the set file. If I delete
the Workstation2 line from the Dex.Ini it again allows me to make the
selection. Is there a way to setup so that it doesn't create that entry
in Dex.Ini file? OR do I have to have VBA running when they exit GP, it
deletes that line from Dex.Ini. An...