How can I create this graph in Excel with a table of start and end times?

How can I create this graph in Excel with a table of start and end times?
by

1 Answer

Answer :

answer:That is pretty advanced graphing. If you need to develop complex statistical or engineering analyses, you can save steps and time by using the Analysis ToolPak. You provide the data and parameters for each analysis, and the tool uses the appropriate statistical or engineering macro functions to calculate and display the results in an output table. Some tools generate charts in addition to output tables. Load the Analysis ToolPak Click the File tab, click Options, and then click the Add-Ins category. In the Manage box, select Excel Add-ins and then click Go. In the Add-Ins available box, select the Analysis ToolPak check box, and then click OK. If Analysis ToolPak is not listed in the Add-Ins available box, click Browse to locate it. From Excel Help
by

Related questions

How can I recover large text strings Excel changed into # symbols?

Description : How can I recover large text strings Excel changed into # symbols?

Last Answer : I think I’d use a simple text program like Notepad to open the files and see if the URLs are stored in the file. If not, you are well and truly screwed would be my guess.

How can I apply an excel formula to every seventh line?

Description : How can I apply an excel formula to every seventh line?

Last Answer : answer:I just did this: =IF(MOD(ROW(),7)=0,SUM(A1:A7),0) and it works. your formula doesn’t have anything to do if the mod result comes up false.

Del.icio.us again: add to old 2005 account or start fresh?

Description : Del.icio.us again: add to old 2005 account or start fresh?

Last Answer : Start fresh.

What factors do YOU think have contributed to the increasing divorce rates since the 70's?

Description : What factors do YOU think have contributed to the increasing divorce rates since the 70's?

Last Answer : The slow realization by women that they are people, too. That they deserve happiness and fulfillment, and that those things don’t happen just because they’re married. That they can be self sufficient, independent, and strong on their own.

Where can I find a list of data connections?

Description : Where can I find a list of data connections?

Last Answer : I’m unclear on your question. Are you trying to find the technical specifications for these things? If so, I’d start with google vga technical specification to get something you can start to work with.

Is there any data on costs/losses associated with non payers in the health care system?

Description : Is there any data on costs/losses associated with non payers in the health care system?

Last Answer : In the medical literature there are lots of articles that try to quantify the cost associated with non payers in the US health care system. Unfortunately it comes down to interpretation of statistics ... sense of other peoples statistics. Anyhoo have a look at this article from Health Affairs 2008.

Twisted pair or Coaxial (kind of technical, see details)

Description : Twisted pair or Coaxial (kind of technical, see details)

Last Answer : answer:There are economics that get into the picture here, too. The cable company will have bandwidth caps (300gb/month) whereas the fiber provider is less likely to. At a distance of 1000 feet, coax ... which wires tend to expand. Will you see a difference in speed at that distance? Probably not.

How do they make sure the signals being sent by Voyager get to earth in a state we can read?

Description : How do they make sure the signals being sent by Voyager get to earth in a state we can read?

Last Answer : answer:Every datacom (even on earth) has some sort of error correcting mechanism. In the early days they used parity checking, but now there are far more sophisticated ways to calculate a ... on your cell phone, your internet connection, and even your telephone, except much more sophisticated.

How can I recover data from my deleted Facebook account?

Description : How can I recover data from my deleted Facebook account?

Last Answer : answer:Download your information This does require that your facebook account be active, though. They do maintain your data for at least 30 days, so if it hasn't been that long since you deleted your ... 're not going to get things like usage/marketing data on you or other statistical data on you.

Would it be at all possible to recover data of a deleted Facebook profile?

Description : Would it be at all possible to recover data of a deleted Facebook profile?

Last Answer : If you reinstate your account it should just bring (most) of it back up, instantly.

What is your data backup system?

Description : What is your data backup system?

Last Answer : answer:My mom uses Carbonite, which I believe just came in very handy after she got a virus and lost the contents of her hard drive. I have not used it personally, though, so I can't speak for it. Myself ... ago and had to wipe my HD. Thank god I had that 150 gig external drive to save all my stuff!

