Thread: How do I Excel chart 2 stacked values with third value as a line?
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Bernard Liengme Bernard Liengme is offline
external usenet poster
  
Posts: 4,393
Default How do I Excel chart 2 stacked values with third value as a line?
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
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"chartnovice" wrote in message
...
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.


Reply With QuoteReply With Quote