Results 1 to 3 of 3
  1. #1
    3 Star Lounger
    Join Date
    Jun 2005
    Thanked 0 Times in 0 Posts

    Graphing and leaving out data with 0 quantity

    I am creating a number of graphs from a lot of different data. Some of the data points have a zero value. I only want the graph to plot those data points which have a value . Currently I am using Excel 2010, however, I also want it to be used in Excel 2007 and 2003.

    Is this possible??

    I am attaching a sample graph with all customers for review.

    Thank you.
    Attached Files Attached Files

  2. #2
    WS Lounge VIP
    Join Date
    Mar 2002
    Newcazzle, UK
    Thanked 466 Times in 444 Posts
    Hi MNN

    Presumably, what you want are charts that ONLY contain data for those Customers with non-zero values, i.e. do not include any Customer names on the chart x-axis which relate to zero values.

    So, I think the easiest way is to :
    1. first format the chart objects so that they don't move or size with cells
    2. hide the Customer data rows that have zero values

    Graphs will not display or include data for 'hidden rows'

    You need to do step 1 above otherwise after hiding the rows with zero data, the graph will 'shrink' in size.
    To fix this, before hiding any rows, right-click on the edge of the chart, then select 'Format chart area' from the right-click menu.
    Then select 'Properties' in the left-hand options pane for 'Format Chart Area'.
    Then select the radio button choice for 'Don't move or size with cells'

    Do the same for the second chart.

    Then you could hide the rows manually for Customers with zero values.

    Alternatively, to automate the hiding of the 'zero' rows, you could add a simple macro to do this for you.

    Does this help??


  3. #3
    WS Lounge VIP sdckapr's Avatar
    Join Date
    Jul 2002
    Pittsburgh, Pennsylvania, USA
    Thanked 342 Times in 335 Posts
    Another option is to use autofilter to filter the data. See attached.

    Attached Files Attached Files

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts