Results 1 to 5 of 5
  1. #1
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Utah, USA
    Posts
    120
    Thanks
    0
    Thanked 0 Times in 0 Posts

    series Plots (Excel 2007)

    In the classic combination chart, there are column series plots and area series plots. How do I identify which series I want to be a column plot and which I want to be an area plot? For example: if the chart automatically plots series 1 and 2 as area and series 3 as column, then how would I which series 1 and 2 to column and series 3 to area?

  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: series Plots (Excel 2007)

    right click on the series and choose "Chart type" from the menu...

    Steve

  3. #3
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Utah, USA
    Posts
    120
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: series Plots (Excel 2007)

    At that point how do you switch the series so that the column becomes the area and the area becomes the column?

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

    Re: series Plots (Excel 2007)

    Apply Steve's suggestion to both series.

  5. #5
    2 Star Lounger
    Join Date
    Jan 2001
    Location
    Utah, USA
    Posts
    120
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: series Plots (Excel 2007)

    Thanks, that was most helpful!

Posting Permissions

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