Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old May 20th 09, 05:56 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2009
Posts: 32
Default 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   Report Post  
Old May 21st 09, 09:15 AM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
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!




Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Adding area codes only to phone numbers missing an area code RC Excel Discussion (Misc queries) 3 February 12th 08 10:22 PM
error: "the copy area & the paste area are not the same size & sh Janis Excel Discussion (Misc queries) 1 September 7th 07 10:58 PM
set area in excel not giving me option to set print area? J Littlebear Excel Discussion (Misc queries) 3 May 30th 07 12:49 AM
Use values instead of labels on X-axis in Area/Stacked Area Charts Ryan Charts and Charting in Excel 1 November 21st 06 05:14 PM
Why I get gray area in sheet tab of page setup? can't resize area. joey0617 Excel Discussion (Misc queries) 1 July 15th 06 05:30 PM


All times are GMT +1. The time now is 03:12 PM.

Powered by vBulletin® Copyright ©2000 - 2021, Jelsoft Enterprises Ltd.
Copyright 2004-2021 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017