View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Rob Rob is offline
external usenet poster
 
Posts: 718
Default Data to Chart Question/How-to

Below is my data layout as it is right now. What I want my chart to look
like is described as...

The Vertical Left Area is the Document ID Column
The Horizontal Bottom Row is the Reviewer (Revwr #?)
The Secondary Vertical Right is the Days Overdue Numbers

So far I've tried to use a Scatter, Line, Bar, and also Combining them too
but nothing seems to yield the results I am looking for.

I hope that the data outline below shows up well enough but if not then let
me know and I'll try again.



Document ID Revwr #1 Revwr #2 Revwr #3 Revwr #4 Days Overdue
Document #001 X X 8
Document #002 X X 15
Document #003 X 15
Document #004 X X X 8
Document #005 X X 17
Document #006 X 89
Document #007 X 6
Document #008 X 237
Document #009 X X 3
Document #010 X X 10
Document #011 X 3
Document #012 X X X 15
Document #013 X 221
Document #014 X 3



Thanks in Advance!