Forum Discussion

ConnieMaldonado's avatar
ConnieMaldonado
Icon for Responsive Resident rankResponsive Resident
6 years ago

Stacked Bar Chart with Multiple Activities on One Row

I need to create a bar chart that shows time intervals for activities on a bar chart.  I tried a couple of Gantt chart visuals, but I can't get an hourly timescale, and the visual sums the duration b...
Need Help
v-frfei-msft's avatar
v-frfei-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi ConnieMaldonado ,

 

There is no Hour type for current version of Gantt visual. Please vote this idea here to make it possible in future version.

 

ConnieMaldonado's avatar
ConnieMaldonado
Icon for Responsive Resident rankResponsive Resident
6 years ago

Yep, thanks.  Gantt charts are out, as none of them have an hourly time scale.  Also, none allow you to show multiple activities on one row - all the activities are shown separately.  In Excel, I had to use a stacked bar chart with 3 series - series 1: start time (with no fill so it wouldn't show), series 2: duration, series 3: 3 points representing the categories on the secondary axis (this allowed the categories to display on vertical axis).    You're basically adding both series (one that shows the entire line with no fill) and then overlaying the duration for the activity (with a color).  See image (which is from Excel).  It helps me to figure out how to get the chart to work in Excel first.  🙂  I believe I need to look for an enhanced bar chart visual. 

 

From Excel: