+ Reply to Thread
Results 1 to 4 of 4

Creating weekly charts showing trend lines

  1. #1
    Forum Contributor
    Join Date
    10-06-2015
    Location
    london
    MS-Off Ver
    2013
    Posts
    149

    Creating weekly charts showing trend lines

    Hello

    I am in need of help creating bar charts that display the percentage of weekly results.

    I have attached an example of the type of graphs I am looking for and would appreciate any help with this.

    Graphs to show the quarter percentage by weeks quarterly

  2. #2
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex, UK
    MS-Off Ver
    365
    Posts
    7,468

    Re: Creating weekly charts showing trend lines

    The month side of thing doesn't work well as months don't fall into neat 28 day (4 week) slots, but see the attached for one way of doing this. Should point you in the right direction.
    You could use pivot tables/charts to accomplish the same too.

    BSB
    Attached Files Attached Files

  3. #3
    Forum Contributor
    Join Date
    10-06-2015
    Location
    london
    MS-Off Ver
    2013
    Posts
    149

    Re: Creating weekly charts showing trend lines

    Can you explain how it works? If you take street cleansing for instance.. and add all the numbers from 130 in April, it does not equate to 497 in the other report dataset

  4. #4
    Forum Contributor
    Join Date
    10-06-2015
    Location
    london
    MS-Off Ver
    2013
    Posts
    149

    Re: Creating weekly charts showing trend lines

    I have noticed the numbers picked up in the table are the numbers stated in the inspections. The graph needs to show the quarterly percentage for the 3 months in a weekly format, not where it counts all the numbers of the inspections

+ 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. Macro to copy data on a weekly basis for trend analysis
    By maxmilan in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-08-2014, 08:09 AM
  2. Replies: 1
    Last Post: 10-01-2012, 09:50 AM
  3. Analysis trend showing two lines in one graph
    By KMTrombley in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 07-21-2011, 03:48 PM
  4. Trend lines in charts
    By Sebastian1942 in forum Excel General
    Replies: 6
    Last Post: 01-18-2010, 02:51 AM
  5. Trend lines
    By Mangart in forum Excel Charting & Pivots
    Replies: 6
    Last Post: 04-16-2007, 06:03 PM
  6. Trend Lines
    By rrucksdashel in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-11-2006, 09:13 AM
  7. Trend lines
    By Clash in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 01-25-2005, 01:31 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