Isn't "mad science" actually "mad engineering"? Can you find me an example of "mad science" in popular media?

Description : Isn't "mad science" actually "mad engineering"? Can you find me an example of "mad science" in popular media?

Last Answer : I think you're looking in the wrong place mad science is every time plastic surgery is performed every time a commentator uses fiery retoric to incite people whenever religious NUTS use a god ... shit Oh surely you can evoke Pavlovian responses from people, are you looking for hard science?

Can you recommend a site for online questionnaires?

Description : Can you recommend a site for online questionnaires?

Last Answer : I’ve used form assembly before, and it has worked well for me.

Anywhere I can get current U.S. birth rate stats by ethnic group?

Description : Anywhere I can get current U.S. birth rate stats by ethnic group?

Last Answer : This page from the Statistical Abstract of the United States 2010 will do it for you. Just be aware that the data from the current census are not tabulated yet so the information will be somewhat older.

Where can you find a Wal-Mart Growth Chart?

Description : Where can you find a Wal-Mart Growth Chart?

Last Answer : answer:Yahoo! Finance and Wal-Mart Corporate website

Who has experience resurrecting a harddrive with a seriously fsck'ed up FAT?

Description : Who has experience resurrecting a harddrive with a seriously fsck'ed up FAT?

Last Answer : Sorry Fenris, the only solution I can offer after all you’ve tried is advanced data recovery from a company like Ibas. It’s not cheap tho:-(

Windows software for making nice graphs?

Description : Windows software for making nice graphs?

Last Answer : Microsoft Excel.

Where can I find a mac utility or terminal script to read the contents of a smart card?

Description : Where can I find a mac utility or terminal script to read the contents of a smart card?

Last Answer : You “found” a reader, and then you “found” a card. I know, ask at your local Police station – Police Officers can be very helpful when dealing with “found” items. (The data is proprietary and encrypted – if you don’t have the appropriate software it won’t do you any good.)

Anyone with FlexPay from T-Mobile and a Blackberry, please help!

Description : Anyone with FlexPay from T-Mobile and a Blackberry, please help!

Last Answer : I don’t believe there are any carriers who will sell you a data plan without a voice plan. It’s their job to suck as much money out of you as possible.

Is 100mb a good data plan for 19.99 on AT&T?

Description : Is 100mb a good data plan for 19.99 on AT&T?

Last Answer : No because 30 a month will get you unlimitted data. Some phones are actually only 20 a month like the first iPhone.

What is the average age of fluther users?

Description : What is the average age of fluther users?

Last Answer : I’m 27! Kinda young, I know… LOL!!

What exactly is push data, and what does it push?

Description : What exactly is push data, and what does it push?

Last Answer : I think you're right. Push data transfers automatically to your phone. If you have an iPhone and a MobileMe account, calender and contact info that you update on your desktop are automatically sent to your ... to launch the mobile app, like Mail or Calender, and have it ask the server for updates.

Ideas for using a database? Any good opensource ones?

Description : Ideas for using a database? Any good opensource ones?

Last Answer : answer:I'm not sure you have a good understand of what a database is A database is just a way of storing and structuring data that can be retrieved using a query language (typically SQL). ... MySQL or PostgreSQL. For what you are attempting to do, either one should be more than sufficient.

What is the breakdown of expenses for low-income families?

Description : What is the breakdown of expenses for low-income families?

Last Answer : There is no single answer to this obviously. Here is a report with several data points. Start with Figure 2.

What program will allow me to burn DVDs (or CDs) in batch mode?

Description : What program will allow me to burn DVDs (or CDs) in batch mode?

Last Answer : Well, I actually answer this time seeing as that I forgot to post it last time round. What I was going to say, surely it's cheaper and much more efficient to buy an external HDD and backup onto that surely ... for a long while may turn something up, I'll see what I can find if anything at all :S

What is a Processing Rule?

Description : What is a Processing Rule?

Last Answer : Every DP service will have a processing policy and every policy will have processing rules.  Request rule to handle request messages  Response rule to handle response messages  Error Rule to handle error scenarios

Mention The Different Types Of Data Transfers Possible In The 8085.?

Description : Mention The Different Types Of Data Transfers Possible In The 8085.?

Last Answer : Answer :The various types of data transfer operations possible are: Data transfer is possible between two registers. It is also possible between a memory location and a register. Also it can occur between ... . In reality data is never transferred it can only be copied from one location to another.

Mention The Steps In The Interrupt Driven Mode Of Data Transfer.?

Description : Mention The Steps In The Interrupt Driven Mode Of Data Transfer.?

Last Answer : Answer :The steps followed in this type of transfer are as follows: The peripheral device would request for an interrupt. The request acknowledgement for the transfer is issued at the end of ... coordinates by the ISS. Again the Interrupt system is enabled and the above steps are repeated.

What are the hydraulic data required for designing a pump capacity?

Description : What are the hydraulic data required for designing a pump capacity?

Last Answer : Ans: Following are the hydraulic data required for designing the pump capacity a. The depth of the Bore or well (suction height/ below ground level) b. The delivery light. c. The yield of the Borewell. d. The horizontal distance of the pumping from bore well where planned to deliver.

Find out number of data lines required to interface 16 LEDs arrange in the 4 x 4 matrix form.

Description : Find out number of data lines required to interface 16 LEDs arrange in the 4 x 4 matrix form.

Last Answer : 4+4=8, eight lines are required for 4x4 matrix of 16 LEDs

Data logger and its application

Description : Data logger and its application

Last Answer : Data logger and its application:- A data logger or data recorder is an electronic device that records data over time or in relation to location either with a built in instrument or sensor ... Testing (including crash testing) 8) Motor Racing 9) Monitoring of relay status in railway signalling.

