#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Maybe like this.
(See Name Manager). |
#3
|
|||
|
|||
This worked great. I apologize it took so long to reply. Thank you for the help!!!!
|
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 |
Filter by a Month that falls within a date range | MattG1225 | Excel | 2 | 12-03-2015 07:44 AM |
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 |