+ Reply to Thread
Results 1 to 3 of 3

Different gaps for different chart columns

  1. #1
    Registered User
    Join Date
    08-10-2020
    Location
    sydeny
    MS-Off Ver
    office365 proplus
    Posts
    2

    Different gaps for different chart columns

    Hello all

    Two of the excel chart columns need to be together and the rest can be at different gaps or equally spaced
    In the simple Office 365(Proplus) sheet, I have a table with column chart.

    Columns A&B need to be adjacent for quick comparison, while C,D&E can be as per any requirement

    How will I be able to do that? I know some basic Excel

    Thanks to all
    Good_Man
    Attached Files Attached Files

  2. #2
    Forum Expert Crooza's Avatar
    Join Date
    10-19-2013
    Location
    Hunter Valley, Australia
    MS-Off Ver
    Excel 2003 /7/10
    Posts
    1,862

    Re: Different gaps for different chart columns

    Hi and welcome

    see attached. the easiest way is to create new rows in the spreadsheet between the data you want the gaps in and then double click the chart to highlight the columns and set the gap to 0 and overlap to 0
    Attached Files Attached Files
    Happy with my advice? Click on the * reputation button below

  3. #3
    Registered User
    Join Date
    08-10-2020
    Location
    sydeny
    MS-Off Ver
    office365 proplus
    Posts
    2

    Re: Different gaps for different chart columns

    Thank you Crooza

+ 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. Line Chart with Gaps.
    By El-d in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 02-28-2016, 07:29 AM
  2. Retrieval of values from columns with gaps between month columns
    By pvp in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-07-2016, 06:19 AM
  3. How do I get gaps in a chart with values from an array using VBA?
    By annabroyn in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-06-2014, 10:18 AM
  4. timeline bar chart with gaps, ranges
    By ysrini in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-08-2009, 05:09 AM
  5. Not Able to Leave Gaps on Line Chart
    By ChristiaanV in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 04-14-2008, 05:09 AM
  6. I want to show gaps in my line chart
    By rshackleford310 in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-09-2007, 02:19 AM
  7. Date gaps in chart after pivotTable
    By David T. in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 02-14-2006, 01:15 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