Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 06-13-2016, 05:58 AM
SavGDK SavGDK is offline Auto update excel graph range, ignore data when date reads 00-Month-00 Windows 7 64bit Auto update excel graph range, ignore data when date reads 00-Month-00 Office 2010 64bit
Novice
Auto update excel graph range, ignore data when date reads 00-Month-00
 
Join Date: Apr 2016
Location: Savannah Ga
Posts: 20
SavGDK is on a distinguished road
Default Auto update excel graph range, ignore data when date reads 00-Month-00


I am having some issues with excel giving me complex data errors when graphing data in excel. I would like the data to update when the date range is updated for the workbook and when the date reads 00-Month-00 ignore the rest of the data starting at that point. Hopefully the attached spreadsheet will help it make more sense.

Thank you,

Dan
Attached Files
File Type: xlsx Graphing Help.xlsx (39.3 KB, 8 views)
Reply With Quote
  #2  
Old 06-13-2016, 07:51 AM
xor xor is offline Auto update excel graph range, ignore data when date reads 00-Month-00 Windows 10 Auto update excel graph range, ignore data when date reads 00-Month-00 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

Maybe like this.
(See Name Manager).
Attached Files
File Type: xlsx Graphing Help_2.xlsx (58.4 KB, 11 views)
Reply With Quote
  #3  
Old 06-24-2016, 08:05 AM
SavGDK SavGDK is offline Auto update excel graph range, ignore data when date reads 00-Month-00 Windows 7 32bit Auto update excel graph range, ignore data when date reads 00-Month-00 Office 2010 32bit
Novice
Auto update excel graph range, ignore data when date reads 00-Month-00
 
Join Date: Apr 2016
Location: Savannah Ga
Posts: 20
SavGDK is on a distinguished road
Default

This worked great. I apologize it took so long to reply. Thank you for the help!!!!
Reply With Quote
Reply

Tags
auto update

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel day date month year Function greginky Excel 1 01-05-2016 02:19 AM
Auto update excel graph range, ignore data when date reads 00-Month-00 Filter by a Month that falls within a date range MattG1225 Excel 2 12-03-2015 07:44 AM
Auto update excel graph range, ignore data when date reads 00-Month-00 Auto update date mavisyew Word 2 07-15-2015 08:44 AM
How to create a column graph from row data in excel jyfuller Excel 0 07-02-2013 05:07 AM
Auto Update the date. Nirik Excel 16 12-16-2010 04:23 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:16 PM.


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