Help!

column charts on two axis

  
  
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Charting RSS
Next:  pie of pie  
Author Message
Jo
External


Since: Mar 15, 2006
Posts: 86
PostPosted: Sun May 20, 2007 6:35 pm    Post subject: column charts on two axis
Archived from groups: microsoft>public>excel>charting (more info?)
I am trying to show a column chart on 2 axis. I have chosen the combination
line and column chart to get the 2 axis but when I change the line to a
second column it puts the columns over the top of the first axis columns. How
do I get them to be side by side?
Back to top
Jo
External


Since: Mar 15, 2006
Posts: 86
PostPosted: Sun May 20, 2007 8:43 pm    Post subject: RE: column charts on two axis [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Fantastic. Thanks

"Jo" wrote:

> I am trying to show a column chart on 2 axis. I have chosen the combination
> line and column chart to get the 2 axis but when I change the line to a
> second column it puts the columns over the top of the first axis columns. How
> do I get them to be side by side?
Back to top
Bernard Liengme
External


Since: Jan 27, 2004
Posts: 2596
PostPosted: Sun May 20, 2007 11:35 pm    Post subject: Re: column charts on two axis [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
Have a look at: http://peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.html
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Jo" <Jo.RemoveThis@discussions.microsoft.com> wrote in message
news:F3800842-2343-4319-8496-4D8CAC0DABFF@microsoft.com...
>I am trying to show a column chart on 2 axis. I have chosen the combination
> line and column chart to get the 2 axis but when I change the line to a
> second column it puts the columns over the top of the first axis columns.
> How
> do I get them to be side by side?
Back to top
Julie
External


Since: Apr 28, 2006
Posts: 98
PostPosted: Wed Oct 28, 2009 11:18 am    Post subject: RE: column charts on two axis [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
"Jo" wrote:

> I am trying to show a column chart on 2 axis. I have chosen the combination
> line and column chart to get the 2 axis but when I change the line to a
> second column it puts the columns over the top of the first axis columns. How
> do I get them to be side by side?
Back to top
Jon Peltier
External


Since: Feb 01, 2004
Posts: 179
PostPosted: Wed Oct 28, 2009 3:36 pm    Post subject: Re: column charts on two axis [Login to view extended thread Info.]
Archived from groups: per prev. post (more info?)
You need to use dummy series with no plotted values to move the visible
series to either side:

Columns on Two Axes
http://peltiertech.com/Excel/Charts/ColumnsOnTwoAxes.html

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



Julie wrote:
>
> "Jo" wrote:
>
>> I am trying to show a column chart on 2 axis. I have chosen the combination
>> line and column chart to get the 2 axis but when I change the line to a
>> second column it puts the columns over the top of the first axis columns. How
>> do I get them to be side by side?
Back to top
Display posts from previous:   
Post new topic   General Reply to Topic (not reply to a specific post)    Forums Home -> Charting All times are: Eastern Time (US & Canada) (change)
Page 1 of 1

 
 You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum