K
K. Georgiadis
I posted this question earlier but, in spite of Tushar
Mehta's valiant efforts, I was unable to resolve my
problem. My data are organized differently than in the
examples cited on his web page and my knowledge of the
OFFSET and COUNTA functions simply proved to be too
spotty.
So, if I may burden you again:
I have an array of data organized as follows:
Response 1 2 3 4 5
Data in cells A4:F19:
Probability 80% 70% 65% 75% 85%
Number of Customers 115 185 100 160 190
Selling price $2.15 $1.85 $2.00 $2.30 $2.55
Etc. etc.
Note that throughout the array the data are in three
different number formats!
My objectives were to
(a) have 1 through 5 (Responses) on the X axis
(b) plot the data as an XY scatter chart
(c) use a combo box to determine which of the 16
dimensions on column A will be plotted
For data arrays using a uniform number format I have used
successfully the technique described in J. Walkenbach's
book "Excel Formulas" (using a combo box and an
intermediate range created with the INDEX function.)
However, the technique does not work with an array of
data that uses three different number formats. Namely,
the chart axis does not adapt to the number format of the
chosen dimension.
Could someone help (again)?
Many thanks !
Mehta's valiant efforts, I was unable to resolve my
problem. My data are organized differently than in the
examples cited on his web page and my knowledge of the
OFFSET and COUNTA functions simply proved to be too
spotty.
So, if I may burden you again:
I have an array of data organized as follows:
Response 1 2 3 4 5
Data in cells A4:F19:
Probability 80% 70% 65% 75% 85%
Number of Customers 115 185 100 160 190
Selling price $2.15 $1.85 $2.00 $2.30 $2.55
Etc. etc.
Note that throughout the array the data are in three
different number formats!
My objectives were to
(a) have 1 through 5 (Responses) on the X axis
(b) plot the data as an XY scatter chart
(c) use a combo box to determine which of the 16
dimensions on column A will be plotted
For data arrays using a uniform number format I have used
successfully the technique described in J. Walkenbach's
book "Excel Formulas" (using a combo box and an
intermediate range created with the INDEX function.)
However, the technique does not work with an array of
data that uses three different number formats. Namely,
the chart axis does not adapt to the number format of the
chosen dimension.
Could someone help (again)?
Many thanks !