ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)
-   -   Change area to bar and bar to area (https://www.excelbanter.com/charts-charting-excel/231448-change-area-bar-bar-area.html)

Annette[_3_]

Change area to bar and bar to area
 
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!



Andy Pope

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!




All times are GMT +1. The time now is 10:22 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com