+ Reply to Thread
Results 1 to 2 of 2

Overlapping columns using a secondary axis

  1. #1
    Forum Contributor
    Join Date
    11-13-2012
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    279

    Overlapping columns using a secondary axis

    Hi Everyone, I have attached the file.
    I basically have four items, 2 columns on the primary axis, and 2 columns on the secondary axis.
    Unfortunately I don't know how to stop the columns from overlapping. Does anyone know what to do?
    Thanks very much indeed
    Attached Files Attached Files

  2. #2
    Forum Guru xlnitwit's Avatar
    Join Date
    06-27-2016
    Location
    London
    MS-Off Ver
    Windows: 2010; Mac: 16.13 (O365)
    Posts
    7,085

    Re: Overlapping columns using a secondary axis

    Typically, you plot two blank columns as the last two series on the primary axis, then two blank columns as the first two series on the secondary axis. That way the data columns only overlap blank series on the other axis, so they all appear next to each other.
    Don
    Please remember to mark your thread 'Solved' when appropriate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Secondary Axis without overlapping bars
    By treva26 in forum Excel Charting & Pivots
    Replies: 10
    Last Post: 03-18-2021, 02:58 PM
  2. Stop primary and secondary axis from overlapping in Pivot Chart
    By Justair07 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-31-2016, 12:06 PM
  3. Overlapping Primary and Secondary Axis in Charts
    By pranavshandilya in forum Excel Charting & Pivots
    Replies: 7
    Last Post: 10-14-2013, 03:53 AM
  4. Bar chart with secondary axis and overlapping bars
    By ashley.phillips in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 07-18-2013, 10:46 AM
  5. [SOLVED] Bars overlapping for primary axis data and secondary axis data
    By Lui23 in forum Excel Charting & Pivots
    Replies: 3
    Last Post: 01-19-2013, 05:06 AM
  6. Chart with Secondary Axis but Bars are Overlapping
    By steven_thomas in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 03-23-2008, 06:20 PM

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.6.0 RC 1