2 Y Axes: Lines and a Stacked Column


    Sponsored Links


  • 1. Creating data labels in XY charts
    I'm developing an XY chart, and I'd like have to have labels next to the data points. Is this possible? For example, the labels could be the names of cities, while the X and Y data might be the popluation and housing prices. Thanks, Robert Ades -- ___________________________ Robert Ades Accountancy Corp. 12100 Wilshire Blvd., Suite 660 Los Angeles, CA 90025 Tel: 310-571-1224 Fax: 310-571-1227 XXXX@XXXXX.COM
  • 2. Stacked and single column in same chart?
    How can I do a chart with a stacked column beside a single column? When I build a stacked column chart, any new source data I add wants to put it in the same stacked column.
  • 3. Linking Y Axis
    Hi in your chart select the title box, click F2, enter the equation sign '=' and then select your source cell "EnergyMike" < XXXX@XXXXX.COM > schrieb im Newsbeitrag news: XXXX@XXXXX.COM ... > Is there any way to link the title of the Y axis to a referenced cell value? > Mike
  • 4. help!save my job...charting time is causing me headache!
    :confused: Hi there! I have a problem charting some data.... Column A: I have values of 1 through 23 (these are cycles in m business) Column B: I have a different time value associated with coresspondin cycle in format H:mm Example: cycle 1 took 29:55 (29hours and 55minutes) I need to display as a graph/chart for tomorrow am! Y axis are my cycles X axis should be intervals of time in increments of 5 hours Is it not charting properly because time is displayed H:mm- does i need to be decimal format? Also, the data i am grabbing is from cell that have formulas attached, so does that cause a problem....? Thanks everybody!:) PS: I am not at work now-so cant attach file for review, but will sen to anyone willing to help in the a

2 Y Axes: Lines and a Stacked Column

Postby amFzNTgw » Fri, 08 May 2009 02:46:10 GMT


I'm using Excel 2003 SP3 and having trouble with the following...

Sample data:

X Axis      Y Axis1    Y Axis1    Y Axis2    Y Axis2    Y Axis2
Date         DataA     DataB       DataC      DataD      DataE
1/31/09      4.3          3.6         10%        40%        50%
2/28/09      2.9          1.9         30%        60%        10%
3/31/09      1.2          6.4         15%        10%        75%

I need Y Axis1 to be two simple lines and Y Axis2 a stacked column that sums 
to 100%.  Can't figure this out.  Please advise...



Re: 2 Y Axes: Lines and a Stacked Column

Postby Jon Peltier » Fri, 08 May 2009 05:16:21 GMT

First, clear the cell above the dates, so the top left cell is blank.

Since more than half of the Y data will be stacked 100% columns, make a 
chart of this type using your data.

Right click on series 1 (Data A), choose Chart Type, and select a line. 
Repeat with series 2 (Data B).

Right click on series 3, choose Format Series, in Excel 2003 or earlier 
choose Secondary on the Axes tab, in Excel 2007 it's on the main tab. Repeat 
for series 4 and 5.

- Jon
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services, Inc.

Similar Threads:

1.Line column on 2 axes - stacked columns data not stacking


I am running Excel 2003.

I am creating a line column chart on 2 axes.  Revenue is on second y-
axis; headcount on first y-axis.

Headcount is grouped into a number of categories (13).  I would like
to have each of the 13 categories as a stacked column.  However, when
I try and stack the 13 categories, it works only as far as the 6th

Can anyone suggest a solution.


2.line - stacked column chart on 2 axis

3.Adding a second line on a two axis column stacked chart

I have a stacked bar graph showing 4 data series on the x-
axis with a line showing 1 data series on the secondary  

Now I want to add a second line to the secondary axis

When I do so it automatically becomes a bar instead of a 
line, regardless which axis I am plotting it on. 

Is there anyone out there that knows what I am doing 
wrong and/or what the trick is ? 

4.how do I create a chart on two axes with stacked columns and line

I am struggling to create a chart that combines stacked columns on one X axis 
with a line on a second axis. Both are available as standard charts.

5.Line Column on 2 axes that shows stacked colums

I am able to creat a line column graph on 2 axes.  That shows $ as columns 
and % as a line.

However I wnat the colunms to be stacked colums.  Can this be done?

6. TypeName:="Line - Stacked Column on 2 Axes" ???

7. How do I do a combination STACKED column and line chart on 2 axis

8. stacked column and non-stacked single line

Return to MS EXCEL


Who is online

Users browsing this forum: No registered users and 3 guest