Results 1 to 2 of 2
  1. #1
    New Lounger
    Join Date
    Aug 2002
    Posts
    1
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Combination charts (2000)

    I am working on a chart that contains an initial investment amount and a follow-on investment for each quarter from 4Qtr99 to 1Qtr02. I need these first two sets of data in a stacked column. The third set of data is the number of deals for each quarter. This information needs to be on a line and the secondary axis. What is the fastest way to do this? I am having trouble figuring out how to use a stacked column chart and add a second axis. See the attached sheet.
    Attached Files Attached Files

  2. #2
    2 Star Lounger
    Join Date
    May 2002
    Location
    Midland, Michigan, USA
    Posts
    133
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Combination charts (2000)

    Is this what you're looking for? If so, I just added all three series of data to the 100% Stacked Column chart, and then selected the Number of Deals series, and changed it's chart type to Line. From there, double-click the Number of Deals series, choose the Axis tab, and click Secondary Axis.
    HTH
    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •