3 Replies Latest reply on Nov 19, 2018 12:12 PM by Garima Vohra

# Y axis adding values for stacked charts, can it not add them?

Hello,

In my stacked chart, I have 3 different customers with samples sent every month. One example such as customer 1 = 10 samples , customer 2 =20, customer 3= 50. When I plot them in a stacked chart say January with the numbers I said above, on Y - axis the January numbers touch 80th mark. But customer 3 has 50 and customer 2 has 20. Y axis is Summing the values 10+20+50. Is there a way I could adjust Y-axis marks to show where the numbers actually belong?

one more example

Thanks,

Garima

• ###### 1. Re: Y axis adding values for stacked charts, can it not add them?

Garima- Sorry, I really don't understand your question. Could explain it a bit with some sample workbook attached?

• ###### 2. Re: Y axis adding values for stacked charts, can it not add them?

So, if I understand, it looks like you have something like this (I'm using Superstore):

But, this is a stacked bar, so it stacks on on top of the other. The total bar length is the sum of each piece of the bar. But, you can turn off stacking by going to Analysis then Stack Marks then Off. With my example, you'd then see this:

Because of the Z-Order of my view, the Consumer bar is covering the others. We can adjust this so that the smaller bar is always on top by right-clicking on Segment then choosing Sort, then doing a "Field" based sort. Something like this:

The result is like this.

Unfortunately, this can be misleading because it looks like a normal stacked bar, so people may not realize each bar starts at zero, so you can play with the width of the bars to help mitigate this problem. For instance, drop Number of Records on the Size card.

Now, you can see that this isn't a typical stacked bar.

One final, and probably better, option would be to do a side-by-side bar chart. Just move the Segment pill up to rows (after the Date).

See attached workbook.

1 of 1 people found this helpful
• ###### 3. Re: Y axis adding values for stacked charts, can it not add them?

So cool.. Thank you, Ken!! I am going to mark it right.