 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / Charting / January 2008Want to chart teen sons responsiblity
Trying to graphically prove whether my son is worthy of a car. I have a spreadsheet with this header row: Date Time Promise Actual time Commitment Actual Commitment Task/Help Actual Task/Help Plus/Minus I plan to manually enter the "Plus/Minus" on a 1-10 scale with 5 being expected, the norm. So I want the chart/graph to populate the results of that "Plus/Minus" with the Date on the left (x-axis?) and the results on the bottom (y-axis?). I tried doing it but it is a mess. Thanks in advance for your help! Using Office 2003 > Trying to graphically prove whether my son is worthy of a car. > I have a spreadsheet with this header row: [quoted text clipped - 7 lines] > > Thanks in advance for your help! What are you wanting help with, the calculation of the plus/minus, or graphing that data (although the latter look trivial at first sight)? and how many columns are there, it is difficult to work out?  Signature--- HTH Bob (there's no email, no snail mail, but somewhere should be gmail in my addy) > Using Office 2003 > [quoted text clipped - 11 lines] >> >> Thanks in advance for your help! The only chart that will work by default with the dates on the vertical axis is the Bar chart (it has horizontal bars). You may want to consider putting the dates on the horizontal (x-axis). Now, you can use just about any kind of chart (Column, Area, Line, or XY Scatter). To keep the dates on the vertical axis, you could *try* to plot the +/- values as the x-values and the dates as the y-values. Though, I suspect that most of the charts will still look strange. > Trying to graphically prove whether my son is worthy of a car. > I have a spreadsheet with this header row: [quoted text clipped - 9 lines] > > Thanks in advance for your help! |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.