I have a chart showing relevant data which gets updated bi-weekly, currently if my data set is the whole column of data the chart looks wrong because the cells have a 0 value, I want to add an IF function so that data in the set only shows if it has a value greater than 0, any help appreciated!
If all of the 0 values that you don't want in the chart are at the end or at the beginning of the data set, then you can use dynamic named ranges to only show the non-zero data https://www.excel-easy.com/examples/...med-range.html
You can use a filter to hide the 0 values from the spreadsheet, which should hide them from the chart, as long as your hidden cell setting is set to "don't show".
Originally Posted by shg
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks