I have a data table that shows weekdays in the left column and values in the
next two columns, the data range is called 'Month'.

I have a macro that creates a Chart, but the category axis shows all days in
the month when run, even though there are not shown in the data table.

How can I stop Excel autofilling a chart with dates that I don't want and
that are not included in the data table?

Thank you.

No worries, i've got it sorted

"LaDdIe" wrote:

I have a data table that shows weekdays in the left column and values in the
next two columns, the data range is called 'Month'.

I have a macro that creates a Chart, but the category axis shows all days in
the month when run, even though there are not shown in the data table.

How can I stop Excel autofilling a chart with dates that I don't want and
that are not included in the data table?

Thank you.