I’ve discovered that it’s possible to display actual numbers directly on the slices of a Google Sheets pie chart. However, my goal is to have the percentage appear within the slice, while the true value is placed below the corresponding label. Despite various adjustments, only the percentage continues to show beneath each label. I’m looking for advice on how to configure the chart so that the real numbers are displayed separately from the percentages.
Any suggestions would be greatly appreciated!
The challenge you’re facing is one I’ve encountered before. Google Sheets charts have limited native options for detailed label customization. In my experience, I had to use creative workarounds, such as constructing a custom legend or overlaying a text box near the chart to display the actual values. Although this approach isn’t as clean as a built-in solution, it lets you manually align the numbers with the corresponding segments. Alternatively, exporting the data to a platform like Data Studio might offer enhanced label display features for your specific requirements.
i dont think google sheets itself supports that tweak. you might need to overlay custum text boxes or try a workaround with data studio. its clunky but might be the only way to get true values separate from percents.
Drawing from my own experience, it appears that Google Sheets’ native capabilities are quite limited when it comes to customizing pie chart labels the way you described. I eventually resorted to a workaround that involved combining a custom Apps Script with manual adjustments. I created an additional cell range to hold the true values and used a script to automatically update a separate text overlay positioned beneath the labels in the chart. This method required some fine-tuning to keep everything aligned, but it provided a way to detach the actual numbers from the pie chart percentages effectively.