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  

Histogram with 2 axis



 
 
Thread Tools Display Modes
  #1  
Old October 14th, 2003, 01:36 AM
Fx_D@v
external usenet poster
 
Posts: n/a
Default Histogram with 2 axis

Hi,

In a histogram chart type, I have several countries on the x axis and
two rectangles for each country giving their gdp and gdp per capita
level.

What I want to do is assign gdp to the left Y-axis and gdp per capita
to the right Y-axis.

Usually, I just change the data series option so it assign it to the
secondary axis.

However, when I do this in an histogram, excel also automatically
group the two rectangles together for each country.

Does anyone knows how to avoid that ?

I'm using office XP.

Thanks a lot for your help!



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/

  #2  
Old October 14th, 2003, 05:03 PM
Jon Peltier
external usenet poster
 
Posts: n/a
Default Histogram with 2 axis

Check out this page:

http://www.geocities.com/jonpeltier/...OnTwoAxes.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Fx_D@v wrote:
Hi,

In a histogram chart type, I have several countries on the x axis and
two rectangles for each country giving their gdp and gdp per capita
level.

What I want to do is assign gdp to the left Y-axis and gdp per capita
to the right Y-axis.

Usually, I just change the data series option so it assign it to the
secondary axis.

However, when I do this in an histogram, excel also automatically
group the two rectangles together for each country.

Does anyone knows how to avoid that ?

I'm using office XP.

Thanks a lot for your help!



------------------------------------------------
~~ Message posted from http://www.ExcelTip.com/
~~ View and post usenet messages directly from http://www.ExcelForum.com/


  #3  
Old October 14th, 2003, 05:42 PM
dvt
external usenet poster
 
Posts: n/a
Default Histogram with 2 axis

Fx_D@v wrote:
In a histogram chart type, I have several countries on the x axis and=


two rectangles for each country giving their gdp and gdp per capita
level.

What I want to do is assign gdp to the left Y-axis and gdp per capita=


to the right Y-axis.

Usually, I just change the data series option so it assign it to the
secondary axis.

However, when I do this in an histogram, excel also automatically
group the two rectangles together for each country.

Does anyone knows how to avoid that ?


Here's one way: add two more data series, both with all zeros. Your da=
ta =

looks like this:

Country gdp gdp/cap zeros1 zeros2
ctry1 100 3 0 0
ctry2 350 4 0 0

Now add the two sets of zeros to your chart. Plot series "zeros1" on th=
e =

primary axes and plot "zeors2" on the secondary axes.

Now select your gdp series, go to Format | Selected Data Series | Series=
=

order tab. Arrange it so that the gdp is first and zeros1 is second. D=
o =

the same with the gdp/cap series, but make zeros2 first and gdp/cap seco=
nd.

-- =

Dave
dvt at psu dot edu
 




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 11:20 PM.


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