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?
The reason why you see that null one(s) is because you select the whole column(s) as data source (ex. A:C) instead of only selecting the range with data (ex. A1: C20). You have 2 options:
- by selecting A:C, you have to add a filter in chart setup section to exclude those rows without data
- change the data source range to A1:C20 The 1st is better as it'll be able to handle the potential change of the data.