Cluster Bar Graph - Bars not aligning with data

%3CLINGO-SUB%20id%3D%22lingo-sub-1744049%22%20slang%3D%22en-US%22%3ECluster%20Bar%20Graph%20-%20Bars%20not%20aligning%20with%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1744049%22%20slang%3D%22en-US%22%3EHello%2C%3CBR%20%2F%3E%3CBR%20%2F%3EI'm%20building%20a%20Clustered%20bar%20graph%20where%20the%20value%20is%20time.%3CBR%20%2F%3E%3CBR%20%2F%3EI'm%20having%20an%20issue%20where%20the%20bars%20aren't%20aligning%20properly.%3CBR%20%2F%3EThe%20longest%20time%20is%20%5B21%3A36%5D%2C%20which%20is%20the%20end%20of%20graph.%3CBR%20%2F%3EThere%20are%203%20bars%20that%20are%20extending%20to%20the%20end%20of%20the%20graph%2C%20but%20the%20times%20reflected%20are%20all%20%26lt%3B5%3A00.%3CBR%20%2F%3EThe%20bar%20that%20should%20be%20at%20the%20end%20of%20the%20graph%20is%20not%2C%20it's%20closer%20to%20what%20would%20be%2020%3A45.%3CBR%20%2F%3E%3CBR%20%2F%3EAny%20ideas%20on%20why%20this%20is%20happening%20and%20how%20to%20fix%20it%3F%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-1744049%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3ECharting%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1762556%22%20slang%3D%22en-US%22%3ERe%3A%20Cluster%20Bar%20Graph%20-%20Bars%20not%20aligning%20with%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1762556%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F819792%22%20target%3D%22_blank%22%3E%40Nezzu%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Eplease%20provide%20us%20with%20the%20excel%20sheet%20(or%20an%20example)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3Ewhy%20don't%20you%20transform%20time%20into%20a%20number%3F%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-1762576%22%20slang%3D%22en-US%22%3ERe%3A%20Cluster%20Bar%20Graph%20-%20Bars%20not%20aligning%20with%20data%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-1762576%22%20slang%3D%22en-US%22%3E%3CP%3EHello%26nbsp%3B%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F746148%22%20target%3D%22_blank%22%3E%40Ramiz_Assaf%3C%2FA%3E%26nbsp%3B%3CBR%20%2F%3E%3CBR%20%2F%3E%3C%2FP%3E%3CP%3EThere%20are%20two%20images%20attached%20to%20the%20post%20for%20reference.%3CBR%20%2F%3EThe%20purpose%20of%20the%20sheet%20is%20to%20display%20call%20time%20averages%3C%2FP%3E%3C%2FLINGO-BODY%3E
Highlighted
New Contributor
Hello,

I'm building a Clustered bar graph where the value is time.

I'm having an issue where the bars aren't aligning properly.
The longest time is [21:36], which is the end of graph.
There are 3 bars that are extending to the end of the graph, but the times reflected are all <5:00.
The bar that should be at the end of the graph is not, it's closer to what would be 20:45.

Any ideas on why this is happening and how to fix it?
3 Replies
Highlighted

@Nezzu 

 

please provide us with the excel sheet (or an example)

 

why don't you transform time into a number?

Highlighted

Hello @Ramiz_Assaf 

There are two images attached to the post for reference.
The purpose of the sheet is to display call time averages

Highlighted

@Nezzu 

 

see the file attached

 

I think the problem is with the PM and AM

 

input the time as 00:00:00  hh:mm:ss

 

It will be solved