# Excel 2010 :: Create Graph To Show Times Of Use For Particular Sporting Activities On Particular Days

Mar 20, 2014
Excel 2010 - I need to create a graph that shows a week's use of a sportsground showing what sports were played, on which days and between which times. I thought I could show the times on the vertical axis, days on the horizontal axis and then the sports played in those times, however I'm unsure as to how to get the graph to recognise the times.

I've attached an example of some data and how I'd like to see it, I'm just not sure how I can do this using the chart set up!

Attached File : Graphs.xlsx

View 10 Replies
ADVERTISEMENT
May 24, 2013

I have created a excel file which stores attendance for my employees.

The format is like

Select month in one cell

select year in other cell

And from cell e8 to ai8 i have nos (1-31) represent no of days in a month:

a8 - 1

b8 - 2

c8 - 3

d8 - 4 like wise till ai8

Now I want a calender where user need to select the YEAR, and then MONTH and based on the above selection both days as well as date (not the month and year) should be displayed.

I am currently using this formula "=IF(ISERROR(--(COLUMNS($E8:$E$8) & "-"&$C$2)),"",COLUMNS($E8:$E$8))" for date and your vb code to hide the cells depending on days of months.

I need something like this

sun mon tue wed thur fri sat sun mon

1 2 3 4 5 6 7 8 9

View 3 Replies
View Related
Dec 12, 2012

I have a set of data (numbers) I want to include in a bar chart. The numbers appear fine in the table. When I create the chart and sets the data (the cells excel goes looking in to create the chart), the values in the cells are divided by 10 for some reason I can't understand.

I tried to create a new file and a new chart, and the issue does not repeat.

I do not know where to look in that specific file to prevent Excel from dividing every number by 10 when I create a chart.

View 2 Replies
View Related
Dec 16, 2008

I have been asked to create a spreadsheet that will contain three fields;

Date of placement (the day the person arrived)

Date of release (the above + 60 days)

Billable days for the current month

The first is simple, the clerk will enter the current date when the person arrives.

For the second field I am using:: =SUM(H5+(60),) (H5 is todays date, and will display the results in I5). When H5 is blank, I get the " #VALUE!" error in I5? Is there a more effective function to use?

For billable days, I am using; =SUM(J2 - (H5),) (J2 is simply the last date of the month; 12/31/09, and H5 is the placement date). I want to show the number of billable days in the current month. This will be repeated on 12 sheets (one for each month).

View 10 Replies
View Related
Feb 23, 2012

I have been trying to chart temperature differences over 10 day's time for six cities using a line graph. For some reason, the lines are all clustered at the bottom of my graph, with values of 0. My spreadsheet is accurate, without any blank cells. I'm using Excel 2010.

View 1 Replies
View Related
Jun 26, 2014

I have been given a task to create a line graph who has 10 categories and each category has 5 different values. I need to plot a line graph, so that those 10 categories should appear on the Y-axis instead of X-axis.

I am using Excel 2010.

View 8 Replies
View Related
Mar 2, 2014

I'd like to create a simple graph exactly like the one on the picture, but for the life of mehow to do this on Excel 2010.This is the data I have:

Seperation First target Second target

0 59.00% 0.00%

2 64.28% 40.62%

4 62.68% 48.99%

6 60.81% 65.83%

8 61.82% 70.21%

View 6 Replies
View Related
Apr 11, 2014

I am using excel 2010 and I am trying to find a formula whats going to give me added break with a set time but anything over a set time doesn't. I want it over 10:58:00 and under 11:32:00. I've got the numbers and tried with a formula but all whats happening is that all the data is adding 30mins break to the end time.

The sheet is using live times and data so the start times vary as do the due time.

View 1 Replies
View Related
Aug 27, 2013

I have a sorting question in Excel 2010. Attached is an example workbook with a simplified version of the situation.

I want to sort a table multiple times. I have a table with part numbers and alphanumeric locations (Row, Shelf, Bay, Slot). I have formulas that divide up the location into 4 separate columns to be able to sort.

The first sort I do is by location, which I can easily achieve. The issue I have is sorting AGAIN by part number, while keeping the original sort somewhat intact. If a part number shows up multiple times (i.e. in two DIFFERENT locations), the Nth instance might show somewhere down the list.

Is there a way to sort my table to where you keep it in location order WHILE accounting for duplicates, which I would want grouped together in location order? Please see attached file : SortExample.xlsx

View 8 Replies
View Related
Apr 2, 2014

