LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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!


 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Chart Question regarding number of data points ace Charts and Charting in Excel 0 April 2nd 09 03:21 PM
Chart Question Xl2007 Charts and Charting in Excel 1 November 11th 08 04:31 AM
chart question 00KobeBrian Excel Discussion (Misc queries) 15 November 3rd 06 08:29 PM
question best way to organze data for this chart MarkB New Users to Excel 3 October 31st 06 02:19 PM
Pivot Chart Data Label Format Question Dominic Excel Discussion (Misc queries) 3 March 1st 06 07:57 PM


All times are GMT +1. The time now is 10:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"