Graph 48 Months Of Activity
Aug 8, 2012
I have a very large spreadsheet with financial information I am trying to graph on a line graph (which I know how to do). I would like to take only the last 48 months of activity and graph that. Is there a formula I can use to select only the last 48 months without reselecting the data everytime?
Example (for simplicity purposes in this example I only want ten months of data
Jan Feb March April May June July Aug Sept Oct Nov Dec
10 12 14 10 9 12 11 12 12 10 9 13
I would like a graph that displays march-december sales figures.
View 2 Replies
ADVERTISEMENT
Jun 30, 2009
I have a word document that has all kinds of graphs embedded in it. When I double click the graphs, an excel spreadsheet comes up. The spreadsheet contains quite a few years worth of information. I, however, need it to automatically refresh to show only the most recent 18 months of data on the graph. The documents are in MSOffice 2007.
View 9 Replies
View Related
Apr 11, 2014
I have one spreadsheet with a list of materials by material number. I have another with all sales activity. How can I pull into the first spreadsheet the date of the latest activity from the second spreadsheet?
View 2 Replies
View Related
May 15, 2014
have a data set with client id and most dates of activity....
I would like to be able to include within a report the date of first activity and the most recent date of activity....
please see attached sample worksheet...
View 12 Replies
View Related
Mar 6, 2013
I have a user form with several command buttons.
Is there a way to show that excel is calcutaing when one of the command buttons is pressed?
The button starts a series of calculation that take a while to complete.
It would appear to other users of my spreadsheet that excel or the user form is not functioning correctly.
It would be neat if there is a way to show a % complete bar. but a simple graphic or text will also work.
View 2 Replies
View Related
Nov 29, 2008
I run an activity group wherby members have to complete various events such as swimming, cycling, climbing etc..
I have a worksheet that comprises of columns A - P
Column A = Members Name
Column B = Address Info
Columns C - P equals the activities
As each member completes an activity a marker (the word "DONE") is placed in the relevant column C - P
This results in several records being created for each member with a single entry in one of the columns C - P.
I want to consolidate the data into a single row showing the activities completed for each member
The data is sorted by column A brining all like records together
So if the name in the current row = the name in previous row then move entries in columns C - P up one row then delete the current row.
View 9 Replies
View Related
Feb 26, 2009
I sit possible to run a macro that will record email activity from an Outlook inbox and store it in a Excel file. For example, the date received and the subject line for every email that comes into an inbox would be logged.
View 9 Replies
View Related
Aug 1, 2006
I received a suspicious email from <Excel Help/VBA Help: [forum@ozgrid.com]>. It may be nothing but I am wanting to inquiry about it's origin and content, how would I do this? I of course have received other emails from this site.
View 9 Replies
View Related
Aug 8, 2014
I have this table that I put together everyday describing the activity of my department. There is the date displayed as "Num-Date", the day of the week and multiple columns of data. Every day I have to add a new row and update the date, and the data, etc. I have a macro that inserts a new row and auto-updates the date and weekday, I also have a web query set up to fetch the data I want and display it right next to the table, but what I want to do is make the table more intuitive and automated.
View 1 Replies
View Related
Feb 11, 2013
I am recording attendance to our various activities as follows (screenshot):
Column A show the activity
Columns B onwards show attendance by day of the week (names gathered from list).
Now I've got a simple formula =COUNTA(Sep!B4:AE51) to count the total attendance for the month, modifying the range to cater for each activity, but it would be better if I could keep the range the same and modify the activity.
Also, I would like a formula to show the attendance at each activity by the day of the week (ie to show the total and average attendances for Mondays or Tuesday etc).
View 5 Replies
View Related
Apr 26, 2007
I have Activity data from my production line that details when a job is running "RUN" and when its on stop "SETUP". It looks like this:
Run 0.45 hrs (decimal hours)
Setup 0.1 hrs
Run 1.2 hrs
Setup 0.2 hrs
etc.
I want to be able to graphically present this against a fixed timeline, I have the timeline in a column, (not a row). I have cumulatively summed my times so I have this...
Run 0.45 hrs
Setup 0.55 hrs
Run 1.75 hrs
Setup 1.95 hrs
etc
However I want to be able to establish whether the job was ON RUN or SETUP at each interval of my timeline. For example: if my time line was in 0.01 decimal minute intervals, my chart would look like this:.................
View 3 Replies
View Related
Dec 6, 2013
I have a date column (Column E: Date Entered) on my spreadsheet that I need to set conditional formatting on. There are two conditions:
1) 18 months from the date in the cell needs to be highlighted yellow
2) 24 months from the date in the cell needs to be highlighted red
View 6 Replies
View Related
Oct 2, 2012
I have a spreadsheet whereby process activities can be attributed to the different staff members who complete the activity. Each activity is on a different row and up to three staff can be assigned to each activity, so for example if a level one employee sorts the mail on four out of five days per week I would attribute 80% contribution to the task to the level one employee. If a supervisor sorts the mail on a Friday I would allocated a 20% contribution to that staff group.
My question is how do I prevent someone filling in the spreadsheet from allocating a combined contribution above 100% to any task. This could be for example either putting a number in greater than 100% into one of the allocation columns or a total across up to three different columns above 100%.
The columns where I assign the percentage contribution are E,H and K. I would like to generate an error which says something like 'Cumulative staff contribution per process activity cannot exceed 100%.
View 6 Replies
View Related
Jan 27, 2010
I need to show an information box e.g. "Initialising..." that I can show and remove without user interaction. I can't seem to find this using either a userform or msgbox.
View 5 Replies
View Related
Jul 19, 2009
Cell A1 is a past date. In cell B1 I would like how many months have gone by since todays date. eg. Cell A1 = July 07, B1 would = 24 months.
View 3 Replies
View Related
Jul 31, 2007
I am looking for a formula that will add months and return the year. E.g. if I add 1.05 and 1.07 I should get 3.01. i.e. 3 years and 1 month.
View 9 Replies
View Related
Oct 23, 2009
I am trying to sum up the total number of hours consumed on a particular activity within a specified period.
=SUMPRODUCT(($C38:$C176>=$B7)*($C38:$C176<=$C7)*($B38:$B176=$D5))
Unfortunately, the formula above gives me the total number of activity and NOT the total number of hours within a specified period. I attached the file I'm working on as reference.
View 2 Replies
View Related
Mar 21, 2014
I would like to make a scatter graph that will graph the attached. The score would be on the Y axis and the birth date would be on the X axis. This is simple to do by itself but what I would like to do in addition to this is to have the top 25% of the scores a single color, the middle 50% of the scores a second color and then the bottom 25% of the scores to be a third color. And if it is possible to have the ID visible when you move your cursor over a given dot in the graph. Currently when I make a scatter graph the X,Y coordinates show when I hoover the cursor over a dot.
View 7 Replies
View Related
Jun 11, 2006
How can i make a graph that will graph against time? lets say i have a bank balance like this:
1/2/2000 $500
1/3/2000 $600
3/12/2000 $400
there may be more than one entry on any one given day, or there may not be an entry for 2 weeks. How can i graph the running balance in a way that it will show the timeline just as a calendar year(or however long i selected) and the points are plotting according to their date, not just equally spaced out.
View 2 Replies
View Related
Dec 30, 2008
I want to use a line graph to display an amount over time - that's the easy part. On the other hand, I would like to have to group the lines based on a value.
A short example:
Imagine you own 3 different stores and you're selling oranges. So your table looks like this:
http://img179.imageshack.us/my.php?image=orangeshm4.jpg
Now I'd like to have one graph (3 different graphs won't work as the rows increase -I need to select the whole column as data source):
Date on the x axis,
Oranges sold on the y axis,
and one line per store (e.g. a green one for store A, a red one for B and a blue one of C, doesn't matter).
View 2 Replies
View Related
Jun 6, 2014
get the formula for the sum of last 3 and 6 values in a row.
Attaching the sample workbook for your reference
View 4 Replies
View Related
May 4, 2007
I have a spreadsheet which works out how much per annum our company makes. The total figure is in D2.
What I need is to make E2 work out how much it is for the current month e.g. if it's September, it would work out the monthly profit for 30 days.
View 9 Replies
View Related
May 16, 2007
I need to sum data from the most recent 12 months. For example, on June 1, 2007 I want to find the total from June 1, 2006 to June 1,2007. On the 1st of the next month, July 1, 2007, I want to calculate the total from July 1, 2006 to July 1, 2007. I don't need to keep the total from month to month (on July 1, 2007, June's data is obsolete.)
View 9 Replies
View Related
Nov 16, 2006
I am working on yet another worksheet. To simplify the task, let's say I have to columns Date and Amount (several hundered entries). I need to be able to sum the first 60 consecutive months, that do not equal 60. Is there a way to use built-in excel formulas to do so, or would I have to create my own formula. I'm trying to stay away from a macro that is run manually.
View 9 Replies
View Related
Jun 20, 2009
I input a month as a start date, and then want the next x number of cells to increment by one month based on the start date. I thought this would be easy using the preset DATE function but I can't get the thing to do what I want.
View 9 Replies
View Related
Aug 7, 2009
I am trying to find a way to sum 3 months together with the data given. (See attched file). Basically a quarter report. Right now the months are in text format (Jan, Feb, Mar, etc). They can be numeric instead of text if it is easier.
View 6 Replies
View Related
Jan 4, 2006
Is there a way to count the number of times an entree is entered in a spreadsheet.
example In row c i have dates entered
11/1
11/5
12/6
12/9
11/3
etc.
Is there a way to count the number of times that the month of dec was entered.
View 14 Replies
View Related
Dec 2, 2006
In column A I have dates set up in the 00/00/00 format. In cell B2 I want it to tell me how many 09s (Septembers) there are in column A.
View 12 Replies
View Related
Nov 9, 2009
I need to be able to calculate age in months, and round whatever remainder to the middle of the month (.5). I am calculating z-scores and percentiles for in a childhood obesity project. The DoB and Date of measurements must be converted to read anything from 142.0 to 142.9 as 142.5.
This value will be used to look up the the appropriate LMS (Box Cox, Median, and Standard Deviation) in another excel table. I have to be able to compute age in months so 142.5, 143.5, 144.5, 144.5 etc. It is just not rounding off to the nearest half month.
View 7 Replies
View Related
Mar 9, 2012
I am using Ron De Bruin's code for sending emails as below, where it says "your monthly totals for", I want it to insert last months month. ie. if i send the mail in March it should automatically insert February in the field
RDB_Mail_PDF_Outlook Filename, "ron@debruin.nl", "This is the subject", _
"your monthly totals for "March" " _
& vbNewLine & vbNewLine & "Regards Ron de bruin", False
View 3 Replies
View Related