When I run macros usually they're fast, but occasionally will run very slow. An example macro I have is pasted below. It's just a simple macro that pastes months. If I am pasting on top of a cell that contains a month it pastes the rest of the months that follow.

Most of the time this macro runs very fast, but occasionally it takes about 1-2 seconds to run, and it is a very simple macro! It is not macro specific, as all my macros will be slow. I''m using Windows 7 with Excel 2010. I'm only using 23% of my CPU and 4.5GB of my 16GB of RAM, so I don't think it's a hardware thing.

Is there some kind of condition that occurs that will make excel run macros slower?

[Code] .....

View 4 Replies
View Related
Jan 7, 2014

I am in the process of setting up some graphs. The graphs will show the last 6 months of data so they move as each month is goes. I saw a slick way of doing this using the count function but this did not quite fulfill my needs. What I was looking for is to be able to input the start month in a cell. The cell would be part of the function within the formula. I created a simplified version of the spreadsheet below.

Spreadsheet.jpg

Then I created my names using the ctrl-F3

Names.jpg

I then created the graph I wanted and wanted to use the formula =SERIES(Sheet1!$B$3,!chtCat,!chtIssuesReported,1). This kept getting an error indicated nothing really. It basically says there is something wrong with my Series function. I have a working version of a similiar worksheet I have been basing my entries on. They look almost identical but mine is failing. I also created a new file and tried this and it still fails. I can run the formula evaluator within Excel 2010 against the !chtCat and !chtIssuesReported names and they both return the correct value (which equals areas on the spreadsheet). I have also tried to enter the spreadsheet name and a tab in front of the names to get them to work and still get an error. Basicall I am trying to create the graph below (this grpah is using the hard coded locations)

Graph.jpg

View 2 Replies
View Related
Dec 8, 2011

did in [URL] but my issue is complicated by not knowing what cell I need to move the graph to.

I am using Excel 2010 and I am a realitive novice at writing VBA code.

