I would like to display bars on my chart when the regions have a positive number and ignore a region if the value is zero. I have attached a sample file.
Thanks in advance
I would like to display bars on my chart when the regions have a positive number and ignore a region if the value is zero. I have attached a sample file.
Thanks in advance
A quick way is to apply a filter to column C and on the filter drop-down unselect "-".
Hope this helps.
Pete
Thanks for your reply. That works fine on my sample file but my model is more complex. I have attached a sample file.
Thanks in advance.
You can build a table of chart data excluding zero items.
Then use Named ranges to define data and labels to use
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks