Results 1 to 4 of 4

Thread: 3 Questions

  1. #1
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    London, Middlesex, England
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    3 Questions

    Hello,

    For brevity I have put the 3 questions on the sheet itself.
    Please can you download it and see if you can decipher these puzzles?

    Thank you.

    Bob.

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

    Re: 3 Questions

    The chart in your workbook is based on data in another workbook, not on the data above the chart.

    Click once on the chart to select it.
    Then select Chart | Source Data...
    Click in the Data Range box, then select A1:C13 on the worksheet.
    Click OK. This will display the series names instead of Series 1 etc.

    Next, select Chart | Chart Type...
    Change the chart type from Scatter to Line.
    Click OK. This will display the month names.

    In cell D1, enter a series title.
    In cell D2, enter =(C2-B2)/B2
    Format D2 as a percentage.
    Fill down to D14.

  3. #3
    3 Star Lounger
    Join Date
    Jan 2004
    Location
    London, Middlesex, England
    Posts
    268
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Double sided Y-Axis?

    Thanks Hans.

    Please look at the at the attached XL file.
    I have put the question into the file for brevity.

    Thanks,

    BD.

  4. #4
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Location
    Pittsburgh, Pennsylvania, USA
    Posts
    11,225
    Thanks
    14
    Thanked 342 Times in 335 Posts

    Re: Double sided Y-Axis?

    Dbl-click the magenta line to format it (axis tab) click "primary"

    now they both will be on the same scale

    Steve

Posting Permissions

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