+ Reply to Thread
Results 1 to 4 of 4

Can you create 0 values from no data?

  1. #1
    Registered User
    Join Date
    07-05-2010
    Location
    Newcastle, England
    MS-Off Ver
    Excel 2003
    Posts
    2

    Can you create 0 values from no data?

    I am creating a graph to analyse curves by a monthly period, and quantity.
    The information for this graph comes from a .CSV report that has been exported from accounting software.
    In simple terms the CSV looks a little like this...

    Month__Qty
    1_______2
    2_______3
    5_______1



    As you can see months 3 and 4 are missed out as there was 0 Qty, and thus nothing to report.
    When creating a graph using this information, I want the graph to report 3 and 4, as a '0' value.
    Is this possible in an excel graph? As entering the 0 values is not an option, as the .CSV report, is to large to enter these manually.

    Thanks.
    Last edited by smigles; 07-05-2010 at 08:59 AM.

  2. #2
    Forum Expert mrice's Avatar
    Join Date
    06-22-2004
    Location
    Surrey, England
    MS-Off Ver
    Excel 2013
    Posts
    4,966

    Re: Can you create 0 values from no data?

    The 0 values can be inserted by macro. Could you post a sample of the CSV file so that we can see where the data is on the sheet?
    Martin

    If my solution has saved you time and/or money, please consider sponsoring my run in the 2020 London Marathon in aid of Cancer Research UK.

    https://uk.virginmoneygiving.com/MartinRice

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

    Re: Can you create 0 values from no data?

    You can set the Category axis to Time Series, then the Month can be treated as a day. You will need to change the number format in order to display day rather than full date.
    Cheers
    Andy
    www.andypope.info

  4. #4
    Registered User
    Join Date
    07-05-2010
    Location
    Newcastle, England
    MS-Off Ver
    Excel 2003
    Posts
    2

    Re: Can you create 0 values from no data?

    Thanks for the replies guys, found a way round it.

    I selected field settings in the pivot table the graph creates, and selected 'show items with no data', then in my graph selected to plot blank entries as zeros.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

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