Solved

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

Posted on 2011-03-21
3
377 Views
Last Modified: 2012-05-11
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
Comment
Question by:jstaron7
3 Comments
 
LVL 17

Accepted Solution

by:
gtgloner earned 250 total points
ID: 35182008
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
 
LVL 32

Assisted Solution

by:Rob Henson
Rob Henson earned 250 total points
ID: 35193900
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
 
LVL 1

Author Closing Comment

by:jstaron7
ID: 35306244
Thanks,
Joe
0

Featured Post

Is Your Active Directory as Secure as You Think?

More than 75% of all records are compromised because of the loss or theft of a privileged credential. Experts have been exploring Active Directory infrastructure to identify key threats and establish best practices for keeping data safe. Attend this month’s webinar to learn more.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction If you're like most people, you have occasionally made a typographical error when you're entering information into an online form.  And to your consternation, the browser remembers the error, and offers to autocomplete your future entr…
If you are a web developer, you would be aware of the <iframe> tag in HTML. The <iframe> stands for inline frame and is used to embed another document within the current HTML document. The embedded document could be even another website.
This Micro Tutorial will demonstrate how nuggets on the Web are formatted by using Chrome Developer Tools. These tools would not only view the site's CSS but it can also modify it and save the CSS to use on your own site.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.

914 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

12 Experts available now in Live!

Get 1:1 Help Now