Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Is there a simple way to the display the the sum of a stacked bar above it, similar to checking 'Values on Data Points' for a Bar Chart?
When checking 'Values on Data Points' for a Stacked Bar Chart, the values are displayed for each area, but I only want to see a total for the entire stacked bar.
Any suggestions would be appreciated.
B
Choose Properties.
On the Presentation tab, uncheck Plot Values Inside Segments
Choose Properties.
On the Presentation tab, uncheck Plot Values Inside Segments
Thanks for the quick response.
Also, great avatar.
B
Hi,
is it possible to have both at the same time?
"Plot values inside Segments" seems to override "Values on Data Points".
greets Frank
u can do it by keeping the expression and select show values and select invisble ..play around with it ..it should work
Hi Srikanthsri1,
could you perhaps post a little example?
I don't understand what you mean, the bars just disappear.
greets Frank
just have two same exp. in expresssion tab just select invisble for one and select values on data points
Hi,
attached an example, the second expression disabled, because it splits out the stacked bar.
can you take a look please?
I need Values inside the segments as well as totals on top.
greets Frank
EDIT: Typo
sry to say right now i'm working on trail version so , i can't open ur atachment
I want the numbers inside the segments and total on top at the same time.