Prev: record sheet row order, then restore to that point
Next: Input distanct from a map into excel
From: LaDdIe on 7 Mar 2010 12:23
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.
From: LaDdIe on 7 Mar 2010 14:28
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.
 | 
Pages: 1
Prev: record sheet row order, then restore to that point
Next: Input distanct from a map into excel