Why does Excel automatically choose the PlotBy method
Does anyone know what the criteria is that Excel uses to decide whether
to plot by rows or columns. In most cases it will default to rows on a
column chart, but every now and then it decides to choose columns when
the selected range is non-contiguous (which is legal), but rectangular.
Anyone seen this behavior before?
Roy
|