Manhattan Charts

[davidk]

Does anybody know if there is an add in etc to excel that
allows you to do manhattan charts?

 

[Michael R Middleton]

Does anybody know if there is an add in etc to excel that allows you to do
manhattan charts? <

If "manhattan charts" are a display of property prices versus distance from
the waterfront, you don't need an add-in. Arrange the property prices
(cost/area) in appropriate order, and create an Excel column chart.

(There would be more information content if you plot cost/area versus
distance using an XY (Scatter) chart, i.e., use the actual distance instead
of only the ranking.)

If that's not what you mean by "manhattan charts," maybe someone else will
know, or maybe you'll have to describe what you want in more detail.

- Mike Middleton, www.usfca.edu/~middleton

 

[Tushar Mehta]

You were close but not quite <g>

It looks like a column chart but I cannot conclude if the x-values are
just category values or have any cardinal significance

http://www.vanalen.org/workshops/east_river/general/chtpg10.htm
http://www.dur.ac.uk/colleges.cricket/images/technikon_graph.png

And, then, there seem to be references to a Manhattan Chart in Quality
Control
http://www.eng.monash.edu.au/ieem/course_notes/ind3320/LNotes/lec_tut_s
chedule.pdf
http://www.dti.gov.uk/actt/news/news10.htm#Manhattan control)

Above links are a result of http://www.google.com/search?hl=en&ie=UTF-8
&oe=UTF-8&q=%22manhattan+chart%22

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Tushar Mehta]

I think these are in the order that the categories appear along the
waterfront.

Yes, but are the distances between different locations reflected in the
spacing along the x-axis? I checked a map of Manhattan, and couldn't
tell at a glance if the Manhattan chart was a Column chart where the x
values had cardinal significance (albiet hidden since one sees only the
labels) or just a simple Column chart.

Some kind of cricket scores?

Yes, but the x-axis values were 'overs' which simply increase by 1
starting from 1. So, whether the axis has category and cardinal
information is impossible to tell.

--
Regards,

Tushar Mehta, MS MVP -- Excel
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Jon Peltier]

Yes, but are the distances between different locations reflected in the
spacing along the x-axis? I checked a map of Manhattan, and couldn't
tell at a glance if the Manhattan chart was a Column chart where the x
values had cardinal significance (albiet hidden since one sees only the
labels) or just a simple Column chart.

I just assumed that the categories were in order. The chart did not
appear sophisticated enough that someone had attempted any kind of
proportional spacing along the X axis.

- Jon