More than 255 series question - workaround?

[chuckles1066]

I have to plot office locations.

There are 315 of them across the South West of England.

Each one of them has an OS X-Y co-ordinate (which forms the basis of the X-Y axis) but when attempting to plot them (via a macro I inherited) it all falls over with the "maximum number of series allowed is 255" error.

Is it possible to copy the macro but then edit it so that I plot the first 250 onto a chart with the original macro and then run the second macro to plot the remaining 65 onto the same chart?

TIA.

 

[hallingh]

I'm sure I must be misunderstanding your question, but can't you just plot one series that contains all of the office locations as data points?

 

[Andrew Poulsom]

You can't have more than 255 series with VBA either.

 

[chuckles1066]

I'm sure I must be misunderstanding your question, but can't you just plot one series that contains all of the office locations as data points?

Well I'm not sure, as I said I inherited the macro that plots them as a bubble chart.

I have googled and this 255 series limit does seem a rather common limitation, I just wondered if there was a workaround.

But I'm all ears if there is a different way of doing it.

 

[hallingh]

I'm assuming the points are simply plotted based on y and x axis points?

If so, all of the axis points can be put in a list on a worksheet (e.g. x axis points in column a and y axis points in column b) and the bubble chart can just use one series that includes all of the values in column a for the x axis points and all of the values in column b as the y axis points.

Again, I might be misunderstanding what you're trying to do, but I think this would work fine?

 

[chuckles1066]

I'm assuming the points are simply plotted based on y and x axis points?

If so, all of the axis points can be put in a list on a worksheet (e.g. x axis points in column a and y axis points in column b) and the bubble chart can just use one series that includes all of the values in column a for the x axis points and all of the values in column b as the y axis points.

Again, I might be misunderstanding what you're trying to do, but I think this would work fine?

The source data for the chart is:

column A - site ID (a five digit id)
column B - x co-ordinate (a six digit OS id)
column C - y co-ordinate (a six digit OS id)
column D - count of jobs per site

The macro plots the x,y co-ordinate for each site and does some jiggery-pokery with the label (column D + " - " + column A).

If you can cobble together some dummy data based on that premise, I will be able to adapt it?