Re: Graph Source Data

Tech-Archive recommends: Fix windows errors by optimizing your registry

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" <john.h.williamsREMOVETHIS@xxxxxxxxxxxxxx> wrote in message
news:HNSdnb6r_takJ1HYnZ2dnUVZ8vidnZ2d@xxxxxxxxx
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' work***. 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' work***. 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.

--


--



.

Quantcast