• Welcome to TONMO, the premier cephalopod interest community. Founded in 2000, we have built a large community of experts, hobbyists and enthusiasts, some of whom come together when we host our biennial conference. To join in on the fun, sign up - it's free! You can also become a Supporter for just $50/year to remove all ads and gain access to our Supporters forum. Follow us on Twitter and Facebook for more cephy goodness.

Octopus Stuff Prize...If you can help me!!!

Joined
Apr 7, 2004
Messages
427
OK, some of you know my abundance of ceph related stuff. Well here is your chance to get one of them as a prize.

I need a program that allows me to create a graph that allows the x-axis labels to be put in on a diagonal. If anyone has one of these that I can get a copy of to make a single graph (maybe two), they can choose one of the items below as a lavished-with-thanks reward.

There will be no cost for shipping either. I will bear all expense. I just need a copy of a program that can allow me to get past this one issue at work.

Please let me know as soon as possible. The prize will go on a first come, first wins basis.

The prizes are:
1) an octo toothbrush holder

or

2) an octo soap dish

or

3) a brass octo jewelry stamp

Get me the program, and pick the one you want!!!
 

Attachments

Joined
Apr 7, 2004
Messages
427
Diagonal X-axis Graph

Actually, here is an example of a vertical label for an x-axis. I need it to be diagonal.

Open Office and Excel allow one to change it to diagonal, but it doesn't really change the box size. Some graphs make the x-axis as this as the y-axis and then allow it to bend once it hits the graph and then goes vertical. That is what I need.
 

Attachments

DHyslop

Architeuthis
Registered
Joined
Dec 22, 2004
Messages
1,713
Excel will do it. On the above example I just rotated them the other way. Double click on the labels along the x-axis, then select the alignment tab.

Like you said, that just rotates them and doesn't adjust the graph. If you want to compress the x-axis after doing this, you can do it by again double-clicking the x-axis labels and selecting the scale tab.

Give me a sec and I bet I can duplicate that second image (with the months) exactly using the described techniques in Excel

Dan

OK. Here it is. The months are at an angle to shorten the total width of the graph:



Is this what you're looking for?
 
Joined
Apr 7, 2004
Messages
427
Look at these variations...

Here is the issue with that...

Because it does not bend with the slanting of the label, the collumn must remain a certain width (see example #1); however if it could bend or slant with the label then the collumns could be closed very tightly together.




I know you like Excel, because you are the Space Pope, ...but we don't need to bring Rome into this.:lol:

Crocodylus Pontifex
 

Attachments

DHyslop

Architeuthis
Registered
Joined
Dec 22, 2004
Messages
1,713
OK, so you're not looking so much for a data graph but for spreadsheet lines?

edit - to be honest, whenever I have a graph that's going somewhere serious I just let Excel generate it then paste it into Adobe Illustrator to do the cosmetics.
 
Joined
Apr 7, 2004
Messages
427
Never thought of that, but there are several packages out there that will do it very professionally.

I am hoping taht with all the marine scientists and biologist out there, someone would have some kind of program.
 

monty

TONMO Supporter
Staff member
Registered
Joined
Mar 8, 2004
Messages
4,884
http://www.gnuplot.info/

help set label

lets you rotate labels to an arbitrary degree. Unfortunately, there doesn't appear to be a "rotate by " for the xlabel, but its help file says "use label if you need the more fancy stuff."

of course, gnuplot is really only good for graphing numbers, so if it's more spreadsheet-like, it's probably not so hot.

I bet TeX or LaTeX can do it, too.

Both these options have the added advantage of being free & open source.
 

Latest Posts

Forum statistics

Threads
20,850
Messages
206,739
Members
8,457
Latest member
DaneMom6800

Monty Awards

TONMOCON IV (2011): Terri
TONMOCON V (2013): Jean
TONMOCON VI (2015): Taollan
TONMOCON VII (2018): ekocak


Top