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

Now that the message is submitted I can actually see that the layout does not
look good. I wish this had a preview feature or an edit post function.
Here's another attempt.

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




"Rob" wrote:

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!