Hand entered dates view wrong
A user I support is having an issue with a worksheet in Excel. It is
not an urgent or crucial fix, but I am interested in people's ideas,
since she says it has happened to her before. In each case she threw
away the worksheet and started a new one by hand entering the data again.
Here's the scenario: She has a worksheet in which she has been adding
rows of data over time (6 months or so) and has only about 30 rows of
data. Column A are dates, and are formatted as such.
After months of opening and saving in this document once a week or so,
she now has an issue - when she types...set limit for one year prior
trying to write a query to select occupdate for one year prior to toustartdate
where occupdate < (toustartdate - 365)
where occupdate < (toustartdate - 1 year)
I'm sure it's a simple solution - can someone help me out.
Ian (Ian@discussions.microsoft.com) writes:
> trying to write a query to select occupdate for one year prior to
> where occupdate < (toustartdate - 365)
> where occupdate < (toustartdate - 1 year)
> don't work
These WHERE clauses would return rows where occupdate is one or more bef...charting independent XYScatter graphs
I'm trying to create a XYScatter graph of 3 independent datasets from
within VB6 using OLE/Excel2000.
I'm using the KB147803 article as a basis, but am stuck and hope someone
The example in KB147803 seems to indicate that there can only be one set
of X-Values for the 3 XY Scatter Graph data sets.
The X-Value series is the first row of data in the sheet, and is called
out as a set of Category labels ('cwCategoryLabels=1'), and applies to
all three subsequent rows of Y-Value data.
In my case, I want to plot 3 independent sets of XY data, so I'd like to
pr...Need to set up a slide with 4 text boxes on same page.
Want to end up with 4 "bulleted" boxes that I can to show 4 strategies and
associated task on same page. Also, if possible have each one drop in
individually to allow flow conrol for the presentation
Are you asking a question about how to do that or having trouble with part
If the former, just create four separate text boxes with bulleted text, you
are not limited to only one text box per slide. Use the Custom Animation,
Effects Options, Text Animation settings to control the entrance of the
Since you didn't say what version of PowerPoi...Help with graph / chart
I have a graph for weeks 1-52, I have split this into 4 seperate graphs each
showing a quarter (13 weeks) I cant remember exactly how I created them but
possibly using some sort of copy paste as each chart show weeks 1 - 13 along
the bottom. This should read.........
for chart 1 1-13
for chart 2 14 - 26
chart 3 27 - 40
chart 4 41 - 52
How do I change this on each chart to read the week numbers indicated.?
You need to define the Category labels for the chart.
Chart 1 is fine as it defaults to the values 1 to 13.
For the other 3 charts you will need to create...How do make a line correspond to date
I have a chart with horizontal bars and I want to put a vertical (trend) date
line that corresponds to today's date.
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
"soconfused" <email@example.com> wrote in message
>I have a chart with horizontal bars and I want to put a vertical (trend)
> line that corresponds to today's...Label lines disappear when I copy to Powerpoint
Just created a pie chart in Excel 2007 with Labels which have a line joining
the label to the pie segment, however when I copy and paste into Powerpoint
the lines joining the labels to the segments disappear. Anyone know how to
fix this? Need presentation for tomorrow!
__________ Information from ESET Smart Security, version of virus signature database 4031 (20090423) __________
The message was checked by ESET Smart Security.
...Copy chart with reference table
I have a pie chart neatly tied to a data table alongside. Now I want to copy
both the chart and table to a different area of the sheet so I can modify the
new data table and have 2 different charts.
My issue is that the chart will only allow absolute references, so when I
copy both the chart and table together the new chart still is tied to the old
table - so I have to go and change the source data ranges one by one.
Any way that I can do this easily?
Copy the whole sheet. The copied chart links to the data on the copied
sheet. Now cut the range that includes the copied char...Date/Time Modified
My Access Database consists of many tables. The Query attached to my main
Client Information Form is made up of 4 tables.
-Batch No Table
Basically, I want to be able to insert a Date/Time Modified record at the top
of my main form that will show a data modified if any record is
changed/updated in any of these tables.
Is this possible?
Message posted via http://www.accessmonster.com
...Excel 2007 dates and conditional formats
Can anyone please tell me why I can not use a conditional format (<>=)
to identify if a date is greater or smaller then another. Everytime I
try it, Excel does it right in the first column but misses by 2 days
in all following. It also appears to have problems with the years.
Date of propposed compleation of a task is 10/10/07; if the date of
actual completion is 10/10/07 or sooner, turn GREEN. If the date of
completion is 10/11/07 or older, turn RED.
Can anyone help??
First thing to check:
What does 10/11/07 mean?
November 10 1907?
November 10 2007?
O...setting up outlook 2000 with hotmail
I can't get my outlook to accept hotmail--the help
"Start Outlook, and on the Tools menu, click E-mail
Accounts.In the E-mail Accounts dialog box, click to
select the Add a new E-mail Account option, and then
click Next.In the Server Type dialog box, click HTTP."
there is no E-mail Accounts tab, no Add a new E-mail
account option , and no HTTP option.
Can anyone tell me what to type in to the lines
requesting incoming mail (pop3) and outgoing mail (smtp)?
1) Look on Help, About. It sounds like you have corp mode. You need IMO mode
to have accounts.
2) Does ...Button To Print Workbook With Certain Settings
hi, in a workbook i have 52 numbered sheets. they are
numbered 1, 2, 3, 4 etc. on the first sheet i have two
buttons. i need some coding help with the buttons.
basically i want the first button (called even) to print
all the even sheets in the workbook. and the second
button will print the odd sheets in the workbook. also i
want different margin settings for each button. the even
button will need a left margin of 0.5 and the odd button
will need a right margin of 0.5 - while all the other
margins remain 0.2. i am hoping that this is possible. i
tried recording the marcos but i am not...unable to set a record as private (activities)
Microsoft CRM v3
Customers and prospects are requesting the ability to mark a record
(primarily notes and emails) as private such that only the owner and other
internal party users on the record are able to open it.
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 and then
click "I Agree" in the message pane.
http...Date Range #2
Can someone please assist me with the following issue:
I am currently using the formula noted below to direct
another application ( Bloomberg ) to select prices from
the previous 6th business day.
My question is> Is there any way to revise the formula to
exclude US holidays for successive years (i.e. for 2005,
2006...) without having to manually change the date
entries each year, in the formula?
I'd recommend listing...XY Chart
I have created a short VBA macro that reads x and y data from a spreadsheet,
where every row represents a new series. Besides the x and y data colums, I
also have columns that specify the size of the marker, the markerstyle, and
the foreground and background colors. I have adapted some of John
Walkenbach's code to label each of the datapoints using .name.
The x axis is basically an integer 1 to 5 and the y axis is a value like
price or variable margin. There usually are multiple datapoints on any given
integer on the x axis. For example, I may be plotting the price that a
custom...sorting by date
I have a sheet with
date amount description
12.12.06 5.00 PLUMBER
04.02.01 50.00 ELECTRICIAN
How can I sort into date order.
When I try I get all the 2001, 2006, 2005 together but not 2001, 2002,
Cananyone help please
Is 12.12.06 text or a date value? In a blank cell, enter ISTEXT(A1) where A1
is a cell reference to this date. True means it is text and 03.01.07 will
come before 12.12.06.
You can set up a helper cell, enter
where I'm assuming 12.12.06 is month/day/year. The parameters...how do i set up outlook using my existing internet email account?
I am trying to set up my existing internet email account with Outlook. It was
previously set up, incorrectly. I have no idea what to do.
On Mon, 27 Feb 2006 13:18:29 -0800, Clayton wrote:
> I am trying to set up my existing internet email account with Outlook. It was
> previously set up, incorrectly. I have no idea what to do.
Ask your ISP. They should be able to talk you through.
Interim Systems and Management Accounting
Is is possible to insert a header and/or footer into
multiple charts(Excel 2000 or 2002)? I was hoping I
could insert a common chart header/footer as is possible
with worksheets. Any help appreciated.
You could set up the headers and footers on one chart (File menu > Page
Setup), then before doing anything else, select each subsequent chart in
turn and press the F4 key, which repeats this action.
You could also select a chart, then record a macro while setting up its
headers and footers. Then edit the macro code to only do the headers
and footers, and leave out all that...Change color on date field in form for re-certification
My main form has two different date fields on it. One date field needs to be
re-certified every 6 months, and the other field needs to be re-certified
every 12 months. I would like each of those fields to automatically change
color depending on how much time as elapsed since that training. For the 6
month field, months 1-5 should be green, 1 month left should be yellow and
anything expired should be red. For the 12 month field, months 1-11 should be
green, 1 month left should be yellow, and anything expired should be red.
Thank you in advance for your help!
messingerjc wrote...Charts #37
Can you please advise if we can create one chart with multiple pivot
table of the same data.
...Macro to update information if date changes
using Exel 2000..
I want excel to compare dates on two seperate worksheets and if the date on
the first is greater than the second to insert rows and than copy cells on
the second to different cells also on the second page.
ie..main sheet date is 11-05-08 compared to sheet2 date is 11-04-08...insert
cells at a21:d21 and shift cells down (on sheet2) then copy cells b13:h13 to
The description seems a bit inconsistent, but here is a shot
With Worksheets("Main Sheet")
If .Range("A1").Value > Worksheets("Second Sheet").Range("A1&q...Update Charts X-axis
I have a program with 76 charts. They all use the same range to get their
x-axis (dates). At the first of every month, I change the dates to show the
upcoming month. The table shows the entire year, but we just view it one
month (fiscal) at a time. The series is by rows, but could be changed to
columns if necessary. I inherited this program.
Currently I have to update each one of them manually (click on each and
change their XValues). Is there a way I can update all of them at one time?
Could vba be used to select and update each chart with me just selecting the
range? I am no stranger...Fixed straight line(s) on a chart
How can I draw a fixed straight line in an excel chart. A line on a
level I can easily adjust changing the value in a spreadsheet cell,
Is it possible to fix even multiple lines (eg. as a fixed "bandwidth
information" - data comparing to a bandwidth)?
See the following sites:
"Lukas" <firstname.lastname@example.org> schrieb im Newsbeit...How do i set up specific fields in Outlook contacts
I want to find out how I go about setting up an additional field in my
outlook contacts. (2003 edition) I am looking to put a "home address"
field underneath the business address field and I cannot figure out
how to create this. I know that I can switch the business to home or
other, but would really like to create some new fields here. Can
someone tell me how?
...Creating a square scatter chart
I am trying to create a scatter chart, but it needs to be
square (i.e., 1 X unit takes the same amount of space as 1
Y unit). Is there a way to force the chart to be square?
Jon Peltier has instructions on his web site for squaring gridlines:
> I am trying to create a scatter chart, but it needs to be
> square (i.e., 1 X unit takes the same amount of space as 1
> Y unit). Is there a way to force the chart to be square?
Excel FAQ, Tips & Book List