Simple Two Circle Venn Tool
May 14, 2009
I've been look for an excel tool to draw venn diagrams with the 'circle' size in propartion to the set (population) sizes and the correct degree of intersect.
Having no luck I've made one myself - it's not pretty (the code sure is ugly) but it get's the job done.
May not work in versions earlier than xl07 - haven't been able to test
So take a look - pull it to pieces all you want.
**Warning**
Attachment contains Macros
**********
Orginal text in thread:
Silly question..but that's never held me back.
View 4 Replies
ADVERTISEMENT
Aug 6, 2014
How can I create a Venn Diagram in excel, or the closest thing to it. I would like all similar countries in the middle (where two circles overlap), then the differences on the outside with the country names. See my attached list.
MSCI vs. FTSE Emerging Market Countires.xlsx
View 6 Replies
View Related
Dec 30, 2013
we all have a team, and we are scored on calls, appointments, demos, proposals, and revenue. Rather than asking us to do one or all of these metrics, I would like to have a bulls eye chart that could show people their bonus eligability, so if for example 50% of the circles are touching the bulls eye circle, you would be able to adjust what you need to work on for bonus.
Here is a sample graph.
sample structure.jpg
Here is sample data I am trying to work withsampledata2.xlsx
View 1 Replies
View Related
Nov 18, 2008
Is there anyway to create a checkbox or anything that if a condition were met, it would circle a value?
Simply put, I'm transferring an expense report from paper to excel, and this report is still entered by accounting from hard copies. The expense report requires that all credit card expenses be circled. Previously, I've created cell sized circles, left them unprotected so that they could be dragged over the credit card expense. I would like to add a checkbox somewhere that says, "Circle Expenses" or "Circle All Expenses".
View 10 Replies
View Related
Apr 4, 2009
Ive been trying to draw a circle in excel, although it only draws ovals - Is there a way to draw a circle in excel?
View 9 Replies
View Related
Sep 15, 2014
is there a code to draw a circle? by supplying the center position and the diameter? for example cell "A1" and " A2" are for the center of the circle position and "A3" for the diameter? and whats the code for drawing a rectangular by supplying the starting position and short length and the long length?
View 6 Replies
View Related
May 10, 2009
See attached photo. I need a formula to calculate the length of line “c1”. I know the diameter of the circle, and the number of segments. In the photo there are 8 segments but this will change.
View 2 Replies
View Related
Jul 8, 2013
I a protected workbook I have the rows and columns indicated below. Each letter in the 2nd row is in a single cell. When completingthe entire form I want to be able to have the appropriate letter circled. I am not permitted to change this selection process to a drop down list - it must remain as formatted.
View 2 Replies
View Related
Jun 9, 2008
I have 4 columns wherein the details are somewhat given below. Is there any way, wherein the figures under the column "No. of times" can be circled if it goes above 3.
Sheet1 CDEF19DateTimeMin.No. of times20Apr-0821Wed - 09-Apr-20082:42 & 2:494 & 23222Thu - 10-Apr-200803:215123Fri - 11-Apr-200810:27, 7:24 p.m., 7:39 & 7:401, 8, 1 & 12424Tue - 15-Apr-200810:26, 10:31, 10:32, 11:26 & 11:306, 2, 4, 4, 25 Excel tables to the web >> Excel Jeanie HTML 4
View 9 Replies
View Related
Mar 4, 2014
How do I change the color of the zero/0 circle in a radar chart (it runs from -20 to +25)?
I tried to do the adjustment through "format chart area" but seems like it's impossible to do it from there.
View 6 Replies
View Related
Oct 16, 2008
I'm trying to learn about class modules and how to create object that i can manipulate within a sheet.
i'd like to create a simple cirlce object that i can visibley see on a sheet.
is this possible and if so any idea on how i start?
View 3 Replies
View Related
Aug 9, 2013
I have this code and want to place text in shapes (circles).Text changes based on position in data table.
Code:
POINT_1 = Range("E" & j) * 7
NORTH = Range("E" & j) * 7
For j = 23 To 33
Dim CIRCLE_TEXT As String
CIRCLE_TEXT = Range("A" & j)
[Code] ............
View 7 Replies
View Related
Jan 9, 2014
Creating a formula that would generate a perfect and full circle - see attached picture example. The circle needs to remain centered in the X,Y axis. Also the circle diameter will either be 1, 2, 3, or 4 units large depending on user selection.
View 1 Replies
View Related
May 7, 2014
I had a Calendar Control (2007) but now stuck using 2013. I have to change all of codes related to my Calendar Control to a Month View Control. Problem is I had 4 command buttons beside my calendar to automatically add value to the calendar:
My Code is in a userform. Standard code for MonthView:
[Code] ....
Basically it was “highlighting” the todays date but if one of the cmd_button was clicked then it would highlight the today’s date plus 15 (making the highlighted date, if we take today as an example: 2014/05/22).
Now with the Month View is there a way to select the exact same thing? I mean I know if I deactivate the “Show Today” in the properties but is there a way to make the selected date to have the “Circle in Red” around the date IF I click on a command button?
View 4 Replies
View Related
Feb 18, 2008
Within the 'tools' menu option you have 'Macros'. On a standard tool bar you have the option to record a new macro, edit......, however sometime last week I created a custom button and placed icons on my tool bars that allowed me to click them to record new or run custom made macros. After a clicking the 'custom macro' buttons a few times by mistake, I decided to remove the custom buttons in the hope of returning the macro options (within the 'Tools' menu option) back to normal. However this has not been the case. Now I have no option to record a new macro the the 'tools' menu system.....it has disappeard. Please could someone tell me how I can reset the 'Tools' menu system back to normal?
View 10 Replies
View Related
Dec 17, 2006
I am trying to create a simple translation tool for my product catalog, which is in Japanese, to English.
I have the Japanese and the English terms listed in a file (say, File A) in Col A and Col B which will keep increasing every week.
I want to create a macro which goes thru this list and replaces ALL the Japanese terms to English in "ALL THE SHEETS OF THE PRODUCT CATALOG" (say, File B) .
I have created a button in File A so that when I press this button, I browse my computer, select the file (product catalog) to be translated, replace all the Japanese terms to English terms in ALL THE SHEETS and saves it under a different filename.
View 14 Replies
View Related
Apr 1, 2009
I'm a big fan of the old crossword these days so i decide that i will try and create a crossword creator in excel!
problem is i'm not sure how to use the Thesaurus tool?
Lets say i have a string in cell A1 how would i modify the string using the thesaurus?
also any idea how i can randomly generate a word?
View 5 Replies
View Related
May 31, 2009
I have an application that I attached to this post, which I have been working on, for the last four or months, in my free time on the weekends and the last part I need some help with. The doc has been updated with new macros and a chart.
I would like help with a macro that I can activate and cause a message box to appear when I open the excel doc. I would like also to be able to activate the message box and its associated macros after the document has been opened. If you look on Sheet1 of the attachment you’ll get an idea of where I am trying to go with the message box. I would like it to have
- Message “The Current Time is (Macro puts current computer time here)”
- Question “How much time do you have?” then beneath this question
- Blank field labeled Hour to give answer
- Blank field labeled Minute to give answer
Depending on the current time on the computer as well as the hour and minute entered, a macro with a matching title (each macro includes a time, hour, and minute in its Sub name) a code in VBA will be selected that fits that criterion. For example, let’s say it is 5:30am and I entered 1 hr and 15 min in the empty fields of the message box. As a result the macro named “Sub Hour1Min15time530am” will be activated. Also due to the fact that the macros I have are in 15 min intervals the code would need to round to the nearest time, so if it was 5:33am when I ran the code the macro would default to 5:30am whereas if it was 5:39am when I ran the code the macro would default to 5:45am. You’ll see time controls at the bottom of the application. If I can get the code I am looking for those are going to be removed.
View 5 Replies
View Related
Jun 3, 2009
I am making a Program search tool for my company. I would like the operator to type a part number into a cell. If the part number is valid (from a master list on a different sheet), then I would like to pull the information from the master list and populate a few cells on the search worksheet.
Example:
An operator types: "W3303-01" in a cell and clicks a button. The macro would populate cells on that worksheet with information from another worksheet that pertains to "W3303-01"
View 3 Replies
View Related
May 2, 2009
I have 143 macros, but I put 8 of them here b/c the post would not go through with all of them. I couldn't fit all of them on an attachment either b/c the file size was too big. However, I have this goal I have been working on for the last three months on the weekends and the last part.
I would like help with a macro that I can add onto the ones I have. I would like the macro to activate and cause a message box to appear when I open the excel doc. I would like also to be able to activate the message box and its associated macros after the document has been opened.
I would like the message box to have
- Message “The Current Time is (Macro puts current computer time here)”
- Question “How much time do you have?” then beneath this question
- Blank field labeled Hour to give answer
- Blank field labeled Minute to give answer
Depending on the current time on the computer as well as the hour and minute entered, a macro with a matching title from the list below will be selected that fits that criterion. For example, let’s say it is 5:30am and I entered 1 hr and 15 min in the empty fields of the message box. As a result the macro named “Sub Hour1Min15time530am” will be activated. Also due to the fact that the macros I have are in 15 min intervals the code would need to round to the nearest time, so if it was 5:33am when I ran the code the macro would default to 5:30am whereas if it was 5:39am when I ran the code the macro would default to 5:45am.
View 7 Replies
View Related
May 18, 2009
Do we have NumericUpDown Tool Control in MS Excel 2003 that can be employed on a userform. The one similar to the numericupdown of VB.NET. I want to restrict user to input only numerals. Though I can use IsNumeric Validation in Textbox_Change event but still I was curious to know if there is any other in-built function in MS Excel.
View 2 Replies
View Related
May 24, 2007
i have about 500 excel files that are built to specific format, only some data changes.
I need to make same changes to all the 500 files, so i'm asking that is there any kind of tool (free/commecial) that can batch changes to all files?
View 9 Replies
View Related
Jan 25, 2007
I want to let my buttons on tool bar in group status, there is a saparator bar between two groups, what can I do? I tried but no any result.
View 2 Replies
View Related
Jan 21, 2014
I have 2 sheets, one with users and a tool they have been using, and one with a list of unique users, I would like to count how many unique users are using a tool. The sheets are set up like so,
Sheet 1
User Tool (number of uses)
abcdefg 1
hijklmn 5
1234567 1
1234567, abcdefg, opqurst 2
wxyz123 0
Sheet 2 Have they used the tool
abcdefg
hijklmn
1234567
wxyz123
opqurst
So yes, I am trying to count whether or not the unique users have used the tool, this is a simplifed version as my data set runs into the thousands. I was using the countifs function, but that doesnt count properly if theres more than one user in the group.
View 4 Replies
View Related
Apr 27, 2008
I am preparing Vendors' Directory for our company. This Directory has different products listed in seperate sheets. The names, phone numbers and address of various vendors' are listed in each sheet.
My problem is that I want to create a new sheet with a find tool that will search particular name of the product or the vendor from all the sheets (say product A, product B) and list out complete information in single page.
I have attached a sample excel sheet which is supposed to search the name "Daniel" from sheets - Product A and Product B and list it out in the first sheet. The sample does not work.
View 12 Replies
View Related
Mar 9, 2012
I use this code to hide the tool bars in a workbook, the code works but when I go to a new sheet the row and column headings are visible. I tried several things that didn't work.
Code:
Private Sub Workbook_Open()
Application.ScreenUpdating = False
On Error Resume Next
With Application
.DisplayFullScreen = True
[Code] ..........
View 1 Replies
View Related
Jul 9, 2012
How to use the Camera Icon Tool using a Macro?
I want to copy the First Row which is the Column heading of one Sheet to a different Sheet
Example : From Col A till Col G First Row is to be copied as an Image. Normally I do it using the Camera Icon, however when I tried recording a Macro for the same it did not work..
So how do I that if I provide the Start Column and End Column Alphabet as a Variable is that possible.. I want this Image to not remain Volatile which is the case using the Camera Tool..
So, how do i get the picture of only the first row or any row and store it is an Image in a different sheet as static picture so that even when the sheet is moved to a different location it does not make a difference to the Image.
View 9 Replies
View Related
Aug 16, 2013
I have an upholstery business and I have created a workbook containing multiple sheets (proposal, invoice, sales order log, etc.. ) Following, I have saved it in Template format, which I open and save by order number somewhere else. The issue is, I don't know how to track what the last order number I used was....
Is there anything I can work using excel that will allow me to make that easier without having to go open a window and looking at the last order number after arranging the workbooks by name inside a folder?
View 4 Replies
View Related
May 21, 2014
I am a Supply Chain intern at a company for the summer. One project I have been given is to create a tool in excel that allows our purchasing people to type in certain inputs (origin, destination, etc.) to calculate the total cost of shipping an item from a supplier in anywhere from china, to somewhere locally. I am gathering quotes for shipping via ocean and truck. How can I get where I enter in one location, say shanghai, china, shipping to another location, say Norfolk, VA, and get the total mileage difference to show?
View 1 Replies
View Related
Aug 17, 2007
way the date are shown can be changed by the date format tool, provided the date was entered the correct way. I think we are missing each other. I think the way the date was entered (17.08.07) and converted to (17/08/07) was good. At first it was in text so one wouldnt have known whether it will be taken as yymmdd, ddmmyy, mmddyy etc. well it end up like as 17(yy), 08(mm), 07(dd) instead as 17(dd), 08(mm) and 07(yy). My Q now is is there a way (formula) to swap these orders around...?
View 9 Replies
View Related