How can I set the percentage to display to the first decimal place in batches?1. The result I want: percentage with one decimal place (as shown in the 2025/2/10 - BB-02-01 column in Figure 1). I can adjust it by customizing it (as shown in Figure 2), but I can't batch set all the columns at once.
Figure 1↑
Figure 2↑
2. I don’t want the “#N/A” column to appear in the chart.
I'd really appreciate your help, thank you!
Advanced Statistical ModelingRe: How to set the percentage to display to the first decimal place in batchesAdditional explanation:
Re: 请问如何批量设置百分比显示到小数点后第一位Hide and exclude N/A from your data table / use local data filter / missing value codes column property to hide them.
For the labels, customize the histogram BEFORE you add X and Y Group. The settings should get copied over to all of the smaller frames when you add those groups
Other option for setting the labels which you can do from the "grid" is: set the percent label dec to one frame, right click on that frame and copy customizations, then while holding CTRL right click on some other frame and paste customizations. This should broadcast those settings to all frames you have
Re: How to set the percentage to display to the first decimal place in batchesThank you so much for your help!!
