+ Reply to Thread
Results 1 to 2 of 2

Overlap two out of three columns in excel bar chart

  1. #1
    Registered User
    Join Date
    07-23-2017
    Location
    Peoria, USA
    MS-Off Ver
    2016
    Posts
    55

    Overlap two out of three columns in excel bar chart

    Hello,

    I have a query regarding excel chart.

    I have three columns of data where I need two overlap two of them, not all three. I do know how to overlap series, but it is overlapping all three columns. Kindly help me figure out this mystery. Attached I have presented an example dataset.

    In the example, I wish to overlap 2023 Actual and 2023 Fcst while keeping other chart as it is.

    Is there a way to do this.

    Thanks,
    Piku
    Attached Files Attached Files

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,913

    Re: Overlap two out of three columns in excel bar chart

    One way is to plot a couple of blank series before the 2024 one and another one after it just to add spacing (as in the attached) then delete the legend entries for those dummy series.
    Attached Files Attached Files
    Rory

+ 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. [SOLVED] How to overlap 2 series of a bar chart
    By Osprey2 in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 07-07-2021, 09:45 AM
  2. Excel XY Chart (Scatter plot) Data Label No Overlap
    By schalliol in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 02-22-2017, 04:31 PM
  3. Bar Chart Formatting-Overlap
    By csnyder10 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 07-13-2016, 02:59 PM
  4. [SOLVED] Overlap map/chart
    By john55 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-08-2014, 04:43 AM
  5. Replies: 2
    Last Post: 02-05-2014, 07:30 PM
  6. Chart overlay / overlap
    By kuzna26 in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 05-14-2013, 10:33 AM
  7. [SOLVED] Can I overlap only two of four data series in Excel Column Chart?
    By Jon Erickson in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-20-2005, 09:35 AM

Tags for this Thread

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