View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Newperson
 
Posts: n/a
Default How to create a secondary y axis with limited data?

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