Hi Jon - solved the problem - need to interpolate the chart to see the data
series - especially if there is limited data of diferent value, it won't show
up on the bottom of the chart until you interpolate. Thanks anyway.
cheers
Newperson

"Jon Peltier" wrote:

What kind of chart is it? What is the structure of the data? Do you also
need a secondary X axis?

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


"Newperson" wrote in message
...
The main chart has lots of data points (300 )and I want to create a
secondary y axis showing daily mean max min temperatures with only 7 data
points.
The temps do not appear as a data series at all.
Have tried auto fill but of couse you get an angular plot. How do you get
it
to recognise the empty cells