Does anyone know how to lock the Excel charts to be "series in rows" or "series in columns"?(adsbygoogle = window.adsbygoogle || []).push({});

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.

**Physics Forums - The Fusion of Science and Community**

Dismiss Notice

Join Physics Forums Today!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

# Excel help needed on Charts

Can you offer guidance or do you also need help?

Draft saved
Draft deleted

Loading...

Similar Threads for Excel help needed | Date |
---|---|

Help with Annoying Stuff on Excel | Jan 13, 2017 |

Help for excel, calculate division of colums by sums | Jun 17, 2016 |

I need help with an Excell formula I cannot figure out. | Apr 21, 2013 |

MS Excel Help - Saturation Points ? | Nov 30, 2007 |

Word > Excel help | Apr 17, 2006 |

**Physics Forums - The Fusion of Science and Community**