+ Reply to Thread
Results 1 to 2 of 2

Chart for avg posting times compaired to reach

  1. #1
    Registered User
    Join Date
    12-20-2019
    Location
    Wisconsin, USA
    MS-Off Ver
    Office 365
    Posts
    3

    Chart for avg posting times compaired to reach

    I've been trying to figure out a way to compare some Facebook data. I'm trying to figure out if there is a correlation between posting times and the reach of the posts. I don't want a long day-by-day comparison, but rather a chart that shows the average reach for posts between 8am-10am, 10am-12pm, or some similar time grouping. I've tried a variety of different chart options that I know how to do, but none of them are getting me the result I want, so I thought I'd turn to the experts!
    Attached is a sample of the the data I have.
    Thanks in advance!
    Attached Files Attached Files

  2. #2
    Valued Forum Contributor
    Join Date
    04-01-2015
    Location
    The Netherlands
    MS-Off Ver
    2003/2007/2010/2016/office 365
    Posts
    880

    Re: Chart for avg posting times compaired to reach

    With an extra column and a pivot table. You have to adjust the formula to the periods you want to see.
    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. Times Pivot Chart
    By aanaduta in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 04-08-2014, 08:07 PM
  2. If a search term can be found 1 time, 2 times 3 times 4 times 5 times
    By excelcandy in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 10-10-2013, 09:57 PM
  3. Replies: 4
    Last Post: 03-14-2012, 12:29 PM
  4. Posting a chart to blogger
    By montanoa in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 10-07-2006, 02:18 PM
  5. Set begin/end times in a bar chart
    By Charlotte Shaddix in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 08-16-2006, 08:55 AM
  6. is it possible to automatically change the color of the bar chart as soon as it reach
    By tweety127 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 06-08-2006, 12:49 PM
  7. Posting times to an Excel spreadsheet
    By Stressed Student in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 02-05-2006, 06:35 AM

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