Graph Source Data

[Jon Peltier]

There are unrelated problems with line or scatter series which are unable to
be plotted due to having no valid data (i.e., all blanks or all errors). You
could temporarily change the chart type: a column or area chart lets you
access the series formula of a series which would be inaccessible as a line
or XY type.

- Jon

 

[Saxman]

There are unrelated problems with line or scatter series which are unable to be
plotted due to having no valid data (i.e., all blanks or all errors). You could
temporarily change the chart type: a column or area chart lets you access the
series formula of a series which would be inaccessible as a line or XY type.

That's not really feasable in my situation. I use the graph to check odds available
during sporting events. A line graph give me a good graphical record of what has
happened. A horse in a horserace that drops in value on my graph is more likely to
win. I'll have a look at ares charts maybe?

--

 

[Jon Peltier]

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

- Jon

 

[Jon Peltier]

.... "temporarily" change the chart type.

It's at least worth trying to see if it would help. Also, if an area chart
solves the one problem, you could format it with no area pattern, so it will
appear to be a line.

- Jon

 

[Saxman]

... "temporarily" change the chart type.

It's at least worth trying to see if it would help. Also, if an area chart solves
the one problem, you could format it with no area pattern, so it will appear to be
a line.

I'll try later today, thanks.

John (UK)

 

[Saxman]

... "temporarily" change the chart type.

This works perfectly when I change to an 'area' graph, but the drawback is that one
has to revert to standard graph for later use. As I use a custom graph, all the
built in formatting is lost.

Is there a way to save a user defined graph and use it later?

 

[Jon Peltier]

You can change just one series to an area chart. The series may then require
some formatting, but the rest of the chart should be relatively unharmed by
the process.



- Jon

-------

Jon Peltier, Microsoft Excel MVP

Tutorials and Custom Solutions

http://PeltierTech.com

_______