R
R.VENKATARAMAN
I came across the dynamic chart tutorial in Tushar-Mehta's page. (item no.
4)
I have a number of mutual funds or stock scrips for which I collect daily
nav/price data to study its movement.
So far I have charted these data for each fund/share separatel;y. That
means my workbook is clurrered with many chartsheets.
the above dynamic chart has been extremely useful so that I can look at any
one chart by changing the value in ref cell J1.
In Tushar methta's example sheet the data are columwise whereas my data is
rowwise. Naturally i have to do some minor changes in the refersto values of
"yvalues" and "xvalues" and "whichyear"(which I changed to "whichscrip" or
"whichmutualfund"). I did it successfully.
but there is one problem. the values are not within homogeneous limits. In
one case the value may be between 10 and 100 and another case the values
may be between 500 and 1000. If I meddle with the scale in the second chart
(500 to 1000) making the minimum of scale as 500 the scales in all the
charts become 500 to 1000 and the first chart does not have any lines
because the maximum of the scale of the first chart data is less than the
minimum of the scale of the second chart data .. I have to again change the
scale for the first chart. The problem occurs only in the minimum of the
scale.
the maximum in each case adjusts itself. Perhaps it is possible to attach a
vba code for scaling in each case. I shall work on it. any other ideas on
this are welcome.
I had another problem. in the example sheet there are only three columns so
that if I type 1 in J1 (or use a data validation list in J1) I know it is
1996. But if I have 100 shares I do not immedatley know which ordinal
number belongs to which share. Besides If I want to see the chart for a
particular share I must find out what is the number and fill J1 with that
number. In this case in an unused area of the sheet (as I dont want to
mess up with the data portion) I copied the list of the shares and "filled"
previous column with number 1 to 100. I prepared a LISTBOX from the
controltoolbox with these two columns tinkering with the properties as
"boundcolumn" as1 and "countcolumn" as 2 with necessary "linkedcell" as J1
and "listfillrange" as the 100x2 matrix of numbers and shares. Now If I
click a particular share, in which I am interested, in the LISTBOX the
corresponding number is automatically entered in J1 and I get my chart.
Perhaps this is a very INELEGANT solution but it works.
any comments/cirticism/alternateideas are welcome.
I wrote in detail to clarify to myself what I have done. thanks.
4)
I have a number of mutual funds or stock scrips for which I collect daily
nav/price data to study its movement.
So far I have charted these data for each fund/share separatel;y. That
means my workbook is clurrered with many chartsheets.
the above dynamic chart has been extremely useful so that I can look at any
one chart by changing the value in ref cell J1.
In Tushar methta's example sheet the data are columwise whereas my data is
rowwise. Naturally i have to do some minor changes in the refersto values of
"yvalues" and "xvalues" and "whichyear"(which I changed to "whichscrip" or
"whichmutualfund"). I did it successfully.
but there is one problem. the values are not within homogeneous limits. In
one case the value may be between 10 and 100 and another case the values
may be between 500 and 1000. If I meddle with the scale in the second chart
(500 to 1000) making the minimum of scale as 500 the scales in all the
charts become 500 to 1000 and the first chart does not have any lines
because the maximum of the scale of the first chart data is less than the
minimum of the scale of the second chart data .. I have to again change the
scale for the first chart. The problem occurs only in the minimum of the
scale.
the maximum in each case adjusts itself. Perhaps it is possible to attach a
vba code for scaling in each case. I shall work on it. any other ideas on
this are welcome.
I had another problem. in the example sheet there are only three columns so
that if I type 1 in J1 (or use a data validation list in J1) I know it is
1996. But if I have 100 shares I do not immedatley know which ordinal
number belongs to which share. Besides If I want to see the chart for a
particular share I must find out what is the number and fill J1 with that
number. In this case in an unused area of the sheet (as I dont want to
mess up with the data portion) I copied the list of the shares and "filled"
previous column with number 1 to 100. I prepared a LISTBOX from the
controltoolbox with these two columns tinkering with the properties as
"boundcolumn" as1 and "countcolumn" as 2 with necessary "linkedcell" as J1
and "listfillrange" as the 100x2 matrix of numbers and shares. Now If I
click a particular share, in which I am interested, in the LISTBOX the
corresponding number is automatically entered in J1 and I get my chart.
Perhaps this is a very INELEGANT solution but it works.
any comments/cirticism/alternateideas are welcome.
I wrote in detail to clarify to myself what I have done. thanks.