« Lines of death | Main | March mildness »

TrackBack

TrackBack URL for this entry:
http://www.typepad.com/services/trackback/6a00d8341e992c53ef00d834edc9ed53ef

Listed below are links to weblogs that reference Picking up the right file:

Comments

wcw

..of course, equally puzzling is the assumption that high stock performance subsequent to IPO need equate to "quality". All Citi has to do to equal Goldman, after all, is take the same paper it's issuing at $1.00 and price it at $0.85. As the seller, I might well prefer the whole dollar to the Goldman mystique and quality syndicate support.

meep

Just for info: what do you use to create your charts?

Kaiser

Meep: Most of the charts were created first in Excel, then made pretty in Powerpoint. It does take a lot of time because the default settings are never right. Some of the charts are created using the software R, which is just a great piece of software for doing statistics.

derek

I've heard so much lately about people who use Adobe Illustrator to pretty up their graphics that I went looking for a cheap new or secondhand copy. I changed my mind quickly when I saw what the prices were for the Windows version.

So it would be great if one of these days you devoted an entry to sharing some of the secrets of making junk art charts in Powerpoint, or dropped a few tips in when writing up a regular recycling job.

jussijoo

Oh my... you're using PowerPoint..!? I'm sorry but from my graphic designer point of view it's purely astonishing that anyone really wants to use that piece of software for drawing purposes.

My first choice is Illustrator, but if you want a more affordable option, why don't you download a copy of excellent Inkscape? It is open source and quite pleasant to use.

derek

jusijoo, when you're moving vector graphics from an Excel chart into Inkscape, what do you do to achieve that?

david

To see the relationship between "quality" and "quantity" I'd prefer an XY plot. Returns (quality) on Y axis. Actual quantity on X axis rather than merely Rank - probably a log scale. Were the revenues included in the article?
Of course label each data point with underwriter name.
This would show if there is a general trend for quality vs quantity and any exceptions.

Kaiser

David: Absolutely, with two numeric metrics, a scatter plot would be a nice alternative. With ranks, I prefer a profile chart.

Derek/Jussijoo: I'll check out those alternatives when I have time. And I'll definitely do a write-up on the charting process.

derek

I think the previous commenter was being unrealistically optimistic about importing Excel into Inkscape. It's notoriously impossible without going through e.g. Illustrator, which is no good to anybody when you consider that not having to purchase Illustrator was supposed to be the whole point of using Inkscape. It may be the bees knees for arty types, but it lacks the tools needed for use by most people, unless you can also acquire and learn how to use an entire alternative toolbox chosen for its ability to export into the only formats Inkscape is capable of importing from.

And as soon as you decide to go down that route, Inkscape stops being the logical choice of drawing package anyway. You might as well choose the drawing package that goes with with the stats packages that you've chosen to use.

I'm still interested to learn about your use of Powerpoint for that reason. It may be rubbish, but it comes with Excel, and is what is to hand for those of us used to Excel as a charting tool.

Cejvik

Save as ODG and open in OpenOffice Draw. Import excel table and close with save, than open again in Inkscape... Work it?

Michael Peter

I love that quote...:

"Going public may just be the most important -- and nerve racking -- decision any company will make. "

Thank you very much :-)

inkGrapher

I've plotted a fair bit of data from a spreadsheet into Inkscape. You do have to create your own axes, but when it comes to plotting the data, I take my XY scatter data in two columns, and have a third column as the line segment delimiter 'L'. In inkscape, make a dummy line, then open up the XML editor with Cntrl-Shift-X (I think). Go to the line's point data, simply cut'n'paste the cells from the spreadsheet into the data field.

Verify your Comment

Previewing your Comment

This is only a preview. Your comment has not yet been posted.

Working...
Your comment could not be posted. Error type:
Your comment has been posted. Post another comment

The letters and numbers you entered did not match the image. Please try again.

As a final step before posting your comment, enter the letters and numbers you see in the image below. This prevents automated programs from posting comments.

Having trouble reading this image? View an alternate.

Working...

Post a comment

Marketing analytics and data visualization expert. Author and Speaker. Currently at Vimeo and NYU. See my full bio.

Book Blog



Link to junkcharts

Graphics design by Amanda Lee

The Read



Good Books

Keep in Touch

follow me on Twitter

Residues