What is the need of data converters? List specifications of DAC.

Description : What is the need of data converters? List specifications of DAC.

Last Answer : Need of data converters:  It is often necessary that before processing the analog data, by a digital system, it should be changed to an equivalent digital form. Similarly, after processing the data, it ... 4. Temperature sensitivity 5. Settling time 6. Speed 7. Long term Drift 8. Supply rejection

Calculate the size of memory address space for a 16 bit data and 20 bit address bus.

Description : Calculate the size of memory address space for a 16 bit data and 20 bit address bus. A) 1 MB B) 2 MB C) 3 MB D) 4 MB

Last Answer : Calculate the size of memory address space for a 16 bit data and 20 bit address bus. A) 1 MB B) 2 MB C) 3 MB D) 4 MB

Which unit holds data permanently?

Description : Which unit holds data permanently?  (A) Input unit (B) Secondary storage unit (C) Output Unit (D) Primary Memory Unit

Last Answer : Which unit holds data permanently?  (A) Input unit (B) Secondary storage unit (C) Output Unit (D) Primary Memory Unit

Which of the following is the product of data processing:

Description : Which of the following is the product of data processing:  (A) Information (B) Data (C) Software programme (D) System

Last Answer : Which of the following is the product of data processing: Information 

Explain data transfer mechanism in I2C protocol.

Description : Explain data transfer mechanism in I2C protocol. Compare it with CAN and USB protocol based on bit rate and area of applications.

