View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.charting
Jon Peltier Jon Peltier is offline
external usenet poster
 
Posts: 6,582
Default Hide Graph of Data Outside X-Axis Range

If none of your series use markers, the lines should terminate on the
boundaries of the plot area. If there are any markers, Excel displays a thin
margin outside the plot area boundaries, so the markers on the boundary are
not truncated.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Tutorials and Custom Solutions
Peltier Technical Services, Inc. - http://PeltierTech.com
_______


"CJMITCHELL" wrote in message
...
I have an XY Scatter graph with data back into the 1990's (for example,
10-Year US Treasury yields). The graph references all of the data so that
when I change the dates on the x-axis (my range of dates I want to view),
I
don't have to redo the data references.

The problem is, the graph of Treasury yields (let's call it a blue line)
is
starting outside the chart border where the y-axis labels are...instead of
starting at the y-axis. Any thoughts on how to fix this?

Thanks in advance.