Only show information after a certain date

D

Dom

Hi

I hope someone can help and that my query is possible. A bit of a long
explaination but please bare with me.

Is there away of information only showing in a graph once a certain date has
expired. As I have a graph which updates itself monthly from another excel
sheet I use. However I dont want this information to show up until the month
has gone so I dont want Aprils information to show up until 1st of May.
Unless I do this the line graph drops to 0 for the rest of the year and
doesnt look very good. I have been able to use an IF statement and an error
to hide any 0's but for some graphs some of the months will say 0.

Hope that made sense I would really appreciate any help with this as I have
no idea where to start if even possible

Thanks
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Create a chart from a table in word thats dynamic 0
Making a macro only work on certain files 2
Countdown macro - display settings 2
Template with fields and premade texts.. 0
Sharepoint not capturing staff name when automation runs 0
From Excel 97 to EXcel 2010 - TextBox on a Graph 0
Cannot do anything after zooming - Publisher Lite on Mac 0
Automation of scanned file storage based on content 0

Top