Results 1 to 2 of 2

Thread: Chart

  1. #1
    Join Date
    May 2004
    Posts
    25

    Unanswered: Chart

    Hello,

    I need to create a chart with two y axis.
    First y axis ranges from 10 to 100 and second one from 100 to 1000.
    X axis values ranges from 1 to 12 for both y axis.

    Is it possible to create such a chart in MS Excel?

    Thanks for your help
    DJ

  2. #2
    Join Date
    Apr 2004
    Location
    Derbyshire, UK
    Posts
    789
    Provided Answers: 1
    Hi

    From Excel help

    When the range of values for different data series varies widely, or when you have mixed types of data (such as price and volume), you can plot one or more data series on a secondary value (y) axis. The scale of the secondary axis reflects the values for the associated series.To plot a data series along a secondary axis, click the series, and then click Data Series on the Format menu. Click the Axis tab, and then click Secondary axis.

    (From Excel97)

    HTH

    MTB

Posting Permissions

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