-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!!!
Bookmarks