Results 1 to 5 of 5
  1. #1
    Star Lounger
    Join Date
    Mar 2007
    Location
    Dexter, USA
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Graphs (Excel 2007)

    I have been using Excel 2000 and things are laid out differently in 2007. I would like to create a line graph with a column on 2 Axes. Can someone, in simple terms, tell me how I locate that?

  2. #2
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Graphs (Excel 2007)

    Have a look at http://www.peltiertech.com maybe Jon has written something about doing this in 2007.
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

  3. #3
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts

    Re: Graphs (Excel 2007)

    You have to do it manually, I think. Create a line chart using both series. Select the series you want to be a column, right-click, choose 'Change series chart type' and select a column type. Then right-click again, choose 'Format data series' and choose Secondary axis.
    HTH
    Regards,
    Rory

    Microsoft MVP - Excel

  4. #4
    Star Lounger
    Join Date
    Mar 2007
    Location
    Dexter, USA
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Graphs (Excel 2007)

    This is a great site. Thanks!

  5. #5
    Star Lounger
    Join Date
    Mar 2007
    Location
    Dexter, USA
    Posts
    90
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Graphs (Excel 2007)

    That works! Thanks.

Posting Permissions

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