View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Change area to bar and bar to area

Hi,

You can select a series and changes it's chart type.
Try selecting the area and changing to bar. Then select the original bar and
change to area.

Alternatively change the layout of your data so the 2008 data comes before
the 2009.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Annette" wrote in message
...
Is there a way to switch the bar to area and area to bar. I have a custom
type using column-area ... my display shows 2009 as area and 2008 as
column. I want to switch look so the 2009 has the column ... is there a
way to switch.


Thanks much!