Forum Discussion
Don't Summarize in bar chart?
I have data that includes a product name, price and how long it took to sell (see table below).
I create a stacked bar chart and put Price in Y axis and Time to Sell in the X axis. However, it will combine items - e.g. Sprocket B and C - that have the same values.
How can I get it to display each column as unique product? I'm able to do this with the Scatterplot as I can choose Don't Summarize in both axis. How can I get that same functionality in the bar chart?
I read this post and understand it's a possibility, but it seems in that case that I'd have to replace a unique column ID for either x or y axis, which I don't want to do. Appreciate any help on this.
| Product Name | Price | Time to sell |
| Sprocket A | $100 | 20 |
| Sprocket B | $200 | 40 |
| Sprocket C | $200 | 25 |
| Sprocket D | $150 | 50 |
| Sprocket E | $125 | 10 |
Is this what you are looking for?
9 Replies
- Ahmedx
Super User
Is this what you are looking for?
Yes, that works. It looks like the solution is to create a column and use this: Column = REPT(UNICHAR(8203),[Time to sell]).
Can you explain why that works? I did some digging and understand what REPT and see what it does but it's still not clear to me on why it works in this context.
- Ahmedx
this is the formula = UNICHAR(8203), this is a zero width space.
REPT (UNICAR(8203), [Time to Sell]) - here we repeat this several times .
and so when we pass this along the Y axis, it will not be read, but it will create a uniqueness for each row.
- Ashish_Mathur
Hi,
Drag Product name to the legend.
