Google Sheets未绘制(堆叠柱状图)所有系列数据。

huangapple go评论65阅读模式
英文:

Google Sheets not plotting (stacked column chart) all my series data

问题

我开始了一个Google Sheets堆叠柱状图,显示每个"Lister"的每日销售情况。示例:

https://docs.google.com/spreadsheets/d/1NTmrTQdJnTxik6tjHi5zsx-U6giCD-_Mwj0B1vv-bbE/edit?usp=sharing

gSheets只绘制了62个可能的"系列"数据点中的15个。如何让它绘制它们全部?例如,Lister AN应该有超过2个堆叠颜色。事实上,AN应该显示11个:83058 [$19.79] 下面是83063 [$19.00] 下面是83083 [$49.99] 下面是... 83121 [$6.97]。

(1) 是因为我的数据吗?我想不出更好的组织方式。有其他方法吗?

(2) 是因为我的设置吗?
__2a. 我尝试直接从Base工作表制作图表,但gSheets需要值以Pivot1中的表格方式排列。
__2b. 当然,将行转置为列也没有任何区别(请参见Pivot2)。
__2c. 我尝试将销售记录号(ColumnA)格式化为纯文本,但没有任何效果。

文档中提供了编码解决方案。我只是一个新手。不过,如果你有一个好的教程,我可以尝试一下。

谢谢您关注此事。

英文:

I began a Google Sheets stacked column chart that shows each Lister's daily sales. Sample:

https://docs.google.com/spreadsheets/d/1NTmrTQdJnTxik6tjHi5zsx-U6giCD-_Mwj0B1vv-bbE/edit?usp=sharing

gSheets is only plotting fifteen (15) out of sixty two (62) possible "series" data points. How do I get it to plot them all? Lister AN, for instance, should have more than two (2) stacked colors. In fact, AN should have eleven (11) displayed: 83058 [$19.79] below 83063 [$19.00] below 83083 [$49.99] below... 83121 [$6.97].

(1) Because of my data? I cannot think of a better way to organize it. Is there?

(2) Because of my setup?
__2a. I tried charting directly from the Base worksheet but gSheets needs the values to be tabled like Pivot1.
__2b. Of course, transposing the rows to columns makes no difference (see Pivot2).
__2c. I tried formatting the Sales Record Number (ColumnA) as plain text but that did nothing.

The documentation are coded solutions. I am only a novice. Though, if you have a good tutorial I can do that.

Thank you for your attention to this matter.

答案1

得分: 1

已添加*此处的堆叠图表*供您查看:

您的原始图表似乎没有完整的数据范围,与链接的表格不符,导致了这个问题。

Google Sheets未绘制(堆叠柱状图)所有系列数据。

英文:

Added the stacked chart in here for you to check out:

Your original chart doesnt seem to have full data range of the table linked and is causing this amiss.

Google Sheets未绘制(堆叠柱状图)所有系列数据。

答案2

得分: 0

我可以在生成新图表并在更改格式为堆叠柱状图之前激活 [ 切换行/列 ] 之前 获得它。

我在我的实际工作簿中进行了测试,其中列表是根据当天的销售动态生成的。它有效。

问题已解决。

谢谢大家!

英文:

I can get it when generating a new chart and activating the [ Switch rows/columns ] prior to changing the format to a stacked column.

I tested this with my actual workbook, where the Listers are generated dynamically according to the day’s sales. It worked.

Problem solved.

Thanks all!

huangapple
  • 本文由 发表于 2023年6月27日 21:31:12
  • 转载请务必保留本文链接:https://go.coder-hub.com/76565404.html
匿名

发表评论

匿名网友

:?: :razz: :sad: :evil: :!: :smile: :oops: :grin: :eek: :shock: :???: :cool: :lol: :mad: :twisted: :roll: :wink: :idea: :arrow: :neutral: :cry: :mrgreen:

确定