Dismiss Notice
Join Physics Forums Today!
The friendliest, high quality science and math community on the planet! Everyone who loves science is here!

Excel help needed on Charts

  1. Mar 30, 2005 #1
    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.
  2. jcsd
Share this great discussion with others via Reddit, Google+, Twitter, or Facebook

Can you offer guidance or do you also need help?
Draft saved Draft deleted