 |
 | 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 / New Users / March 2007sort data
i am trying, unsuccessfullty, to sort some data (a small example is below) so I can graph it. I want to put it into a pivot table format but don't want calculations, just the actual data. any ideas??/ Location DATE Result WAT002WA ALBANY BOTTOM 19-Jul-05 0.83 WAT002WA ALBANY BOTTOM 23-Jun-05 0.8 WAT002WA ALBANY BOTTOM 28-May-05 1.16 WAT002WA ALBANY BOTTOM 02-May-05 0.93 WAT002WA ALBANY BOTTOM 06-Apr-05 0.66 WAT002WA ALBANY BOTTOM 11-Mar-05 0.59 WAT002WA ALBANY BOTTOM 13-Feb-05 0.54 WAT002WA ALBANY BOTTOM 18-Jan-05 0.62 WAT002WA ALBANY TOP 09-Mar-07 0.73 WAT002WA ALBANY TOP 11-Feb-07 0.74 WAT002WA ALBANY TOP 16-Jan-07 0.67 WAT002WA ALBANY TOP 21-Dec-06 0.61 WAT002WA ALBANY TOP 25-Nov-06 0.7 WAT002WA ALBANY TOP 30-Oct-06 0.75 WAT002WA ALBANY TOP 04-Oct-06 0.74 I don't if this is exactly what you are wanting, but if you create the pivot table, I tired it with the Locations and Dates in the Row Area and the Results in the Data Area. You can then double click on the Location Field Label and in the PivotTable Field dialog box select None under Subtotals. > i am trying, unsuccessfullty, to sort some data (a small example is below) so > I can graph it. I want to put it into a pivot table format but don't want [quoted text clipped - 16 lines] > WAT002WA ALBANY TOP 30-Oct-06 0.75 > WAT002WA ALBANY TOP 04-Oct-06 0.74 |
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.