higleyjp Posted April 28, 2011 Share Posted April 28, 2011 I'm trying to use Conditional Formatting on a pie chart so that if there is no data (i.e. all of the values are zero) the chart will be suppressed. Unfortunately no matter what I do with the fill or text color it still shows up with 33.33% assigned to each slice. Help! Thanks! Justin Link to comment Share on other sites More sharing options...
comment Posted April 28, 2011 Share Posted April 28, 2011 There is practically nothing in a chart that can be conditionally formatted. However, you can make your labels a calculation - if there are no labels, no pie is drawn. Link to comment Share on other sites More sharing options...
higleyjp Posted April 29, 2011 Author Share Posted April 29, 2011 Thanks! That's exactly what I needed. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 4747 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now