horizontal bar graph

%3CLINGO-SUB%20id%3D%22lingo-sub-2015672%22%20slang%3D%22en-US%22%3Ehorizontal%20bar%20graph%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2015672%22%20slang%3D%22en-US%22%3E%3CP%3EIn%20a%20horizontal%20bar%20graph%2C%20is%20it%20possible%20to%20change%20the%20starting%20point%20for%20an%20individual%20bar.%20I%20don't%20want%20all%20the%20bars%20to%20start%20at%20point%200.%20Attached%20is%20the%20graph%20I%20have%20been%20working%20on.%20Each%20horizonal%20bar%20is%20a%20patient%20and%20do%20not%20want%20them%20to%20all%20start%20on%20Day%200%20of%20the%20study.%20The%20length%20of%20the%20bar%20signifies%20duration%20of%20treatment.%20I%20am%20really%20struggling%20over%20here.%20Thanks%20!%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2015672%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2015689%22%20slang%3D%22en-US%22%3ERe%3A%20horizontal%20bar%20graph%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2015689%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F911686%22%20target%3D%22_blank%22%3E%40arshia2020%3C%2FA%3E%26nbsp%3BYou%20need%20to%20insert%20another%20data%20series%20indicating%20the%20start%20date%20of%20the%20treatment.%20Then%20create%20a%20Stacked%20Bar%20Chart%20and%20format%20the%20first%20series%20as%20transparent%20(i.e.%20no%20fill).%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3ESee%20attached.%3C%2FP%3E%3C%2FLINGO-BODY%3E
New Contributor

In a horizontal bar graph, is it possible to change the starting point for an individual bar. I don't want all the bars to start at point 0. Attached is the graph I have been working on. Each horizonal bar is a patient and do not want them to all start on Day 0 of the study. The length of the bar signifies duration of treatment. I am really struggling over here. Thanks !

1 Reply

@arshia2020 You need to insert another data series indicating the start date of the treatment. Then create a Stacked Bar Chart and format the first series as transparent (i.e. no fill).

 

See attached.