May 9, 2015
I have a graph which shows no of customers in each department for 4 different organisations. I have a tool so you can change the month, and some departments may have some customers on one month, but no customers in other months across the 4 organisations. As there are quite a few departments, my graphs looks quite cluttered.
How do I get a chart to only show those departments (categories) on my Y axis which have a value not equal to 0 in any organisation? Even though there is no value, the Department (Category) title still appears on my Y axis.
I have tried conditional conditioning so that it changes the department name to White Text, but then an empty space appears in my chart Y Axis, where the department is.
Can this be done?
Thanks in advance.
July 16, 2010
I recommend you use a PivotTable to summarise your data, a Pivot Chart to present it and Slicers to control the filtering. This way the PivotTable will do the work in only showing you the departments that have values for the month selected in the Slicer.
I would have shown you an example in your sample file, but the source data is in an external file so I wasn't able to
Here is a tutorial on Slicers: https://www.myonlinetraininghub.com/ill-have-a-slicer-that
And a tutorial on Pivot Charts: https://www.myonlinetraininghub.com/excel-pivot-charts
Please let me know if you have any questions.
May 9, 2015
June 25, 2016
Most Users Ever Online: 57
Currently Online: Meyanui
Currently Browsing this Page:
Frans Visser: 210
mey tithveasna: 71
Anders Sehlstedt: 47
Dharan Prakash Mishra
Guest Posters: 1
Administrators: Mynda Treacy, Philip Treacy, Catalin Bombea
Moderators: Genevieve Tupas