Hi Community,

I created a chart to display every week of the year. However on the select data source, it's missing the tick box for last 2 weeks of December and replace them by the ",,,". I was unable to select or un-select these 2 weeks.

They appear on the chart box though.

I'm looking for some help to resolve the issues. I attached the screenshots for illustration.

Many thanks,


Haha

Attached Images

	Chart issues 2.PNG (13.8 KB, 9 views)
	Chart issues.PNG (17.5 KB, 9 views)

Please post a sample sheet. Pictures are useless to work with

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post

Hi - I'll upload sample sheet shortly.

Thanks,

Hi - I attached the working sheet.

Thanks,

Attached Files

Excel Chart issues.xlsx (104.7 KB, 2 views)

Having played a little with this it seems there might be a limit of about 50 columns; if you select fewer columns in both axes in Select Data, you can get the last columns' selectable checkboxes.