In my Google Sheets spreadsheet, I have a pivot table, and a column chart connected to it.

But the legend of the chart is displaying not just the headings, but also the two cells below the headings. For instance, the pivot table looks like this:

Date    Labeling   Quality   Weight
1/31       3          5        6
2/7        3          5        1
2/18       8          1        4
2/25       7          2        9

And the Legend box of the chart, which designates the columns, looks like this:

Labeling 3 3
Quality  5 5
Weight   6 1

EDIT: I didn't thing the configuration of the chart was important, since it seems to be working except for the legend. But if it helps: The Date column is the X-axis, the Labeling, Quality, and Weight are the data series (columns).

  • How could we possibly help if you do not share the configuration of your chart? – tehhowch Mar 9 '18 at 20:31
  • Is that better? What else do you need? – Shawn V. Wilson Mar 9 '18 at 20:43
  • Have you made sure that the chart's data source is correct? Right click on the chart -> Data range. – ttarchala Mar 9 '18 at 22:09
  • Confirmed. The Data Range starts in A8 (where the "Date" header is). The Series all start in Row 8 also. – Shawn V. Wilson Mar 9 '18 at 22:41

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Browse other questions tagged or ask your own question.