英文:
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
已添加*此处的堆叠图表*供您查看:
您的原始图表似乎没有完整的数据范围,与链接的表格不符,导致了这个问题。
英文:
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.
答案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!
通过集体智慧和协作来改善编程学习和解决问题的方式。致力于成为全球开发者共同参与的知识库,让每个人都能够通过互相帮助和分享经验来进步。
评论