Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
3 bits of data
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? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
3 bits of data
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 -- If this helps, please click the Yes button. Cheers, Shane Devenshire "BimboUK" wrote: 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? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
3 bits of data
Excel 2007
PivotTable, PivotChart Macro used to add labels. Added equivalent flat Table. http://www.mediafire.com/file/jytmgjnzii2/06_15_09.xlsm |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Charting more than 255 bits of data | Charts and Charting in Excel | |||
array of data and nested bits | Excel Worksheet Functions | |||
How to match bits to a certain value | Excel Worksheet Functions | |||
=Dec2bin can you increase the number bits please | Excel Discussion (Misc queries) | |||
BIN2DEC bits 0-5 then 6-15 | Excel Worksheet Functions |