+ Reply to Thread
Results 1 to 7 of 7

Pivot table data series limit of 255 but using only two columns

  1. #1
    Registered User
    Join Date
    06-13-2019
    Location
    Austria
    MS-Off Ver
    Office 365
    Posts
    4

    Pivot table data series limit of 255 but using only two columns

    Hello dear excel users,

    I am having a problem which certainly has very simple solution but I can't find it because while i google this I always reach questions from people who want to pot multiple series on one graph.

    I wanted to show simple line graph using power pivot. One column is showing position of the measurement and the second column is showing measured value.

    data series error.PNG

    Now I just want to swap axes, so that the position (mm) is ascending from top to bottom. When I click on "switch row/column" I get an error that maximum number of data series is 255. I don't understand why, I just have two columns of data so if I understand this right it should be two series, one representing position and one representing measured value.
    Thanks for the help!

  2. #2
    Registered User
    Join Date
    06-13-2019
    Location
    Austria
    MS-Off Ver
    Office 365
    Posts
    4

    Re: Pivot table data series limit of 255 but using only two columns

    Same as here. I would like just to swap axes.

    multi pivot.PNG

  3. #3
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    UK
    MS-Off Ver
    2010 primarily
    Posts
    2,951

    Re: Pivot table data series limit of 255 but using only two columns

    Quote Originally Posted by bculjak View Post
    When I click on "switch row/column"
    That is not swapping axes, it's plotting each value as a new series. All you need to do is select the series in the chart and then Format Data series and choose to plot it on a secondary axis.
    Rory
    Days when we raged, we flew off the page
    Such damage was done

  4. #4
    Registered User
    Join Date
    06-13-2019
    Location
    Austria
    MS-Off Ver
    Office 365
    Posts
    4

    Re: Pivot table data series limit of 255 but using only two columns

    Sorry, but I don't think I understand this. Could you tell me step by step please?

    However, now I can't edit data in the series when I open "select data" window

    Capture.PNG
    Last edited by bculjak; 06-13-2019 at 11:00 AM.

  5. #5
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003, 2007, 2010 & 2013
    Posts
    18,434

    Re: Pivot table data series limit of 255 but using only two columns

    With pivot chart the row field is plotted against the category axis and the column field determines the series.

    The Switch Row/Columns has the affect of move the variable in the row field to the column field and creating multiple series.

    You need to swap the variables used in the Row field and Values field of the pivot table. This will raise a problem in that all the identical values in the row field will be grouped together and the values plotted against the vertical axis will be summed. This is probably not what you want.

    Note that the chart is a line chart and not a xy-scatter. This means the spacing on the horizontal axis is evenly spread according to the number of unique data values and not relative to their actual value.

    In order to do a true xy-scatter chart from the pivot table you will need to use a standard chart and reference the ranges covered by the pivot table.
    Cheers
    Andy
    www.andypope.info

  6. #6
    Registered User
    Join Date
    06-13-2019
    Location
    Austria
    MS-Off Ver
    Office 365
    Posts
    4

    Re: Pivot table data series limit of 255 but using only two columns

    I really don't understand why it is such a problem just to transpose this. Just to shift the data from x axis to y axis and from y to x

  7. #7
    Forum Guru
    Join Date
    08-28-2014
    Location
    USA
    MS-Off Ver
    Excel 2010/2019
    Posts
    7,338

    Re: Pivot table data series limit of 255 but using only two columns

    It may help, I emphasize the word may, if you could upload a small desensitized sample of the data.
    To upload a sample workbook (I assume that you have data on multiple sheets) click on the GO ADVANCED button below the Quick Reply window and then scroll down to Manage Attachments to open the upload window.
    Let us know if you have any questions.
    Consider taking the time to add to the reputation of everybody that has taken the time to respond to your query.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1