1. 我想要的结果：带一位小数的百分比（如图 1 中 2025/2/10 - BB-02-01 列所示）。我可以通过自定义进行调整（如图 2 所示），但无法一次性批量设置所有列。
图1↑
图2↑
2.我希望在图表中不显示“#N/A”这一列。
我真的很感激您的帮助，谢谢！
Accepted Solutions
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
补充说明一下：
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