Does anyone know how to lock the Excel charts to be "series in rows" or "series in columns"? When I base a chart on a pivot table with drop down pages on it, each time I click on certain pages of the pivot table, the chart changes to read as series in rows/columns, etc. I believe this is due to something Excel which assumes how the user would want the data to be plotted. If the number of columns in the range is greater than or equal to the number of rows, then Excel automatically uses the rows for the data series. It's frustrating changing the series option everytime I click on each pivot table page.