Time for another round of cool charting / info-graphic ideas around the web.
Most Popular Baby Names – all the way from 1880
Nametrends is a cool website totally dedicated to analyzing and showing baby name trends. They have pretty interesting stuff like, how baby names ending with -lie (charlie, willie, ellie etc.) fared from 1880. Go ahead, see the neat stuff at nametrends. [via kottke]
Flare toolkit for visualizing in Flash
Flare is a powerful tool for visualizing large amounts of data using Action Script. Check it out. [via FlowingData]
Funny map of online communities
This cartoonish visualization from XKCD pokes fun at the sizes and boundaries of various online communities. Really hilarious and neatly done. [via cool infographics]
This is a non-linear info graphic that talks about how designers approach problems. The site >think>draw>make is a dedicated to visualizations of design processes. See it. [via cool infographics]
What info is hidden in a bar code?
This pretty visualization of bar codes uses information contained in the black stripes to generate Bezier curves (ahem!) that look like a tree, hence the name bar-code plantation 🙂 [via swissmiss]
Also see:
- Excel Links around the web – [July 29]
- Excel Links Around the Web [July 22]
- Cool Infographics / Charts of the Week [July 24]
Have any visualizations, graphs or cool charting ideas and want them featured here? Drop a comment.
8 Responses to “Introducing PHD Sparkline Maker – Dead Simple way to Create Excel Sparklines”
This looks like it could be very useful for a project I'm putting together right now, thank you so much. Quick & silly question, how do I copy & paste the sparkline as a picture?
Question answered. For anyone else:
Select chart>Hold Shift key & select Edit/Copy Picture>Paste
[...] more information about PHD Sparkline Maker, please read this article and to learn more about Sparklines, read this article from Microsoft Excel 2010 blog. Also there [...]
Am I right in thinking that the y-axis is set automatically by excel?
That makes it possible to get the column chart not to start at zero.
Andy - yes, it is currently set to 'auto', which defaults to a zero base for positive values, but you can change that by left-clicking the chart, then choosing (in Excel 2007):
"Chart Tools/Layout/Axes/Primary Vertical Axis/More Primary Vertical Axis Options"
PUBLIC SERVICE ANNOUNCEMENT: When manually editing a chart's minimum/maximum axis values, PLEASE be sure there's a valid reason and that doing so won't skew the message shown by the data (e.g. by exaggerating differences). If in doubt, go back and read Tufte. (W.W.T.D.?)
[...] gridlines, axis, legend, titles, labels etc.) and resize it so that it fits nicely in a cell [example]. This is the easiest and cleanest way to get sparklines in earlier versions of excel. However this [...]
thanks for the work creating the template!!!!
looks good