3 bits of data

[BimboUK]

Who, where and when - a three dimensional graph! how best can I display this
info. At present I have the info in 2 different formats but basically by
individual but wish to be able to see at a glance who has worked on a job
(where) and when. Any ideas the best place to start?

 

[Shane Devenshire]

Hi,

This is not what Excel is designed to do, however, if you use a data layout
like this

Who Oakland SF
marsha 1 1 8/1/92 2/1/09
shane 1 1 11/27/07 6/15/09

Highlight the first 3 columns and create a 3-D column chart. Then use a
free add-in line the xlChartLabeler to add the date values to each column as
data labels

http://www.appspro.com/Utilities/ChartLabeler.htm

 

[Herbert Seidenberg]

Excel 2007
PivotTable, PivotChart
Macro used to add labels.
Added equivalent flat Table.
http://www.mediafire.com/file/jytmgjnzii2/06_15_09.xlsm