Solved

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

Posted on 2011-03-21
3
376 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 31

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

Find Ransomware Secrets With All-Source Analysis

Ransomware has become a major concern for organizations; its prevalence has grown due to past successes achieved by threat actors. While each ransomware variant is different, we’ve seen some common tactics and trends used among the authors of the malware.

Join & Write a Comment

Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
#Citrix #Internet Explorer #Enterprise Mode #IE 11 #IE 8
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
How to create a custom search shortcut to site-search Experts Exchange using Google in the Firefox browser. This eliminates the need to type out site:experts-exchange.com whenever you want to search the site. Launch your Bookmark Menu: Press 'Ctrl +…

762 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

21 Experts available now in Live!

Get 1:1 Help Now