+ Reply to Thread
Results 1 to 14 of 14

Chart Not Correctly Showing Tally Results

  1. #1
    Registered User
    Join Date
    10-07-2017
    Location
    Hampshire, England
    MS-Off Ver
    Office 365, Windows 10
    Posts
    36

    Chart Not Correctly Showing Tally Results

    Hi,

    Can anyone please help with this?

    I have a problem with this chart.

    If you look at April in the Tally 2019 tab it comes up with 4 raised and 6 completed.

    If you look at the Master Schedule tab then 4 items were raised and it shows 6 completed.

    Can you help with this?

    Best Wishes,
    Rob
    Attached Files Attached Files

  2. #2
    Forum Expert kersplash's Avatar
    Join Date
    11-22-2016
    Location
    Perth
    MS-Off Ver
    Home 2016 (Windows 10)/Work 2013 Pro Plus (Windows 10)
    Posts
    2,012

    Re: Chart Not Correctly Showing Tally Results

    When I open the file it shows 4 raised and 7 completed in both sheets.

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

    Re: Chart Not Correctly Showing Tally Results

    Same for me. Perhaps your auto calculation is turned off?

    Or perhaps the question here is really that there are more closed in Apr than were opened?
    If so, that's because some of the records closed in Apr were opened in previous months.

    BSB

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

    Re: Chart Not Correctly Showing Tally Results

    What exactly is the problem?

    BTW I see 7 completes
    Cheers
    Andy
    www.andypope.info

  5. #5
    Registered User
    Join Date
    10-07-2017
    Location
    Hampshire, England
    MS-Off Ver
    Office 365, Windows 10
    Posts
    36

    Re: Chart Not Correctly Showing Tally Results

    Hi BSB,

    Thank you for your support.

    The tally shows for April, 4 raised 7 closed and -3 open.

    The Master Schedule shows for April, 4 raised, 2 closed because they have dates in the completed column.

    The tally should reflect the Master Schedule.

    RH

  6. #6
    Forum Contributor
    Join Date
    10-13-2015
    Location
    Culloden, West Virginia
    MS-Off Ver
    2010
    Posts
    165

    Re: Chart Not Correctly Showing Tally Results

    Not 100% sure what you're asking.

    Are you wondering why you have a negative number on your chart?

    The data that the chart is pulling from for April, you have "Tasks Raised" as 4 and "Tasks Closed" as 7.

    Your "Tasks Open" cell is calculated from Raised - Closed, which for April equals -3

    You can't have more "Raised" tasks" than "Closed" tasks, otherwise you'll always have a negative number for "Open".

    Are you wanting your "Open" tasks to display what was opened during a particular month or a cumulative total for all months?

  7. #7
    Registered User
    Join Date
    10-07-2017
    Location
    Hampshire, England
    MS-Off Ver
    Office 365, Windows 10
    Posts
    36

    Re: Chart Not Correctly Showing Tally Results

    The chart should display what has been raised and what is closed during a particular month. In this case April.

    This should not be cumulative.

    Sorry I do not know how the formula works.

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

    Re: Chart Not Correctly Showing Tally Results

    Put this in C4 on the tally sheet and copy down if the table doesn't do it for you:
    =COUNTIFS(Table_Master[Date],">="&[@Start],Table_Master[Date],"<="&[@End],Table_Master[Completed],"<>")


    You will also need to copy the formula from B5 and paste it into B4.

    BSB
    Last edited by BadlySpelledBuoy; 04-17-2019 at 04:08 AM.

  9. #9
    Forum Contributor
    Join Date
    10-13-2015
    Location
    Culloden, West Virginia
    MS-Off Ver
    2010
    Posts
    165

    Re: Chart Not Correctly Showing Tally Results

    Your formula is just subtracting Raised from Closed to get a total for Open, regardless of the month.

    The Raised total is correct for April, but the Open displays as negative because you had tasks from March that were closed in April.

    So, you had 4 Raised Tasks in April and 7 Closed Tasks in April. However, only 2 of those 7 were Raised and Closed in April. The other 5 were Raised in March.

    You need to have your chart data look for at the dates that were Raised and Closed in the same month to populate the graph the way you are wanting.

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

    Re: Chart Not Correctly Showing Tally Results

    See attached with changes made for you.

    BSB
    Attached Files Attached Files

  11. #11
    Registered User
    Join Date
    10-07-2017
    Location
    Hampshire, England
    MS-Off Ver
    Office 365, Windows 10
    Posts
    36

    Re: Chart Not Correctly Showing Tally Results

    Hi BSB,

    Works as expected now.

    Thank you so much for your support.

    Best Wishes,
    Rob

  12. #12
    Registered User
    Join Date
    10-07-2017
    Location
    Hampshire, England
    MS-Off Ver
    Office 365, Windows 10
    Posts
    36

    Re: Chart Not Correctly Showing Tally Results

    Hi jme,

    Thank you, I now understand where the problem was.

    Best Wishes,
    Rob

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

    Re: Chart Not Correctly Showing Tally Results

    Happy to help Rob.

    Have a good day.

    BSB

  14. #14
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel (Windows 11 64-bit)
    Posts
    62,075

    Re: Chart Not Correctly Showing Tally Results

    If that takes care of your original question, please select Thread Tools from the menu link above and mark this thread as SOLVED. Thanks.
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" to anyone who has offered you help in your thread. You can reward them by clicking on * Add Reputation below theur user name on the left, if you wish.


    Forum Rules (updated September 2018): please read them here.
    How to use the Power Query code you've been given: help here. More about the Power suite here.

+ 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. Doughnut Chart - Results V.s Target and showing percentage
    By nelson2101 in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 05-23-2017, 12:17 PM
  2. Replies: 2
    Last Post: 12-19-2016, 05:34 PM
  3. [SOLVED] Chart not showing results from formula
    By hayestrent in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-16-2014, 12:14 PM
  4. [SOLVED] Chart not showing results when cells are hidden
    By Dibbley247 in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 01-17-2013, 10:58 AM
  5. [SOLVED] Converting Tally Marks to Numerical Value and Totaling the results.
    By bdavis711 in forum Excel General
    Replies: 5
    Last Post: 10-01-2012, 09:30 PM
  6. Excel 2007 : Values not showing correctly in chart
    By kuroneko4 in forum Excel General
    Replies: 1
    Last Post: 01-21-2010, 12:54 PM
  7. [SOLVED] survey results tally
    By ME Hill in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-30-2006, 02:40 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

X vBulletin 4.1.8 Debug Information

  • Page Generation 0.72544 seconds
  • Memory Usage 9,264KB
  • Queries Executed 16 (?)
More Information
Template Usage (34):
  • (1)SHOWTHREAD
  • (1)ad_footer_end
  • (1)ad_footer_start
  • (1)ad_global_above_footer
  • (1)ad_global_below_navbar
  • (1)ad_global_header1
  • (1)ad_global_header2
  • (1)ad_navbar_below
  • (1)ad_showthread_firstpost_sig
  • (1)ad_showthread_firstpost_start
  • (1)ad_thread_first_post_content
  • (1)ad_thread_last_post_content
  • (1)footer
  • (1)forumrules
  • (1)gobutton
  • (1)header
  • (1)headinclude
  • (1)headinclude_bottom
  • (14)memberaction_dropdown
  • (1)navbar
  • (4)navbar_link
  • (4)navbar_noticebit
  • (6)option
  • (2)postbit_attachment
  • (14)postbit_legacy
  • (14)postbit_onlinestatus
  • (14)postbit_wrapper
  • (4)showthread_bookmarksite
  • (7)showthread_similarthreadbit
  • (1)showthread_similarthreads
  • (1)spacer_close
  • (1)spacer_open
  • (1)tagbit_wrapper
  • (1)vbseo_linkbackmenu_entry 

Phrase Groups Available (6):
  • global
  • inlinemod
  • postbit
  • posting
  • reputationlevel
  • showthread
Included Files (39):
  • ./vbseo.php
  • ./env.php
  • ./vbseo/includes/functions_vbseo.php
  • ./vbseo/includes/functions_vbseo_pre.php
  • ./vbseo/includes/functions_vbseo_url.php
  • ./vbseo/includes/functions_vbseo_createurl.php
  • ./vbseo/includes/functions_vbseo_db.php
  • ./vbseo/includes/functions_vbseo_vb.php
  • ./vbseo/includes/functions_vbseo_seo.php
  • ./vbseo/includes/functions_vbseo_misc.php
  • ./vbseo/includes/functions_vbseo_crr.php
  • ./vbseo/includes/functions_vbseo_cache.php
  • ./vbseo/includes/functions_vbseo_hook.php
  • ./vbseo/includes/functions_vbseo_startup.php
  • ./includes/config.php
  • ./showthread.php
  • ./global.php
  • ./includes/class_bootstrap.php
  • ./includes/init.php
  • ./includes/class_core.php
  • ./includes/functions.php
  • ./includes/class_friendly_url.php
  • ./includes/class_hook.php
  • ./includes/functions_cforum.php
  • ./includes/functions_facebook.php
  • ./includes/functions_bigthree.php
  • ./includes/class_postbit.php
  • ./includes/class_bbcode.php
  • ./includes/functions_reputation.php
  • ./includes/class_bootstrap_framework.php
  • ./vb/vb.php
  • ./vb/phrase.php
  • ./packages/vbattach/attach.php
  • ./vb/types.php
  • ./vb/cache.php
  • ./vb/cache/db.php
  • ./vb/cache/observer/db.php
  • ./vb/cache/observer.php
  • ./includes/functions_notice.php 

Hooks Called (49):
  • init_startup
  • friendlyurl_resolve_class
  • database_pre_fetch_array
  • database_post_fetch_array
  • global_bootstrap_init_start
  • global_bootstrap_init_complete
  • cache_permissions
  • fetch_threadinfo_query
  • fetch_threadinfo
  • fetch_foruminfo
  • global_state_check
  • global_bootstrap_complete
  • global_start
  • style_fetch
  • global_setup_complete
  • showthread_start
  • showthread_getinfo
  • friendlyurl_redirect_canonical
  • showthread_post_start
  • showthread_query_postids
  • showthread_query
  • bbcode_fetch_tags
  • bbcode_create
  • showthread_postbit_create
  • postbit_factory
  • postbit_display_start
  • fetch_musername
  • cache_templates
  • template_register_var
  • parse_templates
  • notices_check_start
  • notices_noticebit
  • process_templates_complete
  • reputation_image
  • postbit_imicons
  • bbcode_parse_start
  • bbcode_parse_complete_precache
  • bbcode_parse_complete
  • postbit_attachment
  • postbit_display_complete
  • memberaction_dropdown
  • tag_fetchbit_complete
  • showthread_similarthread_query
  • showthread_similarthreadbit
  • forumrules
  • showthread_bookmarkbit
  • navbits
  • navbits_complete
  • showthread_complete


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1