On Wed, 4 Jun 2008, in microsoft.public.excel.charting,
wooljr said:
Names at Bottom - Each task a different colour bar - with the time
appended to the end of each "task" bar.
Lay your data out like this:
QTY
JOE FRANK PETER
Mufflers 1 2 3
Brake Jobs 2 7 8
Oil Changes 6 8 10
TIME
JOE FRANK PETER
Mufflers 5 1 2
Brake Jobs 1 15 16
Oil Changes 2 7 25
Make a clustered column chart from the first block, then use one of the
free add-ins to put the times on the end of the columns as labels:
Rob Bovey's Chart Labeler,
http://appspro.com
John Walkenbach's Chart Tools,
http://j-walk.com
Alternatively, just make a second clustered column chart from the second
block, showing the times.
Or even make both charts, one showing quantities, with time labels, and
the other showing times, with quantity labels.
--
Del Cotter
NB Personal replies to this post will send email to
,
which goes to a spam folder-- please send your email to del3 instead.