Best Method To Display Place Finishes With Appropriate Suffixes

May 8, 2014

I'm trying to create a graph which presents how people finished in a contest (1st, 2nd, 3rd, etc). Let's say there are 10 places with 10th being last. What is the best way to illustrate this through a graph while making it intuitive?

My best idea is to create the places in reverse-order on the Y-Axis, where 10th would be on the zero-place and 1st would be the top Y coordinate. I tried to create a graph where the Y-coordinates start with the lowest at the bottom and work their way up, but that creates the opposite perception where the talles bars are better. So my questions are:

Is this the best way to present this type of data?How do you create a specific set of values on the Y-axis?How do you reverse the ordering of the axis on Y?Is there a way to add the appropriate suffix ("st", "nd", "rd") automatically through a formatting option?

View 2 Replies


ADVERTISEMENT

Move To New Sheet Only When Code Finishes.

Feb 25, 2009

I have a small problem that is more annoying than anything else. I have a command button that opens a userform, and the user can select a value and 'OK'. On 'OK', the code runs, however I would like the sheet 'Information' to remain visible until the code finishes and then switch to 'Task Intervals'. There is also a lot of screen flicker, despite selecting it off/on. I have included an Example file so that you can see the problem.

View 3 Replies View Related

Best Method To Display Chart Based On Condition Met?

Sep 6, 2013

I'm designing a sheet at work where an individuals performance is monitored then charted. However the supervisor has now decided that he wants to see their performance charted against that of their entire team.

Using Data Validation i have a drop down selecting the user. Then their performance stats are found from various sheets using INDEX and MATCH. I have also done this in another cell to locate their team number ie "Team 1" for example.

Can i use VBA or any other method to generate a chart for when the team is displayed to then generate the entire teams chart? The data to generate this graph is on its own sheet as a team overview?

View 1 Replies View Related

Linked File Is Closed Before It Finishes Recalculation

Apr 27, 2007

I have a workbook with a button to get updated data. The button simply opens the other workbook and then closes it. THe problem is it opens the book and then closes it before the opened book has a chance to finish it calculation resulting in lots of #value errors. The book that is being opened works fine but because it is shared it can't be left open and needs to be closed asap, though it should be allowed to finsih calcs before it gets closed again. If anyone know a way to make the following temporarily halt until the opened book finishes calculating before it closes it.

Workbooks.Open Filename:= _
"X:gas daily pricingGD pricing weather call active summer.xls", ReadOnly:=True
ThisWorkbook. Saved = True
ActiveWindow.Close False

View 7 Replies View Related

Macro To Copy And Place Data To Specific Place

Feb 22, 2007

I am after a macro to do the following, my visual basic skills are very limited (non existant):- Look at the date in cell A1 on Sheet 'Live Report' and err 'remember it' Copy a range of cells from A3 to A10 on 'Live Report' Go to sheet 'Monthly Summary' and find the date that had been remembered previously (this date will be in column A on 'Monthly Summary' which will probably be a mixture of values and formulas). After the date has been found paste special and transpose the 'values only' copied range from 'Live Report' (A3 to A10) in column B on 'Monthly Summary' next to the date that has been found in Column A.

View 2 Replies View Related

Fill In The 3 Criteria Fields, Calculate The Result, Copy The Result, And Place It Into The Correct Place On The Table

Oct 19, 2006

I have a macro that imputs data from an external database and puts it into a temporary worksheet. This data has 3 columns (ID, Date, Amount). I am then making another sheet which has X number of tables (one for each ID), with the years being the column headings, and months being the row headings. ie.

| ID X
| +------+------+------+--->
| | 1999 | 2000 | 2001 |
+------+------+------+------+--->
| Jan | $100 | $250 | $300 |
+------+------+------+------+--->
| Feb | $200 | $300 | $200 |
+------+------+------+------+--->
| Mar | $300 | $250 | $100 |
+------+------+------+------+--->
| Sum | $600 | $800 | $600 |
| +------+------+------+--->

