Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to create a secondary y axis with limited data?
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 |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to create a secondary y axis with limited data?
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 "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 |
#4
Posted to microsoft.public.excel.charting
|
|||
|
|||
How to create a secondary y axis with limited data?
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
create bar graph with two series and secondary y axis | Charts and Charting in Excel | |||
How to Match and Sort two range of data? | New Users to Excel | |||
Different Secondary X Axis but same Y Axis | Charts and Charting in Excel | |||
secondary axis | Charts and Charting in Excel | |||
Pulling data from 1 sheet to another | Excel Worksheet Functions |