Data Points on Chart Don't Align with Data Table

%3CLINGO-SUB%20id%3D%22lingo-sub-2152809%22%20slang%3D%22en-US%22%3EData%20Points%20on%20Chart%20Don't%20Align%20with%20Data%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2152809%22%20slang%3D%22en-US%22%3E%3CP%3EData%20table%20does%20not%20line%20up%20with%20chart.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2152809%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EOffice%20365%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2153282%22%20slang%3D%22de-DE%22%3ESubject%3A%20Data%20Points%20on%20Chart%20Don't%20Align%20with%20Data%20Table%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2153282%22%20slang%3D%22de-DE%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F973478%22%20target%3D%22_blank%22%3E%40carpemoment%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EWhat%20I%20have%20done%20wrong%3F%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EThe%20graph%20does%20not%20match%20the%20data%3F%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EThe%20answer%3A%20They%20accidentally%20chose%20a%20type%20that%20scales%20the%20data%20to%20100%25.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EThis%20causes%20one%20row%20to%20appear%20at%20the%20top%20-%20the%20others%20are%20cumulated.%3C%2FSPAN%3E%3C%2FSPAN%3E%20%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EThe%20solution%3A%20use%20the%20first%20type%20-%20%22line%22%20and%20not%20%22stacked%20line%20100%25%22.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Fdatamgmt.ucsc.edu%2Fhelp-training%2Finfoview-help%2Fhow-do-i%2Fformat-reports%2Freport-elements%2Falign-elements.html%22%20target%3D%22_self%22%20rel%3D%22nofollow%20noopener%20noreferrer%22%3EAlign%20Tables%2C%20Cells%20and%20Charts%3C%2FA%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%3CSPAN%20class%3D%22VIiyi%22%3E%3CSPAN%20class%3D%22JLqJ4b%20ChMk0b%22%3E%3CSPAN%3EIt%20would%20be%20best%20if%20you%20insert%20a%20file%20(without%20sensitive%20data)%20in%20order%20to%20be%20able%20to%20offer%20a%20safe%20and%20correct%20solution%20proposal.%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FSPAN%3E%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EI%20would%20be%20happy%20to%20know%20if%20I%20could%20help.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ENikolino%3C%2FP%3E%3CP%3EI%20know%20I%20don't%20know%20anything%20(Socrates)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E*%20Kindly%20Mark%20and%20Vote%20this%20reply%20if%20it%20helps%20please%2C%20as%20it%20will%20be%20beneficial%20to%20more%20community%20members%20reading%20here.%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3C%2FLINGO-BODY%3E
Occasional Visitor

Data table does not line up with chart.

1 Reply

@carpemoment 

 

What I have done wrong? The graph does not match the data? The answer: They accidentally chose a type that scales the data to 100%. This causes one row to appear at the top - the others are cumulated. The solution: use the first type - “line” and not “stacked line 100%”.

 

Align Tables, Cells and Charts

 

It would be best if you insert a file (without sensitive data) in order to be able to offer a safe and correct solution proposal.

 

I would be happy to know if I could help.

 

Nikolino

I know I don't know anything (Socrates)

 

* Kindly Mark and Vote this reply if it helps please, as it will be beneficial to more Community members reading here.