dont show horizontal category names if values is zero

Hi,

Put a formula in B3:

=IF(B2="","",B1)

and copy to P3.

Then edit the chart so that the horizontal axis references B3:P3.

Regards

Formula in B3:

=IFERROR(INDEX($B$1:$P$2,ROWS(B$1:B1),AGGREGATE(15,6,(COLUMN($B$1:$P$2)-MIN(COLUMN($B$1:$P$2))+1)/($B$2:$P$2<>""),COLUMNS($B1:B1))),"")

and copied down one row and across to P4.

In Name Manager, define:

Name: ChartAxis
Refers to: =Sheet1!$B$3:INDEX(Sheet1!$B$3:$P$3,MATCH(99^99,Sheet1!$B$4:$P$4))

Name: ChartValues
Refers to: =Sheet1!$B$4:INDEX(Sheet1!$B$4:$P$4,MATCH(99^99,Sheet1!$B$4:$P$4))

In the chart, change the series values to:

=Sheet1!ChartValues

And change the horizontal axis labels to:

=Sheet1!ChartAxis

Regards