Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Only show information after a certain date
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Only show information after a certain date
Amend your formula to say NA() instead of zero.
-- David Biddulph "Dom" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
using a toggle button to show or hide information in several cells | Excel Worksheet Functions | |||
in Excel is it possible to have header information show in a cell | Excel Discussion (Misc queries) | |||
How do I get information on worksheet 1 to show in other wkshts? | Excel Worksheet Functions | |||
pivot tables using same heading to show multiple data information | Charts and Charting in Excel | |||
Rolling over the icons does not show information. | Excel Worksheet Functions |