Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
external usenet poster
 
Posts: 1
Default How do I Excel chart 2 stacked values with third value as a line?

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.
  #2   Report Post  
Posted to microsoft.public.excel.charting
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel Line Chart help Springsteen Excel Discussion (Misc queries) 0 August 1st 06 04:50 PM
How do I add a goal line to a stacked bar chart in excel? rheinzy Charts and Charting in Excel 2 May 20th 06 01:26 AM
Unwanted Zeros in Excel Chart Displayed Values Daniel Compton Excel Discussion (Misc queries) 4 April 25th 06 04:07 PM
Sorting values in a bar chart Eric D Charts and Charting in Excel 4 April 17th 06 04:44 PM
How do I get a value of a calculated point on an excel line chart? klc6778 Charts and Charting in Excel 3 September 26th 05 02:17 AM


All times are GMT +1. The time now is 01:14 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"