Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old February 7th 07, 03:11 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 1
Default Double-stacked Bar Chart WITH a Secondary Y Axis Line chart?

How can I create a double stacked bar chart w/ a secondary Y-axis line chart?
I've read and understand the "Column Chart with a Difference" example he
http://people.stfx.ca/bliengme/ExcelTips/Columns.htm. But, need to go the
step further, to have a % displayed on the secondary Y axis.

  #2   Report Post  
Old February 7th 07, 05:32 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 1,071
Default Double-stacked Bar Chart WITH a Secondary Y Axis Line chart?

The general rule in all such cases -- keep in mind it is *not* universal --
is to create whatever kind of chart you want. Then, select the series you
want to move to the secondary axis and change its type with Chart | Chart
Type... Next, move it to the secondary axis by double-clicking the series,
selecting the Axis tab and selecting 'secondary axis'.
--
Regards,

Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach


"lpenndorf" wrote:

How can I create a double stacked bar chart w/ a secondary Y-axis line chart?
I've read and understand the "Column Chart with a Difference" example he
http://people.stfx.ca/bliengme/ExcelTips/Columns.htm. But, need to go the
step further, to have a % displayed on the secondary Y axis.



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
TO CREATE A LINE CHART WITH RATE IN Y AXIS & REAL TIME IN X AXIS vijaicbe Charts and Charting in Excel 4 November 9th 06 11:16 AM
How can I add a line chart in a stacked column chart style? Guilherme Loretti Excel Discussion (Misc queries) 0 August 3rd 06 01:46 AM
Excel chart draws line outside Y axis pc Charts and Charting in Excel 2 July 24th 06 01:36 AM
Line Chart Axis Reversal AdamP Charts and Charting in Excel 1 January 11th 06 06:02 PM
Custom Line Graph on 2 axes help nevs Charts and Charting in Excel 4 October 27th 05 03:29 PM


All times are GMT +1. The time now is 07:30 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017