Why does my horizontal bar chart stacked not show certain values in different colors?

I am using Excel 2016 from Office 365 on Windows 10 and I can't get my horizontal bar chart (stacked) to show my 3 sets of values on each stacked bar. Can anyone help?

This is supposed to be a chart like a Gantt chart to show the progress of a progress over several months time.

I have two categories which should represent Cities and 3 sets of values - each set has a start dates and then days representing how long the project took--the actual time, the scheduled time and any holidays in between.

My data is arranged like this: Why does my horizontal bar chart stacked not show certain values in different colors?

My chart looks like this and I don't understand (the 'I need to delete' comment just means that I need to make that color clear b/c the actual work schedule starts on 4/23/2016 for City bc (it will look like a Gantt chart): Why does my horizontal bar chart stacked not show certain values in different colors?

Where are the 3 colors that should be in each bar? It should have 3 colors for City c - a bar starting from 3/29/2016 extending 10 days for actual days of project, another bar within the 1st bar from 3/29 only extending 5 days for scheduled days "", and yet another bar within the 1st bar from 4/1/2016 extending 15 days for the holidays.

Same for the City bc - a bar from 4/23 for 15 days for actual, a bar within that from 4/23 for 25 days for scheduled, and a bar within that again from 5/1/2016 for 5 days for holidays.

Here are my settings under 'Design' (when chart selected)>'Select Data' in Excel (I can't post a 3rd picture per the forum but the settings are...):
1)The whole chart is selected under Chart Data Range.
2)Legend Entries (Series):
Added start as label name - and values in column B under start (3/29/2016 and 4/23/2016 selected)
Added a 2nd entry - day as label name - and values in column B under day (10 and 15 selected)
Added a 3rd entry - start sched as label name - and values in column D under start sched (3/29/2016 and 4/23/2016 from column D)
Added a 4th entry for day sched
Added a 5th entry for start hol
Added a 6th and final entry for day hol

3) For Horizontal (Category) axis labels:
Added values in column A under Cities (c and bc)

Thank you in advance.

P.S. I tried looking via Goggle and help menu - can you upload files to Super User (my 2nd time to a Stackoverflow/Super User forum)?

Replay

Category: microsoft excel Time: 2016-07-30 Views: 0

Related post

iOS development

Android development

Python development

JAVA development

Development language

PHP development

Ruby development

search

Front-end development

Database

development tools

Open Platform

Javascript development

.NET development

cloud computing

server

Copyright (C) avrocks.com, All Rights Reserved.

processed in 2.591 (s). 13 q(s)