Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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! |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
Data to Chart Question/How-to
Compose your table in Notepad, using a nonproportional font. Then paste it
into your next post. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services, Inc. http://PeltierTech.com/WordPress/ _______ "Rob" wrote in message ... 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! |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
Data to Chart Question/How-to
Hi,
I'm having trouble envisaging your description of chart. The Vertical left axis is actually a category axis as each point is a discrete document. The Horizontal axis is also a category axis where each point is a reviewer. I would have thought the Overdue days would be displayed as a value at the intersect point of the Doc/Revwr. But somehow you want a 3rd axis, vertical right, to display overdue days. Is that axis not really an axis at all but just a column of Overdue values that will align with the corresponding document? If so what information should appear at the intersect of doc/revwr, where you data table currently has an X. Cheers Andy -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info "Rob" wrote in message ... 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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Chart Question regarding number of data points | Charts and Charting in Excel | |||
Chart Question | Charts and Charting in Excel | |||
chart question | Excel Discussion (Misc queries) | |||
question best way to organze data for this chart | New Users to Excel | |||
Pivot Chart Data Label Format Question | Excel Discussion (Misc queries) |