Dynamic Chart Help 1

[EliseFreedman]

Hi There

I am trying to create a dynamic chart in excel

my table is currently in the following format. I want to use the data to create a bar chart. However, I would like the chart to only include the months where there is already data. The Month label is =OFFSET(DynamicData!$A$2,0,0,COUNTA(DynamicData!$A:$A))
However, I would like to only show the months on the axis that already have data so in the example below the chart would only show January - March. How do I do this. I have tried NA() and whilst it makes april #NA and suppresses the bar in the chart, April still shows on the x axis.

Any help would be appreciated




Employees Commencing Physio
January 45
February 38
March 34
April
May
June
July
August
September
October
November
December

 

[SkipVought]

Hi,

You only posted one column of your chart data. Presumably there is at least one other column of values to plot. Turn on the AutoFilter and footer to hide the empty values.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[SkipVought]

Just another thing. I would hope and expect that the MONTH column data is NOT TEXT but rather actual dates (numbers) that have been FORMATTED to display the month name.

And since that ought to be the case, you could simply use the AutoFilter on the MONTH column to filter dates > today, assuming also that the plot value data is related to this year's actual past data.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}

 

[SkipVought]

Elsie, yet another comment.

Your formula [highlight #FCE94F]=OFFSET(DynamicData!$A$2,0,0,COUNTA(DynamicData!$A:$A))[/highlight] returns an ARRAY and that's what is puzzling to me. You also say that this is the LABEL (heading). Just does not make sense.

Skip,

_{Just traded in my OLD subtlety...
for a NUance!}