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
Know someone interested in this topic? Share this thread via Reddit, Google+, Twitter, or Facebook

Can you help with the solution or looking for help too?
Draft saved Draft deleted

Similar Discussions: Excel help needed on Charts
  1. Charts in Excel (Replies: 4)

  2. Word > Excel help (Replies: 9)