VBA有没有办法创建自定义传奇？
我正在使用VBA创建一个枢轴图表，然后将其用于前10个类别的过滤。对于传奇，我们希望将这些类别包括在饼图中。我能够创建一个未包含在饼图中的项目的列表，但是我还没有想出如何将它们添加到传奇中。我尝试独自设置XVALUES，但这无效。可以创建自定义传奇吗？我不需要颜色框，但我想添加与饼图中前10个类别显示的数字和百分比相似。
I am using vba to create a pivot chart that is then filtered for the top 10 categories. For the legend we would like to include those categories NOT in the pie chart. I am able to create a list of the items that are not included in the pie chart, but I haven't figured out how to add them to the legend. I tried setting the XValues alone but that didn't work. Is it possible to create a custom legend? I wouldn't need the color boxes but I would like to add the number and and percent similar to those that are displayed for the top 10 categories in the pie chart.
如果你对这篇内容有疑问，欢迎到本站社区发帖提问 参与讨论，获取更多帮助，或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱，如果其他用户或者作者回复了您的评论，将不能在第一时间通知您！
发布评论