Hi all, First time user. I'm trying to produce a bar chart that shows a stack type arrangement and some method of a single data point along the overall bar. Name Date 1 Date 2 Date 3 Date 4 Smith 25/01/2007 10/02/2010 11/01/2000 30/12/2010 Jones 10/10/2003 5/05/2007 20/03/2010 30/12/2009 Brown 14/06/2015 21/09/2016 15/10/2019 1/10/2019 I'm trying to get the a horizontal chart that shows Dates 1, 2 and 3 as a stacked bar. For date 4 I just want a "mark" on the overall bar. It was suggested to me to insert an error bar but I don't even know what that is. This marker may sit anywhere the date 2 or date 3 areas. I'm using Excel 2007. Thanks

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Chart Problems

Thread starter Pixie123
Start date Jun 6, 2018
Tags

bar chart date insert shows

Pixie123

New Member

Jun 6, 2018

Hi all,
First time user.
I'm trying to produce a bar chart that shows a stack type arrangement and some method of a single data point along the overall bar.

Name	Date 1	Date 2	Date 3	Date 4
Smith	25/01/2007	10/02/2010	11/01/2000	30/12/2010
Jones	10/10/2003	5/05/2007	20/03/2010	30/12/2009
Brown	14/06/2015	21/09/2016	15/10/2019	1/10/2019

I'm trying to get the a horizontal chart that shows Dates 1, 2 and 3 as a stacked bar. For date 4 I just want a "mark" on the overall bar. It was suggested to me to insert an error bar but I don't even know what that is. This marker may sit anywhere the date 2 or date 3 areas.

I'm using Excel 2007.

Thanks