I'd like to show various date ranges periodically on the attached chart. In previous versions of Excel, I thought merely hiding the unwanted columns/rows on the source data sheet would stop the data from showing on the chart - is this not so with 2010? All hidden columns and rows are showing. Advice and suggestions are GREATLY appreciated!!
your calculate has been set to manual put it back to automatic and it updates when you hide data or press f9 when you want to update
Last edited by humdingaling; 04-30-2015 at 02:51 AM.
If you are satisfied with the solution(s) provided, please mark your thread as Solved.
Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks