Problem with xy scatter with dates
I am trying to create an x-y scatter chart where both the x values and the y
values are dates. I highlight the 2 adjacent columns of date data and click
on Insert>Scatter. Instead of a scatter graph, I get a line chart with 2
lines (the two data columns). The x values on the graph are simply a count
of the data points as in a line chart.
If the 2 columns of data are not dates, I get the correct scatter chart, but
not if the x-values are dates in which case I get a line chart. How can I
get a scatter chart with both x-values and y-values as dates?
You could select just the Y val...Make Table Query
I have a Macro and at the end of the Macro I have a Make Table Query
that I would like to automatically save as todays date in the current
database. Does anybody have an idea on how I can do this?
On Wed, 06 Jun 2007 11:40:24 -0700, email@example.com wrote:
>I have a Macro and at the end of the Macro I have a Make Table Query
>that I would like to automatically save as todays date in the current
>database. Does anybody have an idea on how I can do this?
A date is just a field value. Saving today's date as a Table is almost
certainly VERY bad design. Why do an expensive, awk...Add Actual End Date to Resolved Cases view
We would like to add the actual end date to the Case General Tab or possibly
to the Resolved Cases and/or My Resolved Cases view. I know that the Actual
End Date is available on the Service Activity and Case Resolution but this
field is not available for the Case.
Any workaround for this?
Is there a DatePicker in Excel 2007 so I can pick a date when I focus
on a cell?
If not, where can I get one?
Microsoft MVP - Excel
"shapper" <firstname.lastname@example.org> wrote in message
> Is there a DatePicker in Excel 2007 so I can pick a date when I focus
> on a cell?
> If not, where can I get one?
...Conditional formatting with dates formula problem.
I appreciate help on this topic. I'm very new to excel's conditional
formatting capabilities and I need help on the following:
I have a worksheet where I am using columns A and B to be fashioned
into a type of "reverse" library checkout card; I want to flag when 120
days have passed since an item has been checked out. All cells are
blank with the exception of the formatting applied to cells in column
A. For example, Condition 1 on cell A1 has the formula:
**I've also tried =IF(ISBLANK($B1),($A1-TODAY())<120)
My objecti...multiple sales persons per customer
Some companies are set up so that a certain brand or class of items are sold
by certain salespersons, which means that a single customer can be serviced
by a number of sales persons.
The system should have a relation of Item/Customer to sales person or Item
Class/Customer to sales person. This will then allow a single customer to
have several sales persons and because there is a relationship to the
inventory item, when the item appears on a sales document the correct
salesperson will be attributed to the sale.
At the moment the system allows several sales persons per sales document but...Dates are not displayed in ComboBox
I have a From ComboBox and a To ComboBox on a Form; cboFrom and cboTo. The
Row Source is this:
SELECT DISTINCT SharePrices.DateTime FROM SharePrices ORDER BY
The SQL is this:
SELECT DISTINCT SharePrices.DateTime
ORDER BY SharePrices.DateTime;
Nothing is showing in either ComboBox; all I see is a whole bunch of blanks.
I just did this in another form in another Access database. I can’t figure
out why it’s not working for me now. I’m using Access 2007.
I’d sincerely appreciate any insight with this.
Ryan--...Year to date sales history of inventory
How can this system provide me with cumulative sales numbers of a particular
item ie: How many total gym shorts did we sell in 12 months?
Detailed Sales Report with a custom date range. In the body of the report
look at the top line (Overall) that will give you the answer you seek my
Now go caterpillar blossom into a butterfly.
> How can this system provide me with cumulative sales numbers of a particular
> item ie: How many total gym shorts did we sell in 12 months?
Musta got a new batch o glue, huh? (g)
To pick up where Rob started...Excel 2003 - VBA
Does anyone have and idea how to create the date of the last day of the
=Dateserial(year(date), month(date), 0)
HTH. Best wishes Harald
"Craig Brandt" <email@example.com> wrote in message
> Does anyone have and idea how to create the date of the last day of the
> previous month?
"Craig Brandt" <firstname.lastname@example.org> wrote in message
news:yvVxk.email@example.com...Why is "image and text" option grayed out for some buttons in the customization?
It so happens that the most frequently used buttons on the tool bar
are the up-arrow and down-arrow (the ones that move to the
As I tried to assign short-cut key to them, however, i found that the
"image and text" option is grayed out - for that matter, all other
display options are grayed out - when you go into customization mode.
Why is "image and text" option unavailable for some buttons?
...Access autonumber field changes to date format when Excel imports
When importing Access data into Excel, the autonumber field in Access is
chenged to date format instead of a general number format. I could run a
macro to change the number format but this only happens on some Vista
machines, not all.
Any suggestions as to why this is happening?
...What date was a batch created
I'm in GP v8.0. I need to know what date a user created and/or saved a batch.
I've looked all over and there doesn't seem to be any trail when a batch was
created/saved short of turning on the User Tracking system.
Please get back to me ASAP - firstname.lastname@example.org
First, as you probably know, this is not a forum for getting instant answers
because it is not monitored officially.
Second, SY00500 stores the batch history. It is in the company database. You
will need to create a report based on this table.
Charles Allen, MVP
"Sandy D''Anna, GP Project Ma...conditional format a date in Excel
I am trying to use conditional formatting to show when a date is less than 30
days in the future. When I use "cell value" "is less than" "="Now()+30" all
the dates change.
I am trying to use conditional formatting to show when a date is les
days in the future. When I use "cell value" "is less than" "="Now()+30
the dates change.
lose the quotes in the condition =Now()+30
Unless you mean between today and 30 days in the future in which cas
=now() would be the first condition and =now()+30 would be the second
Al...Excel 2002 Day/Date format
For some reason on one of my computers, Excel won't allow the cell to be
formatted to read "Day, Month Date, Year".
The option doesn't exist under the Date category of the Format Cells
Anyone have any ideas?
Have you tried using a Custom format?
"The Kingfish" <KCKingfish@earthlink.net> wrote in message
> For some reason on one of my computers, Excel won't allow the cell to be
> formatted to read "Day, Month Date, Year".
> The option doesn&...Install dates formating using conditional formating?
I have 2 cells (A1 and A2). I would like to have the following take
1. If I place a date that is either past or withinthe next 30 days
into A2 format the text as red.
2. If I place any date into cell A1, I need A2 to say N/A.
I have been able to do #1 using conditional formating but am stuck on
Can anyone help?
Jerry Eggleston's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=9898
View this thread: http://www.excelforum.com/showthread.php...Julian Dates?
Hi - i bet this is simple - but how do i convert NOW() ... or TODAY()
into a julian date like 31206 (day 312, year 06)
Worksheet and macro solutions posted by Myrna Larson 1999-06-11 http://groups.google.com/groups?oi=djq&ic=1&selm=an_488468851
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
"ElBozo" <email@example.com> wrote in message news:FMgih.5223$4Q6.1916@trnddc06...
> Hi - i bet this is simple - but how do i conv...Custom stationary
How can I add a header and a signature to emails when using word as my
default email package in Outlook 2000?
Peter Downes <firstname.lastname@example.org> wrote:
> How can I add a header and a signature to emails when using word as my
> default email package in Outlook 2000?
Customize the EMAIL.DOT template.
3290 Patterson Ave. SE, MS 1B3
Grand Rapids, MI 49512-1991
Brian.Tillman is the name, smiths-aerospace.com is the domain.
I don't speak for Smiths, and Smiths doesn't speak for me.
...excel dates 03-25-10
how do i change #(1-365) to the corresponding date in excel?
It depends on what result you want. If the number is 1, what date do you
With your number in a1, try the following:
If that doesn't do what you want, post back with what you want to achieve.
"king2385" <email@example.com> wrote in message
> how do i change #(1-365) to the corresponding date in excel?
I would like to know details about the Microsoft CRM Customization Exam. I am
a Application certified professional and I would like to know if the 2 exams
are similar. Is the exam too difficult? Which is harder? The Application exam
or the Customization exam?
Troy D. Chinula is the guy!
Microsoft CRM 3.0 certification will be available in February - I think so. I
will also do that . Add me on msn firstname.lastname@example.org for more ...
All about Microsoft CRM 3.0- read
> I would li...Dates in excel.
I know excel convertes dates into days since 1900, i just wondered i
anyone knows exactly how it does it in terms of basic idea of code as
need to write a similar thing in a different language without built i
capabilities for date handling. Any links or anything would b
Message posted from http://www.ExcelForum.com
Here are some links:
>I know excel convertes dates into days since 190...Calculating Dates by Month
I'm pretty new to this game, so here goes.....
If I enter a date in cell A1, say 24/11/03.... I then want B1 to tel
me what month that is (i.e November-03)
But I also want excel to automatically complete cells C1-M1 with th
next 11 months (December-03 to October-04).
Thanks in advance!!!!
Message posted from http://www.ExcelForum.com
First your format problem
Format > Cells > Custom Format
type mmmm-yy in the text box.
Now copying across:
Use the following in B1:
I have a file from someone with dates appearing to be formatted in the
following custom format mm/dd/yy;@
When I copy them, they change to “actual” date according to their serial
So custom formatted 04/21/87 when copied to another workbook transforms to
04/20/83 (30,426 serial number).
I know how to preserve the dates by using = Date (Year(), month(), day())
function. But can someone please explain why this is happening, since in the
future it could be easily overlooked when copying and pasting.
Thanks for your input!
Using 97 on Windows NT
G...Conditional Formatting with Dates
I have two columns: G25 (submission date) & H25 (delivery date - which
defaults to 3 workdays after the submission date).
The formula I'm using to generate H25's value is:
I want to conditionally format H25 to appear RED if the user manually enters
a date that is less than 3 workdays.
How can I do this? I have tried setting it myself but just can't get it to
Thanks for your help
You cannot use WORKDAY in a CF - since it is a Analysis ToolPak function.
You could use a hidden column th...space before date in csv files
I often have to import CSV files into excel and the files contain dates
1/2/05 12:22:12 PM
The problem is that when I import them, there is a space before the
date so it is not taking as a date unless I remove the space. I tried
to use the "TRIM" command and it does take the space off, but it still
won't recognize those values as dates for some reason. If I use the
trim function and then copy the values only into another cell it still
won't act as a date until I go in to edit the cell and then click out
Has anyone ever run into this and do you have any su...Excel 2003 Inserting current date
I wish to create a spreadsheet that whenever data is entered in a
row/column, the actual date is entered automatically in a date column. I do
not want the date to be overridden.
Right-click your sheet tab and "View Code".
Copy/paste this event code in that sheet module.
Enter anything in any cell in column A and B will get a static date.
Private Sub Worksheet_Change(ByVal Target As Excel.Range)
'Col B time will not change if data in Col A is edited
On Error GoTo enditall
Application.EnableEvents = False
If Target.Cells.Column = 1 Then
n = Target.Row