Interesting Link for 10-April-2009
by Jon Peltier
Friday, April 10th, 2009
Peltier Technical Services, Inc., Copyright © 2010.
Licensed under a Creative Commons Attribution-Noncommercial-Share Alike 3.0 Unported License.
Just one link today. . .
Fancy Charts & Graphs, from The Big Picture by Barry Ritholtz
Thanks to Sjoerd Hoogwater for the link.
Related Posts:
- Scary Info Graphic
- Paper Pie Charts?
- Use a Chart to See Patterns in Your Data
- In-Cell Bullet Charts
- Pizza Pie
- Chart Selection Guide
- Interesting Links for 17 April 2009
- Bar graphs vs. Pie charts
- The Whatever Files, 15 May 2009
- Bad Graphics – Stacked Pyramid Chart
Posted: Friday, April 10th, 2009 under Amusement.
Comments: 2
Comments
Comment from Chris
Time: Friday, April 10, 2009, 1:16 pm
Hey Jon, I’ve been enjoying reading your blog and have a question on chart formatting. Not sure if this is the best place to post it or not, but I thought I’d try here.
Is there a way to show tick marks without showing the axis line? I’ve seen charts done this way I believe in the NY Times with column graphs, and it makes for a very clean presentation, but so far I haven’t been able to figure out how to do it in Excel without resorting to using a dummy x,y series, which then ties up the secondary axis. Is there something I’m missing?
Thanks, for all the great posts and advice,
Chris
Comment from Jon Peltier
Time: Friday, April 10, 2009, 4:52 pm
The axis tick marks are linked to the axis lines by the line color property. What this means is that you have to fake it.
Create an XY series with a point at each location along the hidden axis where you want a tick mark. Hide the markers for this series, and add short error bars that extend into the chart (you can’t get them outside the plot area, but it doesn’t matter if there’s no axis line). Format these error bars so they look like good tick marks.
A nice trick is to place a value in a cell to use as the error bar length, and set the custom error bar length to this cell. You can easily adjust the error bars by changing the value in this cell, without going through the dialog multiple times.
Write a comment
I welcome comments from my readers. If you have an opinion on this post, if you have a question or if there is anything to add, I want to hear from you. Whether you agree or disagree, please join the discussion.
If you want to include an image in your comment, post it on your own site or on one of the many free image sharing sites, and include a link in your comment. I'll download your image and insert the necessary html to display the image inline.
Read the PTS Blog Comment Policy.