Hello Friends
I am trying to create a chart that show only series names of data that has value more than zero. I am attaching an example file here. in the data in D and H zero value, therefore, I would like that on the chart series name D and H should not be visible and if the value in either D or H increase above Zero than it should be visible.
Can some one help me with this?
Sorry if this question has been addressed already.
thanks in advance
Zubair
Those are Category names rather than series.
As the empty, or zero data, categories are in the middle of the data set the simplest approach would be to filter the data.
Or use complex formula to rebuild chart data set excluding rows with zero data
Thank you Andy for the reply and correction. Yes filtering is an option but since my original data set comprises of large number of categories and the data will keep on updating every month
therefore it may not be an easy solution to apply filter every time.
could you help me provide the formula in such case.
thank you in advance.
Zubair
The attached has a new matrix of chart data. The amount of data is determined by the 4 named ranges.
Use the Select Data dialog on the chart to see the usage of named ranges to define source of each series' data
Dear Andy
Thanks a lot, really helpful indeed.
best regards
Zubair
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks