Hi,

Try this layout, which would fill cells A1:D10, and plot as clustered
column.

QTY Time
Joe Mufflers 1 5
Brake Jobs 2 1
Oil Changes 3 2
Frank Mufflers 2 1
Brake Jobs 7 15
Oil Changes 8 16
Peter Mufflers 6 2
Brake Jobs 8 7
Oil Changes 10 25

Names and Task on axis, quantity and time along side each other.

For introduction to charts see
http://peltiertech.com/Excel/ChartsHowTo/index.html

Cheers
Andy



wooljr wrote:
My spreadsheet is laid out as follows:

JOE FRANK PETER
QTY TIME QTY TIME QTY TIME
Mufflers 1 5 2 1 3
2
Brake Jobs 2 1 7 15 8 16
Oil Changes 6 2 8 7 10 25

I am having trouble trying to create a graph (I wanted a stacked bar
graph) that will allow me to visualize the qty of each task vs the
amount of time it is taking each person.

Names at Bottom - Each task a different colour bar - with the time
appended to the end of each "task" bar.

Any suggestions? Or can anyone direct me to a tutorial??

Thanks

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info