As I said in my recent post, temporarily changing to an area chart type
might be sufficient.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
http://PeltierTech.com
_______


"Saxman" wrote in message
...
Saxman wrote:

I do get <blank series, as most events have differing numbers.

I have a piece of code that copies/pastes the names in the series and
places them
in the 'Archive' worksheet. These are then placed at the foot of the
graph in a
legend for reference.

I do get <blank series, as most events have differing numbers.

I have a piece of code that copies/pastes the names in the series and
places them
in the 'Archive' worksheet. These are then placed at the foot of the
graph in a
legend for reference.





I've had another go at this and all references get changed until the code
gets to a
<blank series. I have 16 different inputs in my series. If I am
gathering data
for an event with 5 inputs, the rest appear as <blank series (6-16).

If I save the document, re-open it and then use your string conververter,
quite
naturally, only the first 5 will get converted, as they are the only
inputs with
labels and the rest appear as <blank series when the document was saved.

If I then choose an event with 10 labels, naturally I get 10 labels, but
only the
first 5 get converted.

It's a pity the code will not recognise <blank series and convert the
data.

--


--