General Question

coelacanth's avatar

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

Observing members: 0 Composing members: 0

14 Answers

blueiiznh's avatar

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

coelacanth's avatar

I don’t see how that is relevant. I’m not trying to do statistics or analyze the sleep pattern, I’m trying to display data.

whitecarnations's avatar

@coelacanth The info provided by @blueiiznh Is suggestive of the fact that you want to mimic what is seen in the photograph which is indeed pretty intricate graphing. Are you looking for a much more basic set up? Please, let us know so we can help you accordingly.

coelacanth's avatar

I’m not sure what you’re talking about, can you be more clear? Basic set up of…?

@blueiiznh‘s response wasn’t helpful in that I have never heard of Analysis ToolPak (I use R for statistics), and the uses he mentions are, as far as I can tell, being a newbie of sorts, unrelated to my original query.

My question is how to mimic the image, yes. However that is done, I want to know, whether it is basic or not basic, and whether it uses this Analysis ToolPak or not. I’m new to Fluther, and wish I could edit my original question to remove the bit about Excel. Whichever program is necessary is fine. Thanks in advance!

prasad's avatar

Your graph looks pretty clustered as others have pointed out. It may have required data that goes down to hundreds of rows in Excel. If you haven’t got it, then see this simple stacked column charts and compare it with yours. I guess yours is also a stacked column chart. Another trick that might have gone into it could be the background; you can change the chart area and plot area colors.

And, if you are looking out for a stacked bar chart or graph, then refer this page : clustered and stacked column and bar chart.

Another trick is to select only one series, and change its fill color to no fill to make it invisible. That is used in making the Gantt chart in Excel.

Dutchess_III's avatar

I’m trying to figure out what the OP is asking too. I thought (s)he was basically asking how they made the chart shown in her detail…which is why I followed but bowed out of answering because that looked really deep.

Perhaps (s)he is just asking for a really simple chart showing what time the person went to sleep and what time the person woke up on certain days. Maybe over the course of a month or something. ? The chart in the detail shows sleep times from April to….Feburary?
I created a simple one charting a week…that’s really easy of course, but I don’t feel like loading it as a picture then loading into photobucket etc. etc. But I wonder if that’s what he or she is looking for.

whitecarnations's avatar

I realize we all were too focused on the fact that we thought the OP was trying to mimic the image. I guess they are looking for something very basic. X Start Time Y End Time ?

coelacanth's avatar

I am looking to recreate this exact chart.

Dutchess_III's avatar

Well, every time someone gives you a suggestion you say it “isn’t relevant” because you “haven’t heard of that program,” or “I don’t know what you’re talking about.” However, it sounds like if you want to get the answer to your question you’re going to have to learn about a program you’ve never heard of, or find out what they’re talking about.

Now, in order to recreate that exact graph you’re going to have to plug in the exact numbers that are used in that graph. Those numbers are analyzing sleep patterns. You may not have any interest in analyzing sleep patterns, but those are the numbers you’re going to have to use to recreate that exact chart.

So, from what I read above you’re going to have to load something called “the Analysis ToolPak,” even though you’ve never heard of it before (neither have I.) From what I’m seeing in @blueiiznh‘s response, it is a feature IN Excel, that you down load FROM Excel. Follow her directions, in the first post.

Then come back and they’ll help you some more because I haven’t the faintest idea what they’re talking about either.

BUT, if this was MY question, I would do exactly what they suggested and then I would figure out what they’re talking about. And they would help me. (Maybe!:)

Dutchess_III's avatar

@blueiiznh Hail. I’ll do it!!

OK. I loaded the Analysis Tools Pak. Now what? I don’t see it on the toolbar so what am I looking for now?

coelacanth's avatar

@Dutchess_III I did load the Analysis ToolPak.

To rephrase my previous statement: the uses of the AnalysisTool Pak @blueiiznh mentioned are “complex statistical or engineering analyses,” which are, as far as I can tell…unrelated to my original query. I don’t need to run any models, calculate any p-values, analyze any variance, I just want to display the data. But of course I obviously don’t know what I am talking about, which is why I’m here. It’s hard to search for something when you don’t even know what to search for.

whitecarnations's avatar

@coelacanth All that should matter is what you want to accomplish.

Dutchess_III's avatar

They’ll get you where you want to go. Just hang with it. I know baxic Excel pretty well, and the moment I looked at your example graph I knew it was way over my head. But…I’m willing to learn. I don’t plan to analyze anything. I just plan to plug numbers in and watch it display. Which is what you want too. ......Speaking of….WHERE ARE YOU GUYS!!!!! I don’t know what to do next!

coelacanth's avatar

It’s especially confusing because obviously sleep times usually spread between days, e.g. Monday 9PM to Tuesday 6AM, but the sleep times are displayed like this in table that is exported from the application:

Date,Sleep Time,Wake Time

Answer this question




to answer.

This question is in the General Section. Responses must be helpful and on-topic.

Your answer will be saved while you login or join.

Have a question? Ask Fluther!

What do you know more about?
Knowledge Networking @ Fluther