ExcelBanter - Eliminating categories of zero values from X-axix

ExcelBanter (https://www.excelbanter.com/)

- Charts and Charting in Excel (https://www.excelbanter.com/charts-charting-excel/)

- - Eliminating categories of zero values from X-axix (https://www.excelbanter.com/charts-charting-excel/220816-eliminating-categories-zero-values-x-axix.html)

Raiju

Eliminating categories of zero values from X-axix

Hi , I have a range of sales data from 1 - 30 of a month, i will select the
all range while creating chart.What i want when click on the chart it could
eliminate the zero value items from the X-axis. Could i have your help on
this ?

All times are GMT +1. The time now is 05:56 PM.