Chart problem with data setup. Only want to see actuals to current date.

Hi,

In the attached chart you can see that I only want the chart to show actual data up to the current date. Don't want to show future "blank" data.   Want horizontal chart to end at current date.  Please advise.

Thanks,
Joe


Chart.png
LVL 1
jstaron7Asked:
Who is Participating?

Improve company productivity with a Business Account.Sign Up

x
 
gtglonerConnect With a Mentor Commented:
What you want is a dynamically expanding chart. Here is an example that you might be able to adapt to your chart:
dynamic-chart.xls
0
 
Rob HensonConnect With a Mentor Finance AnalystCommented:
If you are happy doing it manually, or no doubt someone could write some code, hiding the columns/rows containing the future data will hide them in the chart.

Cheers
Rob H
0
 
jstaron7Author Commented:
Thanks,
Joe
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.