Feldlisten unterschiedlich in Table und Chart

%3CLINGO-SUB%20id%3D%22lingo-sub-2330572%22%20slang%3D%22de-DE%22%3EField%20lists%20different%20in%20table%20and%20chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2330572%22%20slang%3D%22de-DE%22%3E%3CP%3EHello%20everyone%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eis%20it%20possible%20to%20create%20different%20field%20lists%20in%20PivotTable%20and%20PivotChart%3F%3C%2FP%3E%3CP%3EI%20want%20to%20omit%20a%20value%20in%20the%20chart%20without%20deleting%20it%20from%20the%20table.%3C%2FP%3E%3CP%3EHow%20do%20I%20do%20this%3F%3C%2FP%3E%3CP%3EThe%20background%20is%20that%20this%20value%20is%20much%20greater%20than%20the%20other%20values.%20This%20makes%20it%20possible%20to%20read%20the%20diagram.%3C%2FP%3E%3CP%3EThank%20you%20for%20your%20help%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2330572%22%20slang%3D%22de-DE%22%3E%3CLINGO-LABEL%3EBI%20%26amp%3B%20Data%20Analysis%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2330634%22%20slang%3D%22en-US%22%3ERe%3A%20Feldlisten%20unterschiedlich%20in%20Table%20und%20Chart%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2330634%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1046671%22%20target%3D%22_blank%22%3E%40Julie110%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EYou%20need%20to%20build%20it%20separately.%20On%20ribbon%20Insert-%26gt%3BPivotChart%20only.%3C%2FP%3E%0A%3CP%3E%3CSPAN%20class%3D%22lia-inline-image-display-wrapper%20lia-image-align-inline%22%20image-alt%3D%22image.png%22%20style%3D%22width%3A%20386px%3B%22%3E%3CIMG%20src%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fimage%2Fserverpage%2Fimage-id%2F278717i7EA100FE9F52D291%2Fimage-size%2Flarge%3Fv%3Dv2%26amp%3Bpx%3D999%22%20role%3D%22button%22%20title%3D%22image.png%22%20alt%3D%22image.png%22%20%2F%3E%3C%2FSPAN%3E%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Hallo zusammen,

 

ist es möglich unterschiedliche Feldlisten in PivotTable und PivotChart zu erstellen?

Ich möchte einen Wert im Chart weglassen, ohne dass er aus dem Table gelöscht wird.

Wie mache ich das?

Hintergund ist, dass dieser Wert viel größer ist, als die übrigen Werte. Dadurch kann man das Diagramm nicht lesen.

Vielen Dank für eure Hilfe

 

1 Reply

@Julie110 

You need to build it separately. On ribbon Insert->PivotChart only.

image.png