View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.charting
Del Cotter Del Cotter is offline
external usenet poster
 
Posts: 560
Default Newbie trying to graph

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.