Results 1 to 3 of 3
  1. #1
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Chart (Excel 2002)

    Someone at work as created a chart, with 4 lots of data. First they created a bar chart, then decided they wanted two data sources to show as lines, the other two as bars. They managed to achieve this, but not in the order they wanted. Is there an easy way to change bars to lines and lines to bars?

    Rob.

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

    Re: Chart (Excel 2002)

    Yes, just click on one of the series and select Chart | Chart Type... You will be able to specify whether to apply changes to the selected series or to all series.

  3. #3
    5 Star Lounger
    Join Date
    May 2003
    Location
    Sheffield, Yorkshire
    Posts
    951
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Chart (Excel 2002)

    Thanks Hans, that worked.

Posting Permissions

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