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

Originally Posted by bculjak

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.

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

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.

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.