LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #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
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
create bar graph with two series and secondary y axis macmullet Charts and Charting in Excel 2 June 5th 06 03:04 AM
How to Match and Sort two range of data? Tan New Users to Excel 1 March 5th 06 10:30 PM
Different Secondary X Axis but same Y Axis Mutiny_92 Charts and Charting in Excel 1 August 16th 05 05:17 PM
secondary axis tinyred Charts and Charting in Excel 3 August 4th 05 04:27 PM
Pulling data from 1 sheet to another Dave1155 Excel Worksheet Functions 1 January 12th 05 05:55 PM


All times are GMT +1. The time now is 12:53 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"