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.
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!