Pivot chart label

%3CLINGO-SUB%20id%3D%22lingo-sub-2886893%22%20slang%3D%22en-US%22%3EPivot%20chart%20label%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2886893%22%20slang%3D%22en-US%22%3E%3CP%3EHI%2C%20I%20want%20to%20create%20a%20pivot%20chart%20but%20I%20want%20to%20use%20a%20different%20column%20for%20the%20label%20which%20is%20made%20of%20the%20concatenate%20value%20of%202%20columns.%20Can%20this%20be%20done%3F.%20By%20using%20Format%20Data%20Labels%20and%20Value%20From%20Cells%20(select%20Range)%20is%20not%20working%20as%20this%20option%20will%20be%20giving%20the%20value%20of%20the%20data%20in%20order%20and%20not%20taking%20into%20account%20the%20different%20filters%20in%20the%20pivot%20chart%20data.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22nparenas_0-1635265412866.png%22%20style%3D%22width%3A%20400px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F320067iE5EC8D9D8166C7C3%2Fimage-size%2Fmedium%3Fv%3Dv2%26amp%3Bpx%3D400%22%20role%3D%22button%22%20title%3D%22nparenas_0-1635265412866.png%22%20alt%3D%22nparenas_0-1635265412866.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2886893%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E
Occasional Visitor

HI, I want to create a pivot chart but I want to use a different column for the label which is made of the concatenate value of 2 columns. Can this be done?. By using Format Data Labels and Value From Cells (select Range) is not working as this option will be giving the value of the data in order and not taking into account the different filters in the pivot chart data.

 

nparenas_0-1635265412866.png

 

0 Replies