Conquered: interactive charts with mixed number formats

[K. Georgiadis]

Persistence has paid off and this challenge has been
resolved. My thanks to Tushar Mehta for pointng me in the
right direction

 

[Tushar Mehta]

You are welcome. Thanks for letting folks know.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

 

[Guest]

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