I am collecting weekly data but only want to show chart data for the weeks that have data. If I have 12 weeks but only have data for the first 6 weeks, I want to show only the 6 weeks on the chart, not 12 weeks with bars for the first 6. Is this possible? I would also like to add data labels above the bars but when I do the result is not what I expect? I have attached a sample file.
Thanks in advance
Bookmarks