In My spreadsheet, I have a list of properties and some related cost info. From week to week, the number of properties varies. Some days I will have 6 properties and others I could have 100. Because of this, I need to make all of my references relative to other cells. I am having trouble repositioning the graphs that I have created from the data to be 2 cells below the label I have created for the graph (which is a merged cell covering Columns B:I on a row 3 rows below the last property in the report.

So far, I have:

Dim r1 As Range, r2 As Range, GraphRange As Range

Cells(2, 1).Select

Selection.End(xlDown).Select

[Code]....

View 1 Replies
View Related
Nov 9, 2012

I have a spreadsheet with 6 months of data in one row. the dates are from A3 (Jan 1) to FY3 (Jun 30). The data is in range A4:FY4. The data is a "$" (without quotes). The $'s are entered randomly during the 6 month period. I need a formula to determine the days between the last occurrence and the next to last occurrence of the $. Example spreadsheet shows the $'s on Mar 28 and May 5 as the last two. The spreadsheet is attached. I am using Microsoft Office Excel 2010.

View 6 Replies
View Related
Apr 8, 2013

I am using Excel 2010. The template only has 5 working days in it, but I need to set 6 working days (Saturday is also working day). Wondering, how to get this working without spoiling the functions. Also the date format is in US , need to change to UK without disrupting the Formula/Functions.

View 12 Replies
View Related
Jan 5, 2013

Working on Excel 2010

Need a formula to calculate the number of leave days.

C3 - Start Date, e.g. 01/07/2011

D3 - Calculation date, e.g. 31/12/2012

E3 - Number of months - ??????? Forumal need from 01/07/2011 to 31/12/2012

F3 - Days per month, e.g. 1.25

G3 - E3*F3

View 6 Replies
View Related
Jul 2, 2014

I work for a freight company and have been trying to create a macro for a spreadsheet that I have to create every single day. I pull a report from a program called the AS400 and it sends me an excel spreadsheet with information about certain shipments such as close time and arrive time (which are in military time such as 16:00) along with driver names.

Anyways what I need to accomplish is to highlight the entire rows font in red if the driver arrived an hour or more past there close time. When I get the spreadsheet the military times are not showing in the HH:MM format under format cells. So I select the HH:MM format and try to do a formula such as Arrive time cell (M1) - close time cell (L1) to get the time difference it shows as #VALUE!. I've tried to convert it to different time formats and nothing works. The values just stay the same and will not allow me to do calculations with them.

At first I thought this was because the program was sending those values as text. I tried to use the date>text to columns>finish button on the columns but did not work. I've tried to remove the":" then use the HH:MM cell format but still wont work. I've even tried a time value formula to try to convert the values such as =TIMEVALUE(LEFT(A1,2)&”:”&RIGHT(A1,2)).

But nothing works it will not allow me to add or subtract from the time values no matter what I do. I am running excel 2010 on Windows XP the english version.

View 9 Replies
View Related
May 21, 2014

Excel 2010 and the camera function.

I have been using it to take a picture of a graph, pasting to an alternative sheet within the same workbook, and renaming the picture by a defined name. S by selecting the names from a drop down list the picture will select various different sized graphs defined within my drop down.

What I am experiencing is when I initially do this the pic works great and resizes automatically with each selection, however the next day some of the pictures resize and some do not.

Is this a glitch within excel or am I missing a setting which will resolve this?

View 1 Replies
View Related
Jul 5, 2012

Using Excel 2010.

I am trying to come up with a formula that will return a total average from two columns of dates with criteria. The range will need to cover an entire column as my data is continuously growing and the criteria would have to limit the start date to each month. I have tried

=AVERAGEIFS(DAYS360(A:A,B:B),A:A,">5/1/2012",A:A,"5/1/2012",A:A,"

View 2 Replies
View Related
May 1, 2012

I have a sheet that contains the following columns:

Invoice, Document #, Date, PO #, Part #, Part Description, Quantity, Net Amount

Based on the quantity in the row I need to copy the row, and insert it n-1 times. So if the quantity is 5, I need to copy and insert the data below the original row 4 times for a total of 5 rows of data.

I plan on firing the macro with a button as the data will change month to month.

Using Windows 7 and Excel 2010

View 2 Replies
View Related
Jun 18, 2012

I need excel 2010 to automatically save at 09:30 and 19:45 every day monday-friday. Also need the file name saved to reflect the time and date it was saved - if possible.

My PC locks after 10 minutes of inactivity - unfortunately this has to happen because of where my PC is situated.

View 1 Replies
View Related
Aug 28, 2012

I work with a team of users that are continually publishing reports in Word that contain charts and graphs copy and pasted from Excel into Word 2010.

We have a custom script that leverages a PDF engine to automatically convert .doc files to .PDF files that we distribute electronically to our clients. This all works great, but only if all my users select 'paste special' and Enhanced Metafile Format when adding their excel charts into our reports. Most of these people aren't tech savvy, and I'm havin ga hell of a time getting them to follow this workflow and am hoping there's a way in Office 2010 to select the default paste from excel into word when the content is a chart.

It seems like the default paste from excel is an embedded chart/graph that you can then further manipulate each component of the chart in Word; the default doesnt' paste an actual image. I am assuming the pdf renderer is using a lower resolution .PNG version of the image and when these are scaled for print and or pdf, they look like crap.

Is htere anyway I can automatically change the default paste format for the chart from excel into word to be an EMF/EMV (enhanced metafile?) Either thorugh the registry or some other saveable setting?

View 1 Replies
View Related
Feb 26, 2014

I need conditional format in column Q which highlight in red, any date over 14 days old.

This column also contains texts (non-dates) and these need to be left alone.

I've experimented with a few bits of formula I've found online, but nothing has worked . .

I'm on Excel 2010.

View 3 Replies
View Related
Jan 23, 2014

I have to dig out data for all employees first entry and last exit for two months. My raw data is in sheet 1 as under:

LAST_NAME

FIRST_NAME

EMPLOYEE

[Code]...

I am using excel 2010

View 8 Replies
View Related
Jan 20, 2012

Excel 2010 Higher than past average formula?

Im using Excel 2010 and want to make a formula that will High light the number when it exceeds the past 30 days average. My information is listed vertically in row F..

View 3 Replies
View Related
May 7, 2012

I am using Excel 2010. I am tracking client orders on a spreadsheet. I would like to offer a 60 percent rebate on revenue from orders placed between the first order date and 30 calendar days thereafter. On day 31 and continuing through day 60, I would like to offer a 40% rebate. On orders placed on day 61 through 90, I would like to offer a rebate of 20%. From all of the orders placed by clients who start ordering on different dates, I need to sum their order revenue in these three time periods. I have the individual client order data arrayed on my spreadsheet - one order per row.

I am capturing the unique client ID number (Column A), the order date (Column B), and the associated revenue (Column C). Keying off of their unique ID number, I would like to calculate the sum of how much revenue is generated in calendar days 1 through 30, days 31 through 60, and days 61 through 90 from the very first order date from any given client. The start date can be any date in the month, so I can not rely on any calculation that uses the calendar month. Orders are not necessarily placed every day. Multiple orders may be placed on any given day, and then no orders may follow for many days afterward.

View 1 Replies
View Related
Feb 13, 2013

Im having a hard time creating the formula to calculate the min number of employees to complete a number of jobs that come in each day and need to be finished in 18 days or less.

Data that I have:

Forecast of the number of jobs for 251 days ( jobs range from 10 -80 per day) Each job needs to be finished in 18 days or less we need to staff a fixed number of employees for the whole year each employee can complete 4 jobs per day no weekends

i have excel 2010 and crystal ball

View 1 Replies
View Related
Aug 1, 2013

I'm having trouble defining the time overlaps on continuous days for the varying results of the runs for my simulation.

For the following data set, without counting overlaps there are 18 total spare requirements, but if I take into account their overlaps in their duration there should be a total of 11 per day. For example in row 4 this event overlapped in the same day with the event of row 5 so both had only 2 overlaps as a result (So there is not possible to be 1 as an answer for overlap, there is only from 2 to "n" amount or 0).

But if an event overlaps with more than one in their duration the result would be their maximum overlap during this time frame.

So then I have for each event an Starting date, starting time, duration, ending date and ending duration.And for each day I would need the total amount of overlaps occurred for the duration of each event and from those I would take their maximum amount of overlaps occurred per day. To obtain their real requirement as shown on the file.

The manual procedure I'm using looks like this for the first day: (Graphical representation)

Event 1 occurs from 17:02 to 20:29 and only overlaps with Event 3, so it's 2

Event 2 occurs from 20:38 to 23:38, also only overlaps with Event 3, then its also a 2

For Event 3 in its whole duration only overlapped with Even 1 and Event 2, one at a time so its maximum overlaps where only 2.

And that's what I'm using so far to determine these amounts but since is a simulation, I would end up with several data from each run and this method would be too long. That's why I would need this template to paste data for each run (15 days) and obtain my results faster.

View 1 Replies
View Related
Dec 19, 2013

I have a single work book with 8 sheets (I am using Excel 2010 BTW) and I am trying to find a total of times a word appears across all the sheets in column "C"

I found this formula on another thread. =SUM(COUNTIF(INDIRECT("Sheet"&{1,2,3}&"!C1:C1000"),"="&H3)) with an example. I made the changes that I needed for my purposes

This worked but only after I renamed the sheets to Sheet1, Sheet2, etc.

Is there a way get the same results from the above formula if all the sheets are named after our reps? Example: sheet1 is named Dan, Sheet2 is Nick, etc?

View 2 Replies
View Related
Feb 9, 2014

How do I enter a formula in excel 2010 that will give the total amount of times each number is in this group. Example : how many times (total) the number 12 showed up , how many times the number 27 showed, and so on for each number that is in the entire group of numbers, from 1 to 80 .

Here is the page I will copy and paste into a workbook sheet from the internet that i want to evaluate the times each number was called.

Very new to all this , I am a bit aged and need not to learn excel A to Z, just need to know what correct statements /formulas have to be entered to do what i desire.

I am only interested in the total count of the small bold numbers 1 to 80, each single digit 1 to 9 and double digits 10 to 80 will be in their separate cells. The large bold three digit numbers and dates/times will have to be erased (manually) before the calculation takes place.

298

2/9/2014 12:28:02 PM

37

77

[Code]....

View 6 Replies
View Related
Mar 28, 2014

I have this excel that look like this:

A1, B1, C1 contains an image with the numer 1, 2 and 3.

D1 is a cell where you can put only the number 1 2 and 3 (alert if you insert something else)

E1 have to contain the number in the D1 written with letters (I did this with the formula: =IF(D1=1;"One";IF(D1=2;"Two";IF(D1=3;"Three";"Wrong Imput")))

F1 have to contain the image from the A1, B1, C1 corresponding to the number in D1

Now, how do I do this ? I read an article here, on this forum, about doing this. I know how to copy an image from A1, B1, C1 in F1, but I don't know how to make a formula to do this.

To copy an image from A1, B1, C1 I do this:

- I copy the cell (F1)

- I hold Shift key

- I go to Start -> Paste -> Click the little arrow -> Last option (Translated from my language I think It's Linked Image) -> I switch the formula in that cell to =A1 or =B1 or =C1 -> The image appears.

I really want to know how to do that thing. I saw that you can not use an IF formula in the linked image cell so I need another option.

By the way, I attached the excel. If you will open it, go to Item2 Spreadsheet. I'm using Excel 2010 now.

View 2 Replies
View Related