Another question for EXCEL gurus !

I have a chart with 56 columns(corresponding to 56 weeks in a year),
each of which is composed of merging 7 columns (corresponding to 7
days/week). How can I get a graph with the values in these merged
columns ? Selecting these and clicking does not produce anything !

Thank you !