Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.charting
rwtuning
 
Posts: n/a
Default How do I do a combination STACKED column and line chart on 2 axis

I want to have a combination chart on 2 axis. I want the columns to be
stacked. I want the line to be on a second Y axis....please help!
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope
 
Posts: n/a
Default How do I do a combination STACKED column and line chart on 2axis

Hi,

Create the chart using all the data as a stacked column chart.
Double click the series that you want as a line on the secondary axis.
On the Axes tab select Secondary axis. The right click the series and
pick Chart type to change it the required line chart type.

Cheers
Andy

rwtuning wrote:
I want to have a combination chart on 2 axis. I want the columns to be
stacked. I want the line to be on a second Y axis....please help!


--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
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
Combine stacked column and line chart w/series lines ancillaries Charts and Charting in Excel 1 April 7th 06 11:51 PM
combination stacked column and line data Cowtoon Charts and Charting in Excel 6 January 10th 06 07:31 PM
creating a bar graph Johnfli Excel Discussion (Misc queries) 0 October 26th 05 08:16 PM
How do i add a line graph onto a stacked column chart using data Nicola Charts and Charting in Excel 1 October 6th 05 04:03 PM
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


All times are GMT +1. The time now is 02:01 AM.

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"