Welcome to the Excel Forum

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed.

Please Register to Remove these Ads

Please Register to Remove these Ads



Reply
  #1  
Old 07-30-2009, 07:03 PM
emanon132501 emanon132501 is offline
Registered User
 
Join Date: 31 Oct 2008
Location: Philippines
Posts: 29
emanon132501 is becoming part of the community
column charts with 2 Axes in excel 2007 (overlapping columns)

Please Register to Remove these Ads

Hi,

I have 2 sets of data. Data 1 is Customer satisfaction percentage and Data 2 is number of dissatisfied customer due to poor product knowledge of my employees.

In excel 2003 once i plot these i just have to assign 1 series as my secondary axis and the columns would be side by side. But in Excel 2007 it's driving me nuts both columns are overlapping. how do i make them go side by side?

Please help!
Reply With Quote
  #2  
Old 07-31-2009, 06:42 AM
Andy Pope's Avatar
Andy Pope Andy Pope is offline
Forum Guru
 
Join Date: 10 May 2004
Location: Essex, UK
MS Office Version:2003 & 2007 sp2
Posts: 7,186
Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding Andy Pope Has a higher level of understanding
Re: column charts with 2 Axes in excel 2007 (overlapping columns)

Even in xl2003 placing column charts on 2 axes requires changing the layout of your data to prevent overlapping.

Check you '03 charts for data layout.

If still stuck post example of your '03 chart
__________________
Cheers
Andy
www.andypope.info
Reply With Quote


Reply

Bookmarks


Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

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

Forum Jump