Search code examples
google-sheetschartsstacked-chartdynamic-chart-series

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


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.


Solution

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