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

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.
 
B

Bernard Liengme

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Stacked Line Chart 3
3D stacked bar and line chart on same graph 2
Stacked Column Chart 3
How can I combine a stacked column chart and line chart? 1
Removing 0 in Stacked Column Chart 1
Double Stacked Bar with Line Chart 4
How can i create a 2-D stacked column within a 4 series stock char 6
2007 move axis label & add zero line 1

Top