Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Jim Garman
 
Posts: n/a
Default Custom Chart: Stacked Bar & Line

I would like to combine a stacked bar graph and line graph. I can do this
with a regular bar graph and line graph, but not with a stacked bar graph.
Any ideas on how to do this? I will use the same y-axis values for both the
line and stacked bar. Thanks, \JG
  #2   Report Post  
Jon Peltier
 
Posts: n/a
Default

Hi Jim -

Make your stacked column chart, including the data for the line series
as another stacked column. Then select this series, goto the Chart menu,
choose Chart Type, and select a Line chart style. (When you select one
series, the Chart Type adjustment only applies to that series.)

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Jim Garman wrote:

I would like to combine a stacked bar graph and line graph. I can do this
with a regular bar graph and line graph, but not with a stacked bar graph.
Any ideas on how to do this? I will use the same y-axis values for both the
line and stacked bar. Thanks, \JG

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
add line to a stacked area chart already created Mitch Charts and Charting in Excel 3 April 3rd 23 04:43 PM
Create a custom chart, two stacked bars/month w/ two axes? Oscar Charts and Charting in Excel 1 March 21st 05 11:07 PM
Custom charting - Stacked charting with a line Randy Lefferts Charts and Charting in Excel 3 March 3rd 05 03:10 AM
How do I combine a line and a percentage stacked column chart? Liza Charts and Charting in Excel 1 February 3rd 05 01:40 PM
pivot table multi line chart souris Charts and Charting in Excel 2 December 7th 04 03:56 AM


All times are GMT +1. The time now is 05:53 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"