Hiding zero values in charts

B

BeckyIR

I've created a pamphlet template of sorts in excel that sources a dataset.
I'll be updating the dataset every 7 1/2 weeks to create a pamphlet for a
number of different campuses. I have certain graphs and charts in the
template that have zero counts/percentages that I'd like to "hide". For
example, I have a list of the number of students by program in one table.
Some campuses don't have certain programs, so they're showing up with zero
values. I'd like them to be hidden to decrease the clutter in the table....I
only want the programs with students in them to be listed. I have the same
issue with several graphs. I'm working in Excel 2007.
 
B

Bernard Liengme

Replace the empty cell with =NA(). This displays as #N/A and is ignored by
the chart engine
Unhappy with how the table now prints? Just use conditional formatting to
give cells with NA() a font that matched the cell background and hence is
invisible.
best wishes
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel 2007 charts: want to avoid zero values 1
Change font in multiple charts and graphs 0
Hiding zero values 2
Problem with Charting Null Values 7
Hiding zeros in dynamic charts 3
Displaying zero values as gap in a chart 1
Not Charting Zero Values 1
How to hide zero values in graphs using Mircosoft excel 2003? 1

Top