数据标签Google电子表格柱形图 [英] Data label Google spreadsheet Column chart

问题描述

我已经在Google电子表格中创建了一个柱状图，但并未明确显示数据标签。

我需要将数据值显示在每个柱形图柱的顶部。目前，这只显示为工具提示，但我要求它始终可见。

我没有使用任何直接创建它的脚本，请提供一些方法通过脚本/直接执行数据标签。只有直接/应用程序脚本，但没有Java脚本，因为我只需要在我的电子表格中查看它。

这里是工作表链接： https://docs.google.com/spreadsheets/d/1a95DrTeLA52Xmycq3IUlWgfqASQWJQla7xEXx5-KWGE/edit?usp=sharing

解决方案

您现在可能已经找到了解决方案，但为了万一它可能对其他人有帮助，这里是我的响应。

您分享的工作表对帮助您解决问题很有用。以下是获取列顶部数据标签值的步骤。

• 右键单击图表。
>

• 点击高级编辑。 （这将打开一个名为Chart Editor的新窗口）
您会在下方看到数据标签。

• 点击下拉菜单。 （这将打开一个选项列表）


• 从这个选项列表中选择值。
  
• 点击更新，你会看到
  

让我知道您是否有任何问题。

I have created a column chart in Google spreadsheet, but it is not showing data label explicitly.

I need data value to be shown on top of each bar of column chart. Currently, that is showing only as tool tip, but I require it to be always visible.

I have not used any script just created it directly, please provide some way either by script/direct to implement data labels. only direct / apps script but no java script as I only need to view it on my spreadsheet.

here is link of sheet: https://docs.google.com/spreadsheets/d/1a95DrTeLA52Xmycq3IUlWgfqASQWJQla7xEXx5-KWGE/edit?usp=sharing

解决方案

You may have found the solution by now but just in case it might be helpful to others, here's my response.

Your sharing of sheet was useful in helping you with your question. Here are the steps to get the values for the data labels on the top of your columns.

• Right click on the chart.
• Click on Advanced Edit. (This will open a new window named "Chart Editor")
• Click on "Customization" tab.
• Drag the bar and keep going down until you see "Data Labels" with a drop down below it.
• Click on the drop down. (This will open a list of options)
• Choose "value" from this list of options.
• Click "Update" and you'll see the change in your graph.

Let me know if you have any questions.

这篇关于数据标签Google电子表格柱形图的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！