Conquered: interactive charts with mixed number formats

  • Thread starter Thread starter K. Georgiadis
  • Start date Start date
K

K. Georgiadis

Persistence has paid off and this challenge has been
resolved. My thanks to Tushar Mehta for pointng me in the
right direction
 
I had to make two changes:

1) I changed your formula:

PlotData =OFFSET(Sheet1!$B$1,Sheet1!$J$6-1,0,1,COUNTA
(Sheet1!$1:$1)-1)

to:

PlotData =OFFSET(Sheet1!$B$1,Sheet1!$J$6-1,0,1,COUNTA
(Sheet1!$A:$A)-1)

2) Additionally, I was making an error in application of
the formula when I linked the Y values to it; namely, I
had forgotten to start the reference to the formula by
first citing the name of the workbook, e.g. 'My
Workbook.xls'!PlotData.

Again, many thanks for your help

KG
 
Back
Top