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

    complex graph (EXCEL)

    Is it possible to make a line graph with two different units of measurements on the same y-axis? The x-axis is Fiscal Years, but the y-axis needs to be number of people and how much money we spent over all. Please see attachement for better clarification.

    Mommamueller
    Attached Files Attached Files

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: complex graph (EXCEL)

    Welcome to Woody's Lounge!

    You can specify that a data series should use a secondary value axis:
    - Select one of the series, then select Format | Selected Series (or double-click the series).
    - Activate the Axis tab.
    - Click 'Secondary axis'.
    - Click OK.
    The secondary axis will be displayed on the right hand side.

Posting Permissions

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