Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
Roy -
Excel chooses ByRow/ByColumn based on the shape of the selected range. If your data range has equal rows and columns, or more columns than rows, Excel chooses ByRow. If you have more rows than columns, Excel chooses ByColumn. Sometimes if a discontiguous range is selected, Excel forgets its guidelines. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services Tutorials and Custom Solutions http://PeltierTech.com/ _______ wrote: 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 |
#3
|
|||
|
|||
Grrr. Thanks Jon for clearign that up. Much appreciated. I've been
able to get around it by jamming in the "rows" parameter, rather than letting Excel "think". Roy |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Can Excel automatically print only certain worksheets in a workboo | Excel Discussion (Misc queries) | |||
Enter Data Into Another Excel File Automatically | Excel Worksheet Functions | |||
In Excel, how do you get it to not automatically round my dollars. | Excel Worksheet Functions | |||
getting data from 2 excel sheets automatically | Excel Worksheet Functions |