Results 1 to 3 of 3
  1. #1
    2 Star Lounger
    Join Date
    May 2002
    Location
    Bristol, Avon, England
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Adding secondary axis series to pivot chart (XP)

    I have a pivot chart but I want to plot another data series on a secondary axis. The secondary data series is not from the pivot data.

    Can this be done?

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

    Re: Adding secondary axis series to pivot chart (XP)

    You can't add other data to a pivot chart. You can, however, create a 'normal' chart based on the pivot table data, and add other data to this chart, to be plotted on a secondary axis.

    To create a 'normal' chart based on the pivot table, and add another series:
    1. <LI>Select an empty cell somewhere outside the pivot table.
      <LI>Create a new chart, select the chart type, then click Finish. (The chart will be blank)
      <LI>Either
      <UL><LI>Select the data area of the pivot table, and drag it (by one of its borders) into the chart, or
      <LI>With the chart selected, point to Chart | Add Data..., then point to the data area of the pivot table
    <LI>Use the same method to add another series, based on data outside the pivot table.
    <LI>With this new series selected, point to Format | Selected Data Series..., activate the Axis tab and specify Secondary Axis.[/list]See Jon Peltier -- Pivot Charts for more info about pivot charts.

  3. #3
    2 Star Lounger
    Join Date
    May 2002
    Location
    Bristol, Avon, England
    Posts
    110
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adding secondary axis series to pivot chart (XP)

    Thank you - it did the trick

Posting Permissions

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