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

525 Views Asked by At

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.

2

There are 2 best solutions below

0
On BEST ANSWER

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!

3
On

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.

enter image description here