| ID Y
| +------+------+------+--->
| | 1999 | 2000 | 2001 |
+------+------+------+------+--->
| Jan | $100 | $250 | $300 |
+------+------+------+------+--->
| Feb | $200 | $300 | $200 |
+------+------+------+------+--->
| Mar | $300 | $250 | $100 |
+------+------+------+------+--->
| Sum | $600 | $800 | $600 |
| +------+------+------+--->

Currently I have a few hidden fields for the DSUM Criteria. I start making the tables. And then filling in table based off of the month and year. Doing so I need 3 criteria:
>= First Day of the Month
<= Last Day of the Month
= ID #

The problem is it takes Excel too long to fill in the 3 criteria fields, calculate the result, copy the result, and place it into the correct place on the table. Is there another way to get this data into the correct tables faster? Instead of using DSUM?

View 8 Replies View Related

Error 'Method Range Of Object Global Failed' On FindNext Method

Dec 10, 2008

I'm trying to get the Find and FindNext methods to work. Column C contains serial numbers and there's a chance that a serial number might appear more than once in the column. What I'm trying to do is get Excel to find the first occurance of the serial number, find what row it's on and then see if this matches the variable 'CurRowNo' (defined earlier in the code). If it doesn't I want it to look at the other occurances of the serial number, find what row they're on and see again if it matches CurRowNo.

The variable 'EngCount is the number of occurances of the serial number (also worked out earlier in the code). I've got the code below, but I get the error 'Method Range of Object Global Failed' on the FindNext line. I have no idea what this error means or why it's happening.

View 3 Replies View Related

'Select Method' Failure 'error 1004 Select Method Of Range Class Failed'

Oct 28, 2008

My workbook holds a month template and sheets for each month. I work on modifications in the template ,but would then like to update all the monthly worksheets. I recorded a macro to show me how to start programming the vb sub, but get a runtime failure 'error 1004 Select method of range class failed' when trying to select the column to copy,

View 4 Replies View Related

Cell B1 To Display True If Any Of The Values In Column C Match Otherwise I Want To Display FalseOR Function Confusion

Dec 16, 2008

Example:....

i m wanting Cell B1 to display true if any of the values in column C match otherwise I want to display false.

A 1
B 0
C 0
D 0

But I can't determine how to get this done.

View 5 Replies View Related

Formatting / Display - Field Not Display 0 If It Is Empty On WHITE Sheet

Mar 14, 2013

I have attached the spreadsheet for reference. All other sheets pull information from the WHITE sheet.

I want the columns for unit price, discount and total to be set to two decimal places but I also don't want it to show anything if the field has a 0 value (so if i only have a few items I don't get lots of o's).

To get the field to not display a 0 if it is empty on the WHITE sheet I have been using "0;-0;;@" which I found on the net. If I use this then it negates the two decimal places.

This also includes the WHITE sheet.

View 3 Replies View Related

Allows Me To Place Checkboxes In Each Row

Jan 21, 2007

What I have is a long list of about 100 items. I would like to set up an excel sheet that allows me to place checkboxes in each row and then whatever checkboxes have been checked, to simply collate and print out ONLY the check boxes that have been checked.

I have gotten as far as to create and rename the checkboxes but my skill ends there. I also need to know how to get each checkbox to correspond to a row.

I appreciate ANY help that you can give me.

EDIT: this doesnt NEED to be checkboxes, it can be optionbuttons if that is easier... simply something to select/deselect and print.

1.1 a blah
1.1 b blah
2.1 a blah
2.1b blah
3.1a blah
3.1b blah
3.3.a blah
etc blah
etc

View 10 Replies View Related

Find 1st, 2nd And 3rd Place...?

Jan 19, 2009

We're doing a "Biggest Loser" competition at work. I have a spreadsheet that calculates the % of body weight lost. I need a formula that will look at the results and display 1st, 2nd, 3rd places. Here is this weeks results...

View 2 Replies View Related

Where To Place The Macros

Nov 6, 2007

