« Lines of death | Main | March mildness »



..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.


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


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.


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.


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.


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


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.


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.


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.


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 :-)


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.

The comments to this entry are closed.

Kaiser Fung. Business analytics and data visualization expert. Author and Speaker.
Visit my website. Follow my Twitter. See my articles at Daily Beast, 538, HBR.

See my Youtube and Flickr.

Book Blog

Link to junkcharts

Graphics design by Amanda Lee

The Read

Keep in Touch

follow me on Twitter