Tufte-style gridlines

Jamie Martin

unread,

Jul 11, 2003, 10:57:37 AM7/11/03

to

I just got my copy of Edward Tufte's classic "The Visual Display of
Quantitative Information." He suggests that instead of drawing gridlines
across a bar chart, you erase a thin line through the bars where a
gridline would be. This makes your chart less cluttered and easier to read.

Is there a way to get Excel to do this? I have not been able to find one.

Thanks very much,

Jamie

James Silverton

unread,

Jul 11, 2003, 1:31:27 PM7/11/03

to

"Jamie Martin" <ja...@nospam.com> wrote in message
news:3F0ED061...@nospam.com...

I don't really know if it's what you want but you can set the gridlines to
be no color (white) while having the plot area colored. It works quite well
with a light gray plot area.

--
James V. Silverton
Potomac, Maryland, USA

James Silverton

unread,

Jul 11, 2003, 1:49:39 PM7/11/03

to

"James Silverton" <jim.si...@erols.com> wrote in message
news:bems9e$4tf$1...@bob.news.rcn.net...

Sorry to reply to my own reply, but I dragged out my own copy of Tufte and I
see that what you would want is a bar graph with the erased gridlines
crossing the bars. I'm afraid you've got me there tho' I agree with Tufte!
Perhaps Tushar Mehta has an answer; I stand back in real admiration of his
ingenuity!

Gary Klass

unread,

Jul 11, 2003, 3:05:41 PM7/11/03

to

I've done it a couple different ways:

1. break the bars down into stacked-bars, each one -- except the top --
the length of a grid unit. Make all the bars the same color and use a
white border.

2. Use the drawing toolbar to draw white lines across the bars -- but
be warned, the objects often shift when you copy and paste the chart.

3. use a mixed chart type: Bars and Lines where the lines are white:
Set your data up like this, create the bar chart, click on each of the
line2-4 series and change the chart type to a line. Then make the line
white, without markers.

bar line2 line 3 line 4
5 2 4 6
3 2 4 6
7.5 2 4 6
3.8 2 4 6

note, the lines only cover half of first and last bars, add blank first
and second rows to fix this.

James Silverton wrote:

--
Gary Klass
gmk...@ilstu.edu
Editor, PSRT-L
4600 Politics and Government
Illinois State University
Normal, Illinois 61790
http://LILT.ILSTU.EDU/gmklass
(309) 438-7852
(fax) 438-7638
The Chart of the Week: http://LILT.ILSTU.EDU/gmklass/cow

Gary Klass

unread,

Jul 11, 2003, 5:32:47 PM7/11/03

to

Here's another way. Create an image file, say, grey with a white line
across the top.

format data series, patterns, fill effects, picture -- select the image file

then select stack and scale to the axis scale units.

Jon Peltier

unread,

Jul 11, 2003, 11:21:31 PM7/11/03

to

And since Tufte's whole emphasis is on clarity and simplicity (from the
viewer's standpoint), how you do it is probably not too important. The
intent is to minimize the crap on the chart that interferes with its
legibility and meaningfulness.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Jamie M.

unread,

Jul 12, 2003, 9:38:55 AM7/12/03

to

This is brilliant. I especially like that it doesn't involve fragmenting the
source data. Thanks a lot!

"Gary Klass" <gmk...@ilstu.edu> wrote in message
news:benadv$na1$1...@malachite.ilstu.edu...

Gary Klass

unread,

Jul 13, 2003, 9:27:58 AM7/13/03

to

Yes, but if you really believed in Tufte's minimalist approach you
probably wouldn't be doing bar chart at all...

Jon Peltier wrote:

--