how can I creat venn diagram using Excel?
I want to analysis data using excel. my idea is to find tht overlaping
between different groups. How can I find the overlaping among differnt groups
using Excel? I think Venn diagram will do such job but how to do that with
Consider simulating a Venn diagram with a Bubble chart. You will have
to devise a scheme to specify the location (X,Y coordinates) and the
size of each bubble to get the desired effect.
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
In article <00499137-A889-4ABB...Conditional formatting help
I can't figure out the way I should create this conditional formatting. It's
probably very simple though.
If a cell, let's say J5, is empty for three days, then the background of
cell A5 turns red.
Any help would be appreciated
Any 72 consecutive hours?
What if someone entered something then deleted it an hour later?
Would that re-start the three day period?
You would need some type of event code to watch J5 to reset the counter in that
I don't think it is "probably very simple" but I may be over-reading this or you
have ...Using dates for x-axis values as string instead of creating a scale
I am creating a line graph where I want to identify each point on the
graph by a date (i.e. the source of the x-axis is to a column full of
dates). When I do this, excel puts the dates on a scale, so a lot of my
data is bunched up in the center of the graph.
Is there any way to format the dates as text for use in the graph
without the text version of the dates being the unreadable number
Or, is there any way to stop excel from putting my dates on a scale?
You can change the axis back to a category type, instead of a time scale
type. Choose Chart...how do I create custom line patterns in Visio?
I have just begun using Visio as diagrammatic tool, but I cannot seem to get
customised line patterns to work for dynamic connector.
...global object dependent on CWinApp global object
I have a global object which depends on the CWinApp global object i.e.
it assumes that the CWinApp global object is created.
After migrating to VS 2005, my global object is getting created before
the CWinApp global object.
Is there any way I can force the CWinApp object to be created first?
I know one of the solution is to avoid a global object and wrap it in a
fuction, however a lot of files use this object directly, so I am
trying to figure out if there is another way.
> I have a global object which depends on the CWinApp global...Display picture with Conditional Formatting
I need to display one of 3 small pictures in Excel, based
on a figure in a given cell. I can use conditional
formatting to colour the background of another cell based
on this value but cannot see how to display a picture or
alternatively change the colour of a drawing object.
In article <firstname.lastname@example.org>,
"Sued" <email@example.com> wrote:
> I need to display one of 3 small pictures in Excel, based
> on a figure in a given cell.
Have a look at the following...
Thanks ve...Object required for (Wscript.sleep 15000) #2
We run the following macro in EXCEL in order to perform OS Backup,
but we got the errors like:
When we run the following macro in Excel, we got errors like:
1. Object required for (Wscript.sleep 15000)
2. Object required for (Wscript.Echo "Not in Archivelog Mode!
Hot Backups not
3. File Not found (strArchive = "arcchk.txt) (Set objArchive =
objFS.OpenTextFile(strArchive, 1, 0)
I think we have to define some variables in order to run that macro
Could someone please suggest abo...Work flow to create new record
Is the following possible in v4 without code writing (we currently use v3 and
I don't think it is possible). Assume that account and competitors have a
When an account is created I want it to automatically add a certain
competitor record to the account. This is to faciliate a work around whereby
I can then run a search to show all records that do not have a competitor.
that is possible in v4 workflow James. you can create a new record (of
almost any type) when your account creation workflow is fired.
"JamesE" <JamesE@discussions.mi...CRM - Sales Pipeline Report
Please help me - I am trying to get the Sales Pipeline report to order
correctly on the Estimated Close date.
My report formats correctly and I have set to Group by Date from the
parent report of the sales pipeline - BUT - when I view the Sales
Pipeline Detail report the Estimated Close date is all over the
E.g. August opportunities following by December then November then
October then September!
I have spoken to one of my developers and he says that Group by Date
is one thing... you need to also order by estimatedclosedate... but he
was no help in providing a solution.
BTW ...send object macro
I am trying to send a report or form from access via.email in an excel format
so it can be edited and saved by another user. I am able to accomplish this
except that the excel sheet is not formatted the way the person wants is
there a better way of doing this or a different way that would have some kind
> except that the excel sheet is not formatted the way the person wants
What format is this person expecting?
It is a fancy thing that looks better than it works it has some colors and
and some drop downs. It wor...Outlook 98 with Domain need to auto start and login
I need a method to start outlook 98 on reboot and have it
login into the network and if possible hide the folder.
This is an alarm sending pc with windows 2k and we use
outlook for the email piece and need to make sure that
outlook is started and logged in so that alarms can be
sent out. The alarms are critical and if a reboot occurs
off hours this needs to auto start.
thanks in advance
...conditional formatting with FORMULA... Please HELP! #2
I have price data in rows like this (each price takes up a cell):
5 5.43 6 6.25 6.50 8 15 9.25 9 8.75 8.50 8.50 8.50
I need to show trends via conditional formatting where on 3 or more
consecutive days prices fluctuate EQUALLY by 0.25 or more each time, up or
down... IE, with the above data, I would want to "flag" let's say, in red
fill color, the sequence 6, 6.25, 6.50 as well as the group 9.25, 9, 8.75,
8.50, but NOT the group of 8.50, 8.50, 8.50.
I have tried if/and/or statements again and again and come close on simpler
tre...customize xml created from dataset
i've successfully write my xml from a dataset schema ....
thanks for support ...
now i need to set properly this parameters ...
<?xml version="1.0" encoding="iso-8859-1" ?>
<!DOCTYPE anagrafica-prestazioni (View Source for full doctype...)>
how can i add this line considering i'm writing the xml froma dataset , with
> i've successfully write my xml from a dataset schema ....
> thanks for support ...
> now i need to set properly this parameters ...
> <?xml...vc++vs2005 resource conditions not working, is this a bug?
I upgraded my VC++ 2003 application to VC++ VS2005, everything works okay,
however it is ignoring the resource preprocessor conditions that use to work
within vs2005, in otherwards it is now displaying the wrong versions of
dialog box etc..
Is this a bug? in anycase it is very frustrating, any help, and/or advice
would be greatly appreciated.
>I upgraded my VC++ 2003 application to VC++ VS2005, everything works okay,
>however it is ignoring the resource preprocessor conditions that use to work
>within vs2005, in otherwards it is now displaying the wrong ver...Outlook Data Files being automatically created
I have a user who has about 7 PST's and only created 1. We
have been able to delete the other 6 in the past, but they
eventually come back without any user creation. This is
Outlook 2002, and on an Exchange 5.5 server. Any ideas on
how to stop this? He is the only one with this issue in an
environment with over 100 users.
Jeff <firstname.lastname@example.org> wrote:
> I have a user who has about 7 PST's and only created 1. We
> have been able to delete the other 6 in the past, but they
> eventually come back without any user creation.
...Creating New Category Groups
I recently purchased Money 2004 and opened my older file
in the new program. Several of my categories converted to
unassigned Category Groups. I would like to create new
Category Groups but I was unable to locate in the help
menu the information needed to do this. Can someone help
me with this? You can respond to me directly using my
email address. Thank you.
In microsoft.public.money, S. Link wrote:
>I recently purchased Money 2004 and opened my older file
>in the new program. Several of my categories converted to
>unassigned Category Groups. I would like to create new
>...Where Condition (OpenReport)
I am struglling with the Where condition when I use OpenReport. In a form I
have a list box in which I can choose multiple selections. Then in my report
I want to the "email" field to equal the current list box selection (I have
it loop through each selection). Will it work with a mutiple selection list
box? I know the code below is wrong but I am looking for help on how to state
the where condition:
DoCmd.OpenReport "1", acViewPreview, , "[email] = " & Nz(lst.Column(1,
Message posted via AccessMonster.com
http://www.accessmonster.co...How to make List created refer by another worksheet data?
My table to check manpower overtime result base on daily working overtime.
Header in 1st row :
(A1)Index No. (B1)Name (AL1)Overtime Total
(Hundreds of employee name...)
Overtime total daily changes base on daily updated data on Column (C:AK)
In second worksheet i make daily updated summary employee that overtime
taken over than 80 hours only
(A5)Index No. (B5)Name (C5)Overtime <80
(Display employee which overtime more than 80 Hours only)
How to make 2nd page updated automatically everyday??
Excel provides for an On Open macro... The macro with the name auto_op...Object Explorer doesn't connect to server specified at startup
I'm constantly trying to shrink regular responsibilities into a single-
click icon. Want me to check the server's hard drive size? I've got
a script that gets hard drive space and sends a text report via SQL
mail; all I need to do is click the SQLCMD batch file on my desktop.
When starting SQL Server Management Studio (2005), I don't want to
specify my server name, login, password, or the database I need; I
prefer to run my desktop batch file that contains the following
SqlWb.exe -E -S myservername -d testdb -nosplash
This gets me into...XML Schema, how to create one for this xml file?
<Directory xmlns="http://tempuri.org/test.xsd" name="root">
I have the...start dialog via menu
I use MFC to generate SDI with CFormView framework. I have one command
under File->Connect. When Connect command is pressed, I want to start
a new dialog box. Inside dialog box, there are radio button and Combo
My question is that, I need my combo box to display COM1, COM2, COM3,
COM4. But I try to use data field in Combo box or use InsertString
function to insert these string, I would not see these string. The
combo box is empty. Where is the problem?
Thank you for help
> Hi, All:
> I use MFC to generate SDI with CFormView framework. I have ...conditional formatting
I'm trying to use conditional formatting to accomplish the following:
if the cell is empty or contains a greater than zero value, the cell
color is white (or no color), if there is a 0 in the cell, the cell color is
This doesn't seem that difficult, but I'm not having success. Either it's
red all the time, or it's white all the time, regardless of value.
This is the conditional formula I'm using: Cell value is equal to
I just left the "natural" fill white.
Then I used this as the formula in Format...Unable to create personal folder file
I started Outlook 2007 for the first time(I've been using Outlook Express).
The start up stopped saying it could not open my default e-mail folders and
told me to go to control panel mail. I did this but when I try to create an
Office Outlook personal folder file, it said the service was not installed. I
did an Office 2007 repair and rebooted. But still no luck.
Start with a new mail profile and see if it works now;
Robert Sparnaaij [MVP-Outlook]
Coauthor, Configuring Microsoft Outlook 2003
...Set DataNavigateUrlField to contained custom object property
I have a GridView bound to a collection of custom objects (e.g.,
Department). Each Department object contains a custom object (e.g.,
Manager). I want to use a property on the Manager object (e.g., Id)
for the DataNavigateUrlFields property on my HyperLinkField, but
setting DataNavigateUrlFields equal to Manager.Id (i.e.,
DataNavigateUrlFields="Manager.Id") does not work. How can I go about
doing this? I have successfully exposed the Manager.Id property as a
property on the Department object itself, but would prefer a more
elegant solution, if possible.
...Conditional Format 04-21-10
I would like to set a conditional format to color each unique value a
different color. It will also be applied to multiple occurences of the value.
The problem is that the values are dynamic and may not always be the same
number of occurences, in the same cell, etc. I have used the formula
IF(ISNUMBER(COUNTIF($F$3:F3,F3)),ROW(),"")) to try to identify the occurences
but creating a conditional format has proven out of my league! The way the
spreadsheet is designed, the probability of more than 4 IDs being used at any
given time is slim, so the next time IDs are...