数据在图表上仅显示为零
我有一个 Excel 工作表,其中包含数据:
这驱动了图表,但图表仅显示 0 作为数据:
我的每个单元格都是一个公式。
我尝试在单元格中写入一个值,它显示在图表中
我尝试复制数据并粘贴值,但它没有显示在图表上。
请帮忙。
I have an excel sheet with data in it:
That drives a chart, but the chart only shows 0 as data:
Each of my cell is a formula.
I tried to write a value in a cell and it shows in the chart
I tried to copy the data and paste values, but it doesn't show on the chart.
Please help.
如果你对这篇内容有疑问,欢迎到本站社区发帖提问 参与讨论,获取更多帮助,或者扫码二维码加入 Web 技术交流群。
绑定邮箱获取回复消息
由于您还没有绑定你的真实邮箱,如果其他用户或者作者回复了您的评论,将不能在第一时间通知您!
发布评论
评论(1)
您没有共享公式,除了公式栏的屏幕截图中非常小的公式之外。从我可以看到的位(文本运算符“RIGHT”和“LEFT”),我可以看出它正在返回文本,即存储为文本的数字。 Excel 将文本绘制为零。
将公式更改为
=VALUE(此处不带等号的当前公式)
为了确保不将数字存储为文本,您永远不应该居中对齐数字单元格。保留默认格式。数字向右调整,文本向左调整。您可以立即发现问题。
You didn't share the formula, except for very tiny in the screen shot of the formula bar. From the bits I can see (text operators "RIGHT" and "LEFT"), I can tell that it is returning text, that is numbers stored as text. Excel charts text as zeros.
Change the formula to
=VALUE(your current formula here without the equals sign)
To make sure you don't store numbers as text, you should never center align your numerical cells. Keep the default formatting. Numbers are right-adjusted, text is left-adjusted. You can detect a problem instantly.