• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 386
  • Last Modified:

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
0
jstaron7
Asked:
jstaron7
2 Solutions
 
gtglonerCommented:
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 HensonFinance 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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now