Last Answer : I2C (Inter-Integrated Circuit): I2C stands for Inter-Integrated Circuit. I2C is a serial protocol. It was developed by Philips Semiconductor. I2C bus have two communication lines. One is serial data ( ... Mbps this is used for lower speed devices. Using USB we can connect upto 127 devices.

What is Data Acquisition System (DAS) ?

Description : What is Data Acquisition System (DAS) ?

Last Answer : .embed-container { position: relative; padding-bottom: 56.25%; height: 0; overflow: hidden; max-width: 100%; } .embed-container iframe, .embed-container object, .embed-container embed { position: absolute; top: 0; left: 0; width: 100%; height: 100%; }

How in the world do I graph this on Excel?

Description : How in the world do I graph this on Excel?

Last Answer : Nevermind. . . my boss realized this too is complicated and said screw it – we just drew it by hand. Still, feel free to share a solution.

How to creat a simple x-y line graph using excel 2007?

Description : How to creat a simple x-y line graph using excel 2007?

Last Answer : i don't know a ton about 2007, but in 2003 (back when office seemed to work properly, for office), selecting the data to chart FIRST makes things a lot easier. if i recall from what i have used ... they put the chart types. run the wizard, and they might appear up there once the data is selected.

How do I add several graph lines into one graph in excel 2007?

Description : How do I add several graph lines into one graph in excel 2007?

Last Answer : If I understand your question correctly, I would paste the second data set into a column next to your first data set, and then expand the graph to include the second column. If Excel won’t let you do this, the spreadsheet feature in Google docs definitely will. Their graphs are super intuitive.

Can you help me think through how to set up an excel spreadsheet to create some graphs?

Description : Can you help me think through how to set up an excel spreadsheet to create some graphs?

Last Answer : Excell graph tutor.

Anyone know how to use excel to create tax spreadsheets but on mac numbers?

Description : Anyone know how to use excel to create tax spreadsheets but on mac numbers?

Last Answer : I'm not certain of exactly what you're asking here (and I don't do Excel on a Mac in any case), but it seems that you want to have a cell - that is, a single cell - to calculate and add ... original value + the amount of the first tax, then the formula will be different, but you'll have to say so.

Could you give me a couple of tips to create a MS Excel column chart to compare grades of Test 1/Test2?

Description : Could you give me a couple of tips to create a MS Excel column chart to compare grades of Test 1/Test2?

Last Answer : What kind of results are you looking for ? I.e. what are you comparing between test1 and test2 ? Also, I’m not sure I understand what are ‘value points’ ? And when you say ‘group all the students’ do you mean counts of students that got that level of score on the test?

Displaying dates on a PC using excel 2010 to create charts and graphs?

Description : Displaying dates on a PC using excel 2010 to create charts and graphs?

Last Answer : Never mind. I figured it out. If anyone else needs to know this is how you do it: you must enter the date in a different format. I originally entered the date by writing September 1 etc the computer ... entered 9/1 , 9/5 etc and this resulted in a simple display of the dates I enetered only!

What do you use to create a chart? 1) Pie Wizard 2) Excel Wizard 3) Data Wizard 4) Chart Wizard

Description : What do you use to create a chart? 1) Pie Wizard 2) Excel Wizard 3) Data Wizard 4) Chart Wizard

Last Answer : 4) Chart Wizard

How To Extract Excel Table From PDF?

Description : How To Extract Excel Table From PDF?

Last Answer : There are many conversion tools and methods, which are generally divided into two types, online web page conversion and converter conversion. Let's talk about the two conversion methods, ... re-converted after refreshing or accidentally closing the webpage. Therefore, we can operate the convers

What function searches for a specific value in a table and returns that value's relative position from the table not the value itself in Excel?

Description : What function searches for a specific value in a table and returns that value's relative position from the table not the value itself in Excel?

Last Answer : The MATCH function.

What in a pivot table dialog box can change Excel report to layout mode?

Description : What in a pivot table dialog box can change Excel report to layout mode?

Last Answer : What is the answer ?

What excel features can I use to find easily to locate rows in a table that meet my criteria?

Description : What excel features can I use to find easily to locate rows in a table that meet my criteria?

Last Answer : Need answer

How can you identify a unit rate or constant of proportionality in a table In a graph In an equation?

Description : How can you identify a unit rate or constant of proportionality in a table In a graph In an equation?

Last Answer : In a table, divide a number in one column by the correspondingnumber in the other column. In a graph it is the gradient of theline. The equation, for the variables X and Y will be of the form Y= mX and the constant of proportionality is m.