Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 02-27-2018, 07:37 AM
custermd custermd is offline Assets checked out charting? Windows 7 Assets checked out charting? Office 2007
Novice
Assets checked out charting?
 
Join Date: Aug 2010
Posts: 4
custermd is on a distinguished road
Default Assets checked out charting?


Cheers All, I have about 5 assets (Laptops) that get checked-out and checked-in. I am trying to see how many devices are checked out on a day-to-day basis. The mixed data in the checked-in/out column and the non sequential dates are really throwing me off. Any thoughts are welcome.

Thanks,
David
Attached Files
File Type: xlsx 20180226_1341.xlsx (28.9 KB, 11 views)
Reply With Quote
  #2  
Old 02-27-2018, 12:42 PM
xor xor is offline Assets checked out charting? Windows 10 Assets checked out charting? Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Can't you use a pivot table?
Attached Files
File Type: xlsx AssetTag.xlsx (38.2 KB, 8 views)
Reply With Quote
  #3  
Old 02-28-2018, 12:16 PM
custermd custermd is offline Assets checked out charting? Windows 7 Assets checked out charting? Office 2007
Novice
Assets checked out charting?
 
Join Date: Aug 2010
Posts: 4
custermd is on a distinguished road
Default

Quote:
Originally Posted by xor View Post
Can't you use a pivot table?
I have tried but I can not get the data sorted properly.
Reply With Quote
  #4  
Old 02-28-2018, 12:36 PM
xor xor is offline Assets checked out charting? Windows 10 Assets checked out charting? Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Can you in your file manually show what you want?
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Problems when opening previous version of .mpp file from Site Assets in SharePoint site Laibiang Project 11 10-17-2014 05:28 AM
Excel Charting ubns Excel 0 05-10-2012 05:55 PM
Charting Help - Stock Prices Ligerdub PowerPoint 0 01-03-2012 04:59 AM
Assets checked out charting? conditional charting omer123456 Excel 3 12-21-2011 12:53 PM
Charting issue, please help! powerpointnewbie PowerPoint 0 06-07-2011 03:04 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 07:43 AM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft