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