Results 1 to 4 of 4
  1. #1
    Lounger
    Join Date
    Jan 2003
    Location
    Omaha, Nebraska, USA
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    'Split Axis' Charting (Excel 97, SR-1)

    I would like to create a simple line chart with two series of values on the "Y" axis. One series with a range of $800,000 to $1,400,000 (Sales) and the other with a range of 80 to 140 (Inventory Items). The "X" axis is a simple monthly time line. Is there a way to "split" the values on the "Y" axis so my boss can see both values plotted on the same chart?

  2. #2
    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: 'Split Axis' Charting (Excel 97, SR-1)

    You can format one as the secondary axis and it will have the axis on the right. (format date series - axis tab)

    Steve

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

    Re: 'Split Axis' Charting (Excel 97, SR-1)

    Yes. First, create the chart the normal way. Then, select one of the two series and select Format | Selected Data Series. In the Axes tab of the Format Data Series dialog, specify that the series is to be plotted on the Scondary axis. Confirm by clicking OK. You can format the primary and secondary axes independently of each other.

  4. #4
    Lounger
    Join Date
    Jan 2003
    Location
    Omaha, Nebraska, USA
    Posts
    40
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: 'Split Axis' Charting (Excel 97, SR-1)

    Thanks for the quick response. Your suggestion looks like the answer I needed. Sorry I didn't find "secondary axis" in my Excel Bible before sending out a plea for help.

Posting Permissions

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