+ Reply to Thread
Results 1 to 3 of 3

Bar chart not displaying properly

Hybrid View

  1. #1
    Registered User
    Join Date
    05-29-2023
    Location
    montreal
    MS-Off Ver
    365
    Posts
    2

    Bar chart not displaying properly

    Good day,

    I am trying to display for 8 department weekly data via a bar chart. the main issue is the column not separating properly 1.PNG, I would like them to show as the following image 2.PNG. I have set "series overlap to -100% and "Gap width" to 0%. Here's the file test.xlsx. What would be the cause?

    Thanks

  2. #2
    Forum Guru Andy Pope's Avatar
    Join Date
    05-10-2004
    Location
    Essex, UK
    MS-Off Ver
    O365
    Posts
    20,481

    Re: Bar chart not displaying properly

    If you set the horizontal axis to text, rather than date.

    Reduce the border thickness to 1
    Set overlap to 0%
    and gap width to 50%
    Cheers
    Andy
    www.andypope.info

  3. #3
    Registered User
    Join Date
    05-29-2023
    Location
    montreal
    MS-Off Ver
    365
    Posts
    2

    Re: Bar chart not displaying properly

    Thanks Andy!

+ 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. SUM display not displaying properly.
    By Norman Shapiro in forum Excel General
    Replies: 5
    Last Post: 06-23-2020, 05:51 PM
  2. Shrink to Fit not displaying properly
    By redrock21 in forum Excel General
    Replies: 1
    Last Post: 09-25-2016, 10:30 PM
  3. [SOLVED] Displaying Time Properly
    By Nickolai in forum Excel Formulas & Functions
    Replies: 16
    Last Post: 03-31-2015, 05:51 PM
  4. [SOLVED] Timestamp not displaying properly
    By patrickfshield in forum Excel General
    Replies: 5
    Last Post: 12-01-2014, 06:36 PM
  5. [SOLVED] Macro name not displaying properly
    By mukeshbaviskar in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 01-28-2014, 01:19 AM
  6. charts not displaying properly
    By davidcpro in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 06-17-2013, 06:54 AM
  7. Formulas not displaying properly
    By jdwoods in forum Excel General
    Replies: 2
    Last Post: 08-31-2011, 12:04 PM

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