I have a simple Google Sheet for my source for Google Data Studio charts. Legends in pie charts and columns in bar charts show a "null" that I can't explain. My columns display correctly but there's always an empty column or "null" in the pie chart legend. Any ideas? enter image description here

  • Maybe a dumb suggestion but did you tried croping the the cells to keep only data ? (no blank cells) I personnly like to use the Crop Sheet add-on and I have never encounter this problem using Data studio. – pjmg Aug 28 at 19:10
  • Good thought but there are a LOT of columns in this project and the lengths vary. I'm not familiar with Crop Sheet but I'll look into it! Thanks! – Big Al Monroe Aug 28 at 19:54
  • Did you check every field from the data source ? Sometimes it's because Data-studio use by default the wrong type of format. (Try to add some relevant screenshot in your question and blur or hide sensitive data) – pjmg Aug 28 at 20:03
  • Yes, I've worked with that possibility. Sadly, I don't have permission in this forum, as a new member, to add a screenshot. – Big Al Monroe Aug 28 at 20:11
  • 1
    @BigAlMonroe you can upload to imgur and edit the post and add the link – Sathyajith Bhat Sep 4 at 12:51

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.