Show 'incomplete' axes & show ticks but NOT axes?
 

I've been reading Edward Tufte's "The Visual Display of Quantitative
Information" (which, by the way, I can whole heartedly recommend to anyone
with a personal/professional interest in statistical graphics).

Anyway, I'd love to implement some of his ideas. For example - using a
chart's axes as a 'range frame' - so that each axis is only shown from the
minimum to maximum of both variables plotted . Meaning that the axes
themselves carry information .

Does anyone know if or how this could be done in excel? An add-in maybe?
Also, things like showing the tick marks but not the axis lines themselves?

Any help would be appreciated or if anyone else has implemented some of
Tufte's techniques I'd really appreciate advice as to how, within the
constraints of Excel's charting abilities.

Jay
__

Show 'incomplete' axes & show ticks but NOT axes?
 

Hi,

Here is an addin to link axis min/max values to cells. The cells would
contain formula to determine the min and max value you wanted to use.
http://tushar-mehta.com/excel/softwa...art/index.html

The tickmarks use the same colour as the axis line. There for in order
to get just tickmarks you would need to create your own with a dummy
data series.

For excel charting start by trying these sites for ideas.
Also check the link pages on each for even more sites.

http://peltiertech.com/Excel/Charts/index.html
http://www.andypope.info/charts.htm
http://www.stfx.ca/people/bliengme/ExcelTips.htm
http://tushar-mehta.com/excel/charts/
http://processtrends.com/
http://www.edferrero.com/

Cheers
Andy

Jay wrote:
I've been reading Edward Tufte's "The Visual Display of Quantitative
Information" (which, by the way, I can whole heartedly recommend to anyone
with a personal/professional interest in statistical graphics).

Anyway, I'd love to implement some of his ideas. For example - using a
chart's axes as a 'range frame' - so that each axis is only shown from the
minimum to maximum of both variables plotted . Meaning that the axes
themselves carry information .

Does anyone know if or how this could be done in excel? An add-in maybe?
Also, things like showing the tick marks but not the axis lines themselves?

Any help would be appreciated or if anyone else has implemented some of
Tufte's techniques I'd really appreciate advice as to how, within the
constraints of Excel's charting abilities.

Jay
__



--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info