L
lizard54
I developed an Excel scatter chart to identify the customers' density
using grouping. I have 5000 customers, where each has:
Customer ID X-Values(LAT) Y-Values(LON) Group#
My chart has multiple series that are corresponding to the number of
group I have. For example, if I have 10 groups, I will have 10 series
in the one chart. I have fixed number of Customer. The group# is
preassigned from another software and this values change in every run.
Currently I'm using macro to sort my data in ascending order based on
Group#. Then I have to manually change the X and Y values in every
series accordingly since the number of rows in Group# is not fixed.
I'm wondering if I could automatically update my chart when the group#
changes. How should I change the VBA .X and .XVales based on the
group#? Thank you all so much for your help.
Regards,
Lin
using grouping. I have 5000 customers, where each has:
Customer ID X-Values(LAT) Y-Values(LON) Group#
My chart has multiple series that are corresponding to the number of
group I have. For example, if I have 10 groups, I will have 10 series
in the one chart. I have fixed number of Customer. The group# is
preassigned from another software and this values change in every run.
Currently I'm using macro to sort my data in ascending order based on
Group#. Then I have to manually change the X and Y values in every
series accordingly since the number of rows in Group# is not fixed.
I'm wondering if I could automatically update my chart when the group#
changes. How should I change the VBA .X and .XVales based on the
group#? Thank you all so much for your help.
Regards,
Lin