+ Reply to Thread
Results 1 to 2 of 2

Monthly vs Weekly Bar Charts

  1. #1
    Registered User
    Join Date
    06-12-2020
    Location
    Montreal, Quebec
    MS-Off Ver
    365
    Posts
    7

    Monthly vs Weekly Bar Charts

    I have a simple bar chart for monthly frequency data that looks great. I have a separate bar chart for weekly frequency data that looks terrible because the bars are too thin. Why is the width of the bars different for monthly and weekly bar charts? How do I edit the weekly bar chart so that the bars are the same width as the default monthly chart?

    I attached a copy of the spreadsheet.
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    03-24-2020
    Location
    Thailand
    MS-Off Ver
    Office 2016
    Posts
    844

    Re: Monthly vs Weekly Bar Charts

    Hi sams7007,
    Try the attached.
    Just 2 small changes to your original chart.
    Format Axis > Axis Options > Axis Type: Change to middle option: Text axis
    Format Data Series >Series Options: Series overlap = 0, Gap width = 80
    Attached Files Attached Files

+ 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. Converting weekly to monthly data and Yearly data to monthly
    By MilicaMatovic in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 01-29-2016, 09:48 AM
  2. Weekly, Monthly and YTD calculations
    By ROBINB in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 04-16-2012, 11:19 AM
  3. Excel 2007 : Help with monthly weekly summary
    By kakashi07 in forum Excel General
    Replies: 2
    Last Post: 03-14-2012, 10:54 AM
  4. Weekly and Monthly Reporting
    By FourSeven in forum Excel General
    Replies: 0
    Last Post: 02-16-2011, 09:06 PM
  5. Replies: 1
    Last Post: 07-11-2008, 05:57 AM
  6. Weekly/Monthly Averages
    By klindy in forum Excel General
    Replies: 2
    Last Post: 10-13-2006, 02:57 PM
  7. [SOLVED] Weekly and Monthly Subtotals
    By ChuckW in forum Excel General
    Replies: 3
    Last Post: 09-02-2005, 05:05 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