If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. 


Thread Tools  Display Modes 
#1




Using the full width of an Excel chart with two Yaxes
I am trying to create a line chart in Excel 2007 with two data series, each
with their own Yaxis. First, I create a simple chart by selecting the two data series, and choosing [Insert Charts Line] from the Ribbon. I now see the following chart in my workbook: http://i41.tinypic.com/343jfdk.png I then continue my quest by right clicking one of the data series (lines) and choosing [Format data series Series Options Secondary Axis]. My chart is now looks like this: http://i40.tinypic.com/8wy3wg.png This is almost what I want. I did not expect to see the gap between the last Xaxis tick point (x = 5) and the secondary (right most) Yaxis. Why does Excel introduce this gap? Is there anything I can do to avoid it? I have tried right clicking the Xaxis and seleting [Format Axis Axis Options Position Axis: Between tick marks], but that only introduces a similar gap on by the primary (left most) Yaxis. The following data is sufficient for me to reproduce the problem. Paste it into Excel, select the block of numbers and create a line chart. It will not draw the exact same lines as above, but it will illustrate the problem with the right side "padding". 1 2 4 8 16 100 210 440 900 2000 I hope someone is able to help. Thanks in advance! /JÃ¸rn SchouRode 
Ads 
#2




Using the full width of an Excel chart with two Yaxes
Try with an XY chart you can set min/max values fro xaxis
best wishes  Bernard Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme "Joern SchouRode" wrote in message ... I am trying to create a line chart in Excel 2007 with two data series, each with their own Yaxis. First, I create a simple chart by selecting the two data series, and choosing [Insert Charts Line] from the Ribbon. I now see the following chart in my workbook: http://i41.tinypic.com/343jfdk.png I then continue my quest by right clicking one of the data series (lines) and choosing [Format data series Series Options Secondary Axis]. My chart is now looks like this: http://i40.tinypic.com/8wy3wg.png This is almost what I want. I did not expect to see the gap between the last Xaxis tick point (x = 5) and the secondary (right most) Yaxis. Why does Excel introduce this gap? Is there anything I can do to avoid it? I have tried right clicking the Xaxis and seleting [Format Axis Axis Options Position Axis: Between tick marks], but that only introduces a similar gap on by the primary (left most) Yaxis. The following data is sufficient for me to reproduce the problem. Paste it into Excel, select the block of numbers and create a line chart. It will not draw the exact same lines as above, but it will illustrate the problem with the right side "padding". 1 2 4 8 16 100 210 440 900 2000 I hope someone is able to help. Thanks in advance! /JÃ¸rn SchouRode 
#3




Using the full width of an Excel chart with two Yaxes
You need to add a secondary horizontal axis, and format it so the axis
crosses on the tick marks. You can then delete this axis if you don't need to see it. (Excel 2003 didn't need to do this, because its primary and secondary axes played nicely together.)  Jon  Jon Peltier Peltier Technical Services, Inc. http://peltiertech.com/ On 4/10/2010 4:49 AM, Joern SchouRode wrote: I am trying to create a line chart in Excel 2007 with two data series, each with their own Yaxis. First, I create a simple chart by selecting the two data series, and choosing [Insert Charts Line] from the Ribbon. I now see the following chart in my workbook: http://i41.tinypic.com/343jfdk.png I then continue my quest by right clicking one of the data series (lines) and choosing [Format data series Series Options Secondary Axis]. My chart is now looks like this: http://i40.tinypic.com/8wy3wg.png This is almost what I want. I did not expect to see the gap between the last Xaxis tick point (x = 5) and the secondary (right most) Yaxis. Why does Excel introduce this gap? Is there anything I can do to avoid it? I have tried right clicking the Xaxis and seleting [Format Axis Axis Options Position Axis: Between tick marks], but that only introduces a similar gap on by the primary (left most) Yaxis. The following data is sufficient for me to reproduce the problem. Paste it into Excel, select the block of numbers and create a line chart. It will not draw the exact same lines as above, but it will illustrate the problem with the right side "padding". 1 2 4 8 16 100 210 440 900 2000 I hope someone is able to help. Thanks in advance! /JÃ¸rn SchouRode 
Thread Tools  
Display Modes  

