A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Regarding Dynamic chart



 
 
Thread Tools Display Modes
  #1  
Old December 30th, 2009, 05:44 PM posted to microsoft.public.excel.charting
vmohan1978
external usenet poster
 
Posts: 38
Default Regarding Dynamic chart

Dear All I have problem in formula ans it was solved Mr. Max , now i am
facing problem in Chart please do the needful .
I am mention the my problem and the formula given by Mr.Max .

In cell b1 my input value varies from 1-30
in e1 my input will be amount it varies assume 300000.
i want formula in a5 to show 0 and a6 as 1 so on till i get the input in b1
.. and in c5 i need a formula =$e$1*((2*(a5/$b$1)^2-(a5/$b$1)^4) till same as
in column based on the value in b1.
wish you all a very happy new year -2010 in advance



A B C D E F
G
1


2

3
Mr.Max solution is
Q1
In A5: =IF(ROWS($1:1)-1B$1,"",ROWS($1:1)-1)
Copy down to A35. A5:A35 will return the auto-serializing that I think you
seek, starting from zero till the max value that is specified for B1 (30).
The serializing terminates at the number that you input into B1.

Q2
In C5: =IF(A5="","",$E$1*((2*(A5/$B$1)^2-(A5/$B$1)^4)))
Copy down to C35. I merely bolted-on a front IF trap: =IF(A5="","", ...
to your formula as posted so that it returns correspondingly to the serial
numbers in A5:A35. Where the serial terminates, it returns blanks: "". I'm
guessing this is what you want to happen

Now my problem is
If i use chart ( Lines) what range
i have to select so that it changes automatically wrt to the no of months
without showing drop in the chart.( for ex if first i select 30 months and
select range of 30 months it shows s shape but when i enter 20months it shows
S shape till 20months and later it shows drop to zero from 20 to 30 months.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 04:16 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.