Jump to content
Fancy running a forum? Sheffield Forum is for sale! Learn more

Charting with excel

Recommended Posts

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

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

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
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

Create an account or sign in to comment

You need to be a member in order to leave a comment

Create an account

Sign up for a new account in our community. It's easy!

Register a new account

Sign in

Already have an account? Sign in here.

Sign In Now
×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.