Hide Graph of Data Outside X-Axis Range
in [Charts]
|
Prev: Label a chart of counts with other percentage data
Next: Dividing a bar in a graph into several sections
From: CJMITCHELL on 17 Jun 2008 17:19 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.
From: Jon Peltier on 17 Jun 2008 18:15 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" <CJMITCHELL(a)discussions.microsoft.com> wrote in message news:F33F28C3-171C-4DD9-889B-54671FA22D4E(a)microsoft.com... >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.
From: CJMITCHELL on 17 Jun 2008 19:49
I checked, and markers is set to "None" for each series. As a workaround, I used a recommendation you gave someone else for another issue...set up an adjacent column that feeds the graph with either (1) data within my date range, or (2) #N/A if the data doesn't fall within my date range. If you have other ideas, I'd be interested. Thanks for your help Jon. By the way, your website rocks! "Jon Peltier" wrote: > 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" <CJMITCHELL(a)discussions.microsoft.com> wrote in message > news:F33F28C3-171C-4DD9-889B-54671FA22D4E(a)microsoft.com... > >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. > > > |