Hi xld,

Here is a supplementary question.

How do I reduce the width of the chart by VBA?
I want to reduce the width of the chart when the number of values are less.