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 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):
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)?