+ Reply to Thread
Results 1 to 2 of 2
  1. #1
    Registered User
    Join Date
    10-31-2008
    Location
    Philippines
    Posts
    47

    column charts with 2 Axes in excel 2007 (overlapping columns)

    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!

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    2003 & 2007 & 2010
    Posts
    10,938

    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

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.2.0