I have created a excel spread sheet to be set up like a schedule, including multiple macros through the sheet, when I started it put the macros into "Module 1", now if I wanted to use this same worksheet and copy it and create multiple sheets in one file via the tabs does it make a difference where the macros reside? if it remains in "Module 1" it will only be in one spot will this create problems later on or should the each reside in the sheet objects.

View 9 Replies View Related

Place Sheet / Tab Name In Cell

May 7, 2014

How do I do this?

View 3 Replies View Related

Decimal Place In Number

Dec 5, 2008

I am trying to figure out how to insert a decimal into a number. For ex: 1234 to become 12.34. I tried creating custom or special formatting but I cannot figure it out.

View 3 Replies View Related

Decimal In Wrong Place

Mar 13, 2009

how to control this,it should be 0.55. is they a wat too round off too next highest hole number? Here is a example.

View 2 Replies View Related

Place File Name Into Private Sub

Dec 11, 2009

The code below writes the names of all active worksheets into the A column of the active worksheet. I have a situation where I have 2 workbooks open (3 if you count PERSONAL.XLS). One of the worksheets has a consistent name, the other has a name that changes every week (not in a consistent pattern).

I'd like to be able to use the routine below to get a list of open workbooks, ignore the one I'm working in and PERSONAL.XLS, and instead put the remaining filename into other Private Subs in a User Form to run other routines.

View 6 Replies View Related

Formula To Place Name Next To Appropriate Date

Apr 12, 2009

Spreadsheet 1: So in column "A" I have all of the dates written out. Then i need column "B" to put the appropriate name next to the date that person chose in spreadsheet 1.

Spreadsheet 2: I have a live form that feeds data into a different spreadsheet.

I am using google spreadsheets.... The formulas are the same as in excel

View 14 Replies View Related

Place Cell Value Into Function

Jan 6, 2012

I need to place cell value into one function (I cannot modify this function it is built in) .

For example:

Function is

CODE
A2=KGF
=ABCDFE_(my value of A2 thus KGF)_GHIJKL

Thus the end result:

=ABCDFE_KGF_GHIJKL

I can concatenate the string but I cannot evaluate it .

=CONCATENATE("ABCDFE_",A2,"_GHIJKL")

is there a way to do it ?

View 4 Replies View Related

Show Decimal Place Only If Value Is Less Than 1%?

May 22, 2012

I have a column of percentages where I only want to show 1 decimal place if the value is less than 1%. The rest of the percentages I want without decimal detail.

I've tried custom formats and cant quiet get it right. Am I close with this?

[>1]#.#%;###%

View 2 Replies View Related

Using Variables In Place Of Selections?

Jul 10, 2012

We currently have a macro that has a limitation that it only works on 8 sizes, and only upto 12 Colours. We want to change this to make the number of sizes and colours totally variable. how to change this bit of code below so that the cells selected are not fixed but are variable depending on the number of sizes and colours as entered in sheet 2.

Current Code for When 8 Sizes and 12 Colours

Code:
Sheets("Sheet2").Select
Range("B30").Select ' This is Fixed
Selection.Copy
Sheets("Sheet3").Select
Range("G2:G109").Select ' Want this to be variable based on the number of rows needed starting at G2, this can be found out from Sheet2, Cell G28
ActiveSheet.Paste

[code]...

On Sheet 2 Cells G23 is used to enter number of Sizes, and G24 is used to enter number of colours. Cells G25, G27 and G28 then have formulas to work out other values that will be needed in the macro.

View 1 Replies View Related

Copy Worksheet And Place It At The End?

Aug 6, 2012

I'm trying to copy a worksheet and place it at the end. I will rename it afterwards. I'm using the following code but it doesn't work.

Private Sub Copy_sheet()
Dim wbk As Workbook
Dim wsh As Worksheet
Set wbk = ActiveWorkbook
wbk.Worksheets("Template").copy After:=wbk.Worksheets(wbk.Worksheets.Count)
Set wsh = wbk.Worksheets(wbk.Worksheets.Count)
wsh.Name = "New Sheet"
End Sub

View 4 Replies View Related

Place Text In A Cell

Oct 8, 2007

