SOLVED

How can I show percentage change in a clustered bar chart?

%3CLINGO-SUB%20id%3D%22lingo-sub-2592731%22%20slang%3D%22en-US%22%3EHow%20can%20I%20show%20percentage%20change%20in%20a%20clustered%20bar%20chart%3F%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2592731%22%20slang%3D%22en-US%22%3E%3CP%3EHell%2C%20I%20have%20a%20graph%20showing%20the%20sales%20change%20from%20one%20period%20to%20the%20other%20(1qtr%202021%20to%202%20qtr%202021)%20and%20I%20would%20like%20to%20sisplay%20the%20percenatge%20change%20from%20one%20period%20to%20the%20other.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EFor%20example%20for%20%22Car%201%22%20the%20sales%20wnt%20down%2012%25%20(-12%25).%20For%20Van%203%2C%20it%20went%20up%2048%25.%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EIs%20there%20a%20way%20to%20show%20this%20in%20the%20bar%20chart%3F%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22Captura%20de%20tela%202021-07-27%20154025.png%22%20style%3D%22width%3A%20999px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F298772i7B314E9DB01F8A67%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22Captura%20de%20tela%202021-07-27%20154025.png%22%20alt%3D%22Captura%20de%20tela%202021-07-27%20154025.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2592731%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Contributor

Hell, I have a graph showing the sales change from one period to the other (1qtr 2021 to 2 qtr 2021) and I would like to sisplay the percenatge change from one period to the other. 

 

For example for "Car 1" the sales wnt down 12% (-12%). For Van 3, it went up 48%. 

 

Is there a way to show this in the bar chart?

Captura de tela 2021-07-27 154025.png

2 Replies
best response confirmed by elisape (Occasional Contributor)
Solution

@elisape Select the series for which you want to change the data label. Double-click it to open the "Format Data Labels" window. Now select "Value From Cells" (see picture below; made on a Mac, but similar on PC).

Screenshot 2021-07-28 at 06.16.35.png

Then point the range to the list of percentages. If you want to have both the value and the percent change in the label, select both Value From Cells and Values. This will create a label like:

 

-12% 1.729.711

 

Perhaps not the most elegant, so if you would want it like:

 

1.729.711

   -12%

 

you need to create a range with the texts how you want to see them in the label. This is demonstrated in the attached file where the label (column D) is a text, based on the value in column C & a linefeed (i.e. alt-Enter) & the percentage calculation.

Screenshot 2021-07-28 at 06.50.07.png

It worked perfectly
Thank you!