I would like to use the isodd() function in the chart data range input field to replace say “$Chart.$D$32:$D$500”. There must be a way to pick out data ranges by odd or even rows?
Thanks
I would like to use the isodd() function in the chart data range input field to replace say “$Chart.$D$32:$D$500”. There must be a way to pick out data ranges by odd or even rows?
Thanks
AFAIK no way to use function/forrmulas in chart data ranges. Prepare your data ranges accordingly
Okay thanks. Will do