Is it possible to place Text in a Cell if a CF is True?
So Far I am unsuccessful.
I have this CF in Column S

=IF(ISBLANK(R10346),"Need Dept & Cat")

View 9 Replies View Related

Splitting A Value At The Decimal Place...

Mar 19, 2008

I have the value 26.06 in cell A1, I want to have everything left of the decimal place in Cell B1 and everything right of the decimal place in Cell C1, is this possible. Bearing in mind A1 will be variable (ie it could be 159.65).

View 9 Replies View Related

Worksheet Name And Place It In A Cell

Apr 9, 2008

Not using VBA is there a way to take the worksheet name and place it in a cell?

View 9 Replies View Related

Place Time In Textbox

Jul 29, 2008

is it possible to place time in a textbox on a userform?
I am trying to make 5 textboxes to display different time zones.

View 9 Replies View Related

How To See Where The 55th Place In A Cell Is

Aug 6, 2008

I use Excel 2002 - I have a column with Text in its cells. The cells usually range from 30 to 130 characters including spaces. I need to use word wrap.

I would like to be able to see where the 55th character is ( Including spaces ) - but I also need to see the rest of the contents of the text in the cell.

I have thought about coloring the first 55 character/spaces ?

or inserting a character at space 56 ? Example below

XXXX XXX XXX
XX XXXXX XXX
XX XXXX XXXX
XXXX XXX XXX
XXX XX~XXX X
XXXX XX

View 9 Replies View Related

To Place A First And Last Name Into An Email Convention

Aug 11, 2009

I have a spreadsheet where I have the first and last name in two separate columns. In the same spreadsheet, I have a column where there is an Email Convention. The email convention can change from row to row. Is there a way to take the first and last name columns and make it format according to the email convention column. For are some samples.

First Name Last Name Email Convention
Ada Smith @mail.uch.org

Ann Blanc _@chs.net

Bob Jones .@halifax.org

View 9 Replies View Related

Using DMIN In Place Of Arrays

Aug 25, 2009

I currenlty have a spreadsheet that works well but uses a lot of array formulas and, therefore, is running VERY slowly. The slow speed makes it impractical to work with, so I am trying to replace the array approach with the DMIN function. However, I am having trouble getting the DMIN function to find the minimum value in a column range according to a criteria in the same arrays did for rows.

Here is my problem:
I currently have arrays (composed of dates) in rows and I have converted this to non-array columns. I have pasted a sample of the new worksheet below.

Column D ["Original End"] has dates that are static. Column F ["New Start"] has dates that can change according to user inputs. I want Column G to find the date in a Column D that is greater than the date in Column F in the same row.

In the table below, you can see that I was able to get this to work for cell G3; however, when I pull the formula down, it stops working. Here is the formula I have in cell G3: =DMIN($B$2:$E$15,"End",$I$2:J3).

Conceptually, I want to write the following function in cell G4: =DMIN($B$2:$E$15,"End",">"&F4), where the criteria is 'greater than date in F4' - but this obviously doesn't work.

View 9 Replies View Related

Place The Name Before Equal Sign

Oct 26, 2009

I'm trying to simplify a section of my code by naming a long string that is repeated. I tried by simply place the Name before equal sign (=) and also putting Set before the name. Both failed though I've seen both methods used successfully in other code. Am I having a syntax issue of some sort?

Private Sub ConditionalRowDelete()
Dim NumRows, iLine As Integer
ActiveSheet.UsedRange.Select
NumRows = ActiveSheet.UsedRange.Rows.Count
Dim CircuitType As Range
Set CircuitType = Range("C" & iLine).Value
For iLine = NumRows To 2 Step -1
If Range("A" & iLine).Value > "6999" Then
Rows(iLine).EntireRow.Delete
End If
Next iLine
For iLine = NumRows To 2 Step -1
If CircuitType = "VOIP" Or CircuitType = "Customer Care" Or CircuitType = "Dialup" Or CircuitType = "IRU" Then
Rows(iLine).EntireRow.Delete
End If
Next iLine
End Sub

View 9 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved