Have Rep, will trade for graph construction

[Turtle]

As the title suggests, I need a graph made & I will give rep to anyone who will make it for me. To qualify, I have tried relentlessly to do it myself with the Quatro Pro that is on this machine, and failed miserably. No one in my household has a clue and it's not my machine so I can't add software or modify anything.

Below is (some of) the data I collected. I want a simple bar graph for each column & labled with associated dates. This data is taken from the USGS site and records the number of earthquakes above a certain magnitude; for example the first entry shows that on 5/29/06 there were 199 quakes worldwide above 2.5 and 547 quakes in the US above 1.0.

This concludes this irregularly sceduled appeal for help. Please return your seats to the upright position.

Date_____World_US
5/29/2006|199|547
5/30/2006|209|541
5/31/2006|187|534
6/01/2006|201|566
6/02/2006|214|611
6/03/2006|205|606**1st Quarter Moon
6/04/2006|182|572
6/05/2006|174|564
6/06/2006|170|599
6/07/2006|176|590
6/08/2006|177|581
6/09/2006|181|609
6/10/2006|176|567
6/11/2006|165|542**Full Moon
6/12/2006|152|527
6/13/2006|142|549
6/14/2006|216|655
6/15/2006|241|705
6/16/2006|269|713
6/17/2006|277|711
6/18/2006|294|715**3rd Quarter Moon
6/19/2006|294|708
6/20/2006|312|746
6/21/2006|262|682
6/22/2006|226|647
6/23/2006|210|632
6/24/2006|197|596
6/25/2006|186|557**New Moon
6/26/2006|164|510
6/27/2006|173|514
6/28/2006|180|514
6/29/2006|186|517
6/30/2006|173|552
7/01/2006|166|559
7/02/2006|195|609
7/03/2006|235|661**1st Quarter Moon
7/04/2006|225|682
7/05/2006|207|683
7/06/2006|213|717
7/07/2006|221|670
7/08/2006|232|655
7/09/2006|247|662
7/10/2006|235|666
7/11/2006|248|678**Full Moon
7/12/2006|254|705
7/13/2006|262|722
7/14/2006|256|762
7/15/2006|251|754
7/16/2006|181|654
7/17/2006|167|631**3rd Quarter Moon
7/18/2006|162|579
7/19/2006|206|577
7/20/2006|210|570
7/21/2006|215|559
7/22/2006|214|555
7/23/2006|198|533
7/24/2006|179|504
7/25/2006|177|509**New Moon
7/26/2006|178|529
7/27/2006|164|544
7/28/2006|175|566
7/29/2006|171|545
7/30/2006|177|537
7/31/2006|165|526
8/01/2006|169|559

[InfiniteNow]

Originally Posted by Turtle

As the title suggests, I need a graph made & I will give rep to anyone who will make it for me.

No rep required. You simply must check out the "Text to Columns" functionality in Excel. A life saver for sure. Brotherly Conduct of the You're a good dude kind.

Cheers.

For my friend Turtle.xls

[C1ay]

Here's a couple of alternate comparative views, no rep required...

[CraigD]

Attached is Microsoft office's table wizard's effort, as a .gif file. Not very imaginative, but seems to get the point.

There may be free web apps that can make such graphs equally quickly, but I don't know of any. Docs.google.com doesn't yet, but promises to.

... way too slow, it seems - this biz graphics stuff isn't really my bag, but I enjoyed the excuse to try it

[Turtle]

You guys rock! Apparently I must spread the wealth a bit before getting to Craig & InfiniteNow, but I got a mind like a #4 bear trap for details like this and I got your rainchecks penned.

I'll try the xls file in my Quatro as it does open some, but it doesn't transfer all features and the graph may not display. Speaking of this not being my machine, I had to wait for the owner to hit the sack before I could check for replies (man you guys are not only good, you're fast! ), so I cooled my heels by going back to what I know which is pencil & paper. A slide rule makes a handy straightedge too.

Anyway, I started with my earliest data, which was not part of what I gave so at least I'm not repeating. Here's what I got and I'll figure a way to append it with what you fellas worked up. Dare we say the peaks are at syzygies?

PS Gaps in my graph are dates I didn't take records.

[C1ay]

Originally Posted by Turtle

Anyway, I started with my earliest data, which was not part of what I gave so at least I'm not repeating. Here's what I got and I'll figure a way to append it with what you fellas worked up. Dare we say the peaks are at syzygies?

PS Gaps in my graph are dates I didn't take records.

Have you checked the National Earthquake Information Center for your missing data? I think you'll find a wealth of information there to support your endeavor

[LJP07]

Why bother asking for rep.? This site aims to discuss and help peoples problems whatever they might be, if people feel they must give you rep. they will give. People would have helped you anyway. No Offence though

Maybe you knew they wouldn't give rep. as well? There too nice!

[Turtle]

Originally Posted by LJP07

Why bother asking for rep.? This site aims to discuss and help peoples problems whatever they might be, if people feel they must give you rep. they will give. People would have helped you anyway. No Offence though

Maybe you knew they wouldn't give rep. as well? There too nice!

? I'm a little unclear on the first sentence, as I wasn't asking for rep for myself. I posted the list and asked for help months ago in the Earthquakes thread and received no response so I thought I 'd try again with some added incentive. The simple fact is I wanted to study the graph and not having it made for problems.

I give rep with no expectation of return.

I was able to open InfiniteNow's xls file in Quattro and both the data & the graph loaded. I have made a copy & renamed it so I can experiment & try to figure out how it's done.

A cursory glance of the graphs seems to have the peaks following the Full Moon by about 5 to 7 days, but the New Moon seems to be at troughs. Not what I expected, but I need to get all my data in for a good look-see. I have about 8 months of daily entries & will get it all in a single file ASAP.

Many thanks for the help all!!! You are indeed too nice.

[LJP07]

Originally Posted by Turtle

? I'm a little unclear on the first sentence, as I wasn't asking for rep for myself.

Actually your right, I made an error.

[CraigD]

While lamenting the lack of a well-known, nice, public graphing tool for these kinds of needs, it occurred to me that we all of us have pretty nice rendering tools at our fingertips: our html browsers!

Borrowing a trick from imdb.com's ratings graphs, I've attached Turtle's data imbedded within table tags in a small html file. Anyone with patience and a text editor can edit it to add/remove rows, change values, or fiddle with its format.

I borrowed a little more from imdb than its technique - the gray and blue bars use a couple of its tiniest graphics files: http://i.imdb.com/neutral.gif and blue.gif. If you want the TEMP.html to render when you don't have an internet connection (or just feel faintly guilty pirating 1-pixel content and bandwidth from good old imdb ), you should save neutral.gif and blue.gif into the same directory as TEMP.html, and remove the "http://i.imdb.com/" references from TEMP.html.

It’s possible to eliminate the use of img elements completely use colspan and bgcolor attributes, but most browsers render tables like this much more inefficiently than they do img elements, leading to noticeable pauses or even crashes of the browser.

Now I can lament the world’s lack of appreciating of html, and the degeneration of the browser into a glorified app-launcher & container. If things had gone according to plan, html would have loads of basic graphics rendering elements now, but, alas, things went according to other plans.