How to create a chart with Stacking colums and lines with 2 axes

Discussion in 'Microsoft Excel Charting' started by Guest, Feb 17, 2005.

  1. Guest

    Guest Guest

    I am trying to create an Excel Graph (I have 2000 version) that is composed
    of stacking columns (primary axis) and a line (secondary axis). I have seen
    that graph before in some financial reports but I haven't been able to find
    the template in Microsoft website or any company that developed that chart.
    Any ideas?
     
    Guest, Feb 17, 2005
    #1
    1. Advertisements

  2. Guest

    Jon Peltier Guest

    Forget the template, just do the chart. Plot all three series in a
    stacked column chart, then select one series, and use Chart Type from
    the Chart menu to change it to a Line type series.

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

    JGVOSS wrote:

    > I am trying to create an Excel Graph (I have 2000 version) that is composed
    > of stacking columns (primary axis) and a line (secondary axis). I have seen
    > that graph before in some financial reports but I haven't been able to find
    > the template in Microsoft website or any company that developed that chart.
    > Any ideas?
     
    Jon Peltier, Feb 18, 2005
    #2
    1. Advertisements

Want to reply to this thread or ask your own question?

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Replies:
    1
    Views:
    212
    Jon Peltier
    Feb 14, 2006
  2. Vertical Lines on the Lines on 2 Axes Chart

    , Mar 1, 2006, in forum: Microsoft Excel Charting
    Replies:
    3
    Views:
    417
    Jon Peltier
    Mar 3, 2006
  3. Jay

    Show 'incomplete' axes & show ticks but NOT axes?

    Jay, Jun 13, 2006, in forum: Microsoft Excel Charting
    Replies:
    1
    Views:
    411
    Andy Pope
    Jun 13, 2006
  4. Replies:
    4
    Views:
    1,302
  5. Guest

    Stacking data without stacking everything

    Guest, Aug 23, 2007, in forum: Microsoft Excel Charting
    Replies:
    1
    Views:
    351
    Jon Peltier
    Aug 24, 2007
Loading...

Share This Page