sharpend   11 #1 Posted March 25, 2019 I have an excel spreadsheet where I want to make a graph.  One of the axis is a date - 2 years.  The graph I want to make is only of the last 4 and next 4 weeks.  (A 2 year graph makes little sense on a screen)  There is a TODAY function so the chart would be TODAY - 28 to TODAY +28  But after that I am lost  Any one help? Share this post Link to post Share on other sites Share this content via...
max   13 #2 Posted March 25, 2019 Try creating a new sheet which replicates the data but uses the TODAY function to limit it's size. From there it will be easier to create a chart. Share this post Link to post Share on other sites Share this content via...
sharpend   11 #3 Posted March 25, 2019 ah so I have original data sheet AND effectively a copy of data sheet BUT JUST today +/- 28 days? Share this post Link to post Share on other sites Share this content via...
Phanerothyme   12 #4 Posted March 25, 2019 Exactly. Something like VLOOKUP maybe?  Share this post Link to post Share on other sites Share this content via...
sharpend   11 #5 Posted March 26, 2019 12 hours ago, Phanerothyme said: Exactly. Something like VLOOKUP maybe?  =VLOOKUP(name of what we are calling master sheet - required row - TODAY +/- 28)  Will have a poke around with that Share this post Link to post Share on other sites Share this content via...