A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Using the full width of an Excel chart with two Y-axes



 
 
Thread Tools Display Modes
  #1  
Old April 10th, 2010, 09:49 AM posted to microsoft.public.excel.charting
Joern Schou-Rode
external usenet poster
 
Posts: 1
Default Using the full width of an Excel chart with two Y-axes

I am trying to create a line chart in Excel 2007 with two data series, each
with their own Y-axis.

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
X-axis tick point (x = 5) and the secondary (right most) Y-axis. Why does
Excel introduce this gap?

Is there anything I can do to avoid it? I have tried right clicking the
X-axis and seleting [Format Axis Axis Options Position Axis: Between tick
marks], but that only introduces a similar gap on by the primary (left most)
Y-axis.

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 Schou-Rode
Ads
  #2  
Old April 10th, 2010, 12:50 PM posted to microsoft.public.excel.charting
Bernard Liengme
external usenet poster
 
Posts: 516
Default Using the full width of an Excel chart with two Y-axes

Try with an XY chart -you can set min/max values fro x-axis
best wishes
--
Bernard Liengme
Microsoft Excel MVP
http://people.stfx.ca/bliengme

"Joern Schou-Rode" wrote in
message ...
I am trying to create a line chart in Excel 2007 with two data series,
each
with their own Y-axis.

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
X-axis tick point (x = 5) and the secondary (right most) Y-axis. Why does
Excel introduce this gap?

Is there anything I can do to avoid it? I have tried right clicking the
X-axis and seleting [Format Axis Axis Options Position Axis: Between
tick
marks], but that only introduces a similar gap on by the primary (left
most)
Y-axis.

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 Schou-Rode


  #3  
Old April 10th, 2010, 05:35 PM posted to microsoft.public.excel.charting
Jon Peltier[_2_]
external usenet poster
 
Posts: 386
Default Using the full width of an Excel chart with two Y-axes

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 Schou-Rode wrote:
I am trying to create a line chart in Excel 2007 with two data series, each
with their own Y-axis.

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
X-axis tick point (x = 5) and the secondary (right most) Y-axis. Why does
Excel introduce this gap?

Is there anything I can do to avoid it? I have tried right clicking the
X-axis and seleting [Format Axis Axis Options Position Axis: Between tick
marks], but that only introduces a similar gap on by the primary (left most)
Y-axis.

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 Schou-Rode

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 08:01 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2018, Jelsoft Enterprises Ltd.
Copyright 2004-2018 OfficeFrustration.
The comments are property of their posters.