How do I Excel chart 2 stacked values with third value as a line?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I'm attempting to plot 3 values on an Excel Chart. 1st Shift hours available
and 2nd Shift hours available as a stacked bar chart and forecast required
hours as a line on the chart.
 
Make a stacked column chart with the 3 data
Right click on one of the HOURS datapoint in the chart and select Chart type
Select Line
best wishes
 
Back
Top