+ Reply to Thread
Results 1 to 2 of 2

Non-overlapping bars when using some series on secondary axis

  1. #1
    Registered User
    Join Date
    01-22-2019
    Location
    ny
    MS-Off Ver
    2016
    Posts
    22

    Non-overlapping bars when using some series on secondary axis

    Hi,
    I need the April and Mar freq. charts on the secondary y axis. When I do this it overlaps with the Apr and Mar count bars on the primary axis.
    I need well separated bars like I have in the original chart shown below. Can anybody help me on this.

    chart.JPG
    Attached Files Attached Files

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often: Office 365 in Windows environment
    Posts
    8,623

    Re: Non-overlapping bars when using some series on secondary axis

    A quick solution could be:
    1. Add 4 empty (zeroes) series (move them in between real series in series sequence)
    2. Format last 4 series (2 empty and 2 freq) to be presented on secondary axis
    3. Delete dummy series legend entries - click on legend to select it, and then click on series name (not on a color square) and hit Delete on keyboard

    See step by step instr. in attachement
    Attached Images Attached Images
    Attached Files Attached Files
    Best Regards,

    Kaper

+ 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. 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
  3. [SOLVED] Bar Graph With 2 Axis - Bars On The Primary Axis Overlap Bars On The Secondary Axis
    By Variablez in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-11-2013, 08:38 AM
  4. [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
  5. 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
  6. Primary and Secondary bars overlapping
    By Colin@Tioga in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-20-2008, 10:34 AM
  7. Replies: 1
    Last Post: 05-03-2006, 09: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