是否可以将脚本添加到条形图中以强制其Axis值？ [英] Can a Script be added to a bar chart to FORCE its Axis value?

问题描述

我使用openXML更新单词doc的条形图。 当它只是值0 - 100％它工作正常。  ？现在 它必须显示底部的％百分比轴被缩放到最大值

I use openXML to update a barchart on a word doc.  When it was just the value 0 - 100% it worked fine.  now?  it MUST show the Percent % Axis on the bottom to be scaled to the largest value

但在Excel中？ 它是这样的：

But in Excel?  its like this:

颜色已关闭，但蓝色/橙色条形图显示在Excel中。 用词？它坚持扩展它。 如果缩放从auto更改？然后它将其设置为最大限制。 一个值可能是105或150或220，它需要
来相应地显示轴。 如果值为112？ 底轴值必须以120结束。

The colors are off, but the blue/orange bar chart shows up right in Excel.  In word? it insists on scaling it.  If the scaling is changed from auto? then it sets that as the maximum limit.  It may be 105 or 150 or 220 for a value and it needs to show the axis accordingly.  if a value is 112?  the bottom axis value must end at 120.

但如果是100？ 然后它无法延长。 出于某种原因，如果值为100％，Word想要将轴自动缩放到120％

But if its 100?  then it cannot extend.  for some reason Word wants to auto scale the axis to 120% if the value is 100%

在0-100％的条形图上？  ;如果你超过100，那么条形收缩，100％轴标记不会改变

On a 0-100% barchart?  if you exceed 100 then the bar shrinks and the 100% axis mark doesnt change

那么有没有办法在Word文档中添加一些自定义脚本？ 在填充值后修改条形图？

So is there a way to add some custom script to a word document?  To modify the barchart after its been stuffed with values?

布拉德利：）

推荐答案

嗨布拉德利罗杰斯，b


据说不幸的是，你的描述，我无法重现这个问题。我手动在Excel和Word中创建了一个100％堆积条形图，然后更改了值，但图表并不坚持缩放它。

Hi Bradley Rogers,

According to your description, unfortunately, I am not able to reproduce this issue. I have created one 100% Stacked Bar chart in Excel and Word manually, then change value, but the chart does not insist on scaling it.

更改后值：

我发现你的第一个截图不是100％Stacked Bar chart，而是Stacked Bar 。所以我建议您检查图表类型是否为100％堆积条形图。



感谢您的理解。

I find that your first screenshot is not 100% Stacked Bar chart, but Stacked Bar. So I suggest that you could check whether chart type is 100% Stacked Bar chart.

Thanks for your understanding.

这篇关于是否可以将脚本添加到条形图中以强制其Axis值？的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！