+ Reply to Thread
Results 1 to 1 of 1

Charts showing without zeros

  1. #1
    Registered User
    Join Date
    04-06-2012
    Location
    Maidstone, Kent
    MS-Off Ver
    Microsoft 365 Apps for Business
    Posts
    23

    Charts showing without zeros

    Afternoon

    Can someone help me out with some chart information.

    I gather statistics on tasks undertaken by my despatch team and create charts for each task per day.
    I need to find a quicker method of returning the information on the results in a chart.
    I know I can move the selection field for the amount of staff working.
    I would like this to be automated by means of the data not selection staff that have not carried out that task. i.e there are "0's" making the charts smaller.
    There name has to remain as they would have been carrying out another task, but does not have to show for the chart in question.

    I use one tab per person and the collate the data so that it compiles.

    Hope this makes sense and someone can help me out.

    I have given an example of my data.

    Thanks in advance.
    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. Showing zeros in money amounts
    By cygnus_x1 in forum Excel General
    Replies: 3
    Last Post: 06-13-2015, 10:24 AM
  2. Showing unnecessary zeros
    By jetranger in forum Excel General
    Replies: 1
    Last Post: 05-04-2015, 08:28 PM
  3. [SOLVED] Sum Across Multiple Worksheets, Showing No Zeros
    By Girthicker in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 09-08-2012, 05:36 AM
  4. Zeros showing up in my cells
    By Excel_Nemesis in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 07-13-2011, 02:03 PM
  5. Formula not showing zeros
    By ryanb4614 in forum Excel General
    Replies: 8
    Last Post: 08-02-2010, 04:51 PM
  6. [SOLVED] not showing zeros on chart
    By [email protected] in forum Excel General
    Replies: 1
    Last Post: 01-25-2006, 11:00 PM
  7. [SOLVED] Leading zeros not showing
    By MikeS in forum Excel General
    Replies: 2
    Last Post: 12-02-2005, 04:13 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