How to create a secondary y axis with limited data?

N

Newperson

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
 
J

Jon Peltier

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/
_______
 
N

Newperson

Thanks Jon
It's a line chart and I don't need a secondary x axis. The data is in the
usual column format - four data series of > 300 points recording every 30
minutes or so spread over 6 days and two data series with 6 points recording
the max and min temps over the 6 days.
Have done this sort of chart endless times but this time there is a lot more
information from the monitoring points.
Cheers
Newperson
 
N

Newperson

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Coordinate secondary y axis to primary y axis 2
Reversing X axis flips Primary Y axis plot but not Secondary Y axis plot 1
Chart distorts secondary axis when the x-axis is logarithmic 5
Overlaying 2 Data Series with Different Time (X) Axis 3
Chart - Secondary Y-axis with different values/scale 2
Additional secondary axis scales 0
Secondary Axis Data Series "Clumping" 3
Assign data series to primary axis 1

Top