Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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! |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
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! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding area codes only to phone numbers missing an area code | Excel Discussion (Misc queries) | |||
set area in excel not giving me option to set print area? | Excel Discussion (Misc queries) | |||
error: "the copy area & the paste area are not the same size & sh | Excel Discussion (Misc queries) | |||
Use values instead of labels on X-axis in Area/Stacked Area Charts | Charts and Charting in Excel | |||
Why I get gray area in sheet tab of page setup? can't resize area. | Excel Discussion (Misc queries) |