Option of showing forecast on graph

[Kamarlon]

I'm searching the posts on this website for anything dealing with dynamic graphs with forecast values. I want the graph to always show the actual figures, but I want to enhance it by allowing users to be able to select the option of showing the next 3 month's forecast figures. Does any one know where I can find information on this?

 

[Hui]

Kamarlon


Add a second series to your chart

Add a Check Box to your chart and link it to a cell some where

In your forecast series change the formulas to reference the Linked Cell from the Check Box

=if(LinkCell,your current formula,na())

 

[Kamarlon]

Thanks Hui. The problem now is linking both the actual and forecast lines together. I see where you assisted someone with this problem, but the solutions that were given wont work in my case, as i use only dynamic ranges in my dashboard. so I see where the option was to have the last value in the actual series, be the first value in the forecast series. This won't be possible in my case.

 

[anupagarwal06]

Hi Kamarlon,


I think this is what you want.


check the file "forecast chart" in this folder:


https://skydrive.live.com/?cid=16d5e40738502388&id=16D5E40738502388%21103

 

[Kamarlon]

Anupagarwal06: When I try accessing the file I get the following message.

"This item might have been deleted, expired, or you might not have permission to access it. Contact the owner of this item for more information."


Do you know why this is happening?

 

[NARAYANK991]

Hi ,


I think this is a problem that only a part of the address has been posted ; the entire address is much longer than what has been posted.


Probably Anup can repost the full address.


Narayan

 

[anupagarwal06]

Sorry for inconvenience


This is the full address:


check the file "forecast chart" in this folder:


https://skydrive.live.com/redir.aspx?cid=16d5e40738502388&resid=16D5E40738502388!103&authkey=xmIdtAa3YnU%24

 

[Kamarlon]

Anupagarwal06: Yes thsi is what I wanted to do but with a aslight modification. I see what you did to calculate the forecast figures, but how can I get the same thing using a named range. The nature of my spreadsheet does not allow me to add another column. I am thinking of replacing the cell references in column B to read as follows: but then the title "Actual Data" would be included. Any suggestions?


IF(AND(B:B="",$C$14),$C$12+(ROW(B:B)-1)*$C$11,NA())