+ Reply to Thread
Results 1 to 2 of 2

Comparison chart to not plot zero

  1. #1
    Registered User
    Join Date
    10-22-2015
    Location
    KL, Malaysia
    MS-Off Ver
    MS Office 2010
    Posts
    17

    Comparison chart to not plot zero

    -Found an alternative-
    Thanks
    CLOSED

    Hi there,

    I'm creating a comparison chart to highlight two issues
    • My company's output/input AGAINST market output/market input (which has already shown in the chart)
    • My company's capacity/input AGAINST market capacity/market input

    1 - Is it possible to make the bar chart to not plot (completely neglect) the category whereby my company do not have? Which in this case, I would like H, F, I, D, J, C to be ignored/neglected by the chart. So far I have use pivot to arrange the bar chart based on the input quantity, which is good enough..

    2 - Comparison chart shows overlap between my company and market to be able to identify the gap (underperform) and how much of overperformance, which has clearly shown (Output/Input vs Market Output/Market Input). However, if I want to highlight the capacity performance as well, is it possible? As if a chart below the input-output performance.
    (I.E, For, 'E', my company has outperformed (91) the market (71) for output-input, but I would like to have a bar underneath so show that my company has outperformed (783) the market (707).

    Kindly assist and thanks!!!
    Attached Files Attached Files
    Last edited by kenny_kk; 12-07-2015 at 10:09 PM.

  2. #2
    Registered User
    Join Date
    10-22-2015
    Location
    KL, Malaysia
    MS-Off Ver
    MS Office 2010
    Posts
    17

    Re: Comparison chart to not plot zero

    --Deleted--
    Last edited by kenny_kk; 12-07-2015 at 10:03 PM. Reason: Delete

+ 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. Plot area chart color in a chart
    By yousuf_seifi in forum Excel Charting & Pivots
    Replies: 0
    Last Post: 08-20-2014, 01:27 PM
  2. How to plot a comparison of only 3 points against 9 in graph
    By karryan in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 03-28-2014, 04:04 AM
  3. Plot points on a area chart or plot areas on a scatter chart
    By maggy in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 01-17-2012, 04:39 AM
  4. Comparison Chart
    By Purchaser in forum Excel General
    Replies: 2
    Last Post: 11-30-2011, 06:24 AM
  5. Side by Side comparison scatter plot
    By georgeanaprop in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 07-05-2010, 09:57 AM
  6. Plot 3 sets of data in scatter chart and area chart in one
    By geoffs52 in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 12-24-2009, 04:42 AM
  7. how to plot two lines on a graph for comparison?
    By Ashley in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 11-22-2005, 02:10 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1