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  

data to chart on primary axis



 
 
Thread Tools Display Modes
  #1  
Old September 16th, 2003, 08:27 AM
jw
external usenet poster
 
Posts: n/a
Default data to chart on primary axis

I have a series that I chart as a column, "Precipitation"
and three series that I chart as XY Scatter, "Plant Cover
1"...

I created the chart as a column chart and when I change
each of the "Plant Cover" series to an XY Scatter, Excel
chooses the "Precipitation" column to plot on the primary
axis. I would like "Precipitation" on the secondary axis
so the chart matches the format of my other charts.

I have tried to select the XY Scatter series and put them
on the primary axis, but the column just disappears.

I have tried starting with an XY Scatter chart first
also, and then changing the "Precipitation"

Sometimes I am able to get the graph I am looking for
with experimentation. But I never find a method I can
write down and use the next time. For example, when I
try to put "Precipitation" on the second axis and select
Secondary Y and Secondary x axes, sometimes the column
charts from the top of the chart down.

How can I find a consistent method?

Thank you in advance for any suggestions!
  #2  
Old September 16th, 2003, 06:13 PM
dvt
external usenet poster
 
Posts: n/a
Default data to chart on primary axis

jw wrote:
I have a series that I chart as a column, "Precipitation"
and three series that I chart as XY Scatter, "Plant Cover
1"...

I created the chart as a column chart and when I change
each of the "Plant Cover" series to an XY Scatter, Excel
chooses the "Precipitation" column to plot on the primary
axis. I would like "Precipitation" on the secondary axis
so the chart matches the format of my other charts.

I have tried to select the XY Scatter series and put them
on the primary axis, but the column just disappears.

I have tried starting with an XY Scatter chart first
also, and then changing the "Precipitation"

Sometimes I am able to get the graph I am looking for
with experimentation. But I never find a method I can
write down and use the next time. For example, when I
try to put "Precipitation" on the second axis and select
Secondary Y and Secondary x axes, sometimes the column
charts from the top of the chart down.

How can I find a consistent method?


This worked for me.

Create the chart with all series as XY scatter. Select the "Precipitation"
series, change it to the secondary axis. Right-click the chart and select
Chart Options | Data tab. Enable the secondary X axis. Now change the
Precipitation series to column.

The columns originate from the top, but I presume from your comments that
the matching charts are also like that.

Hope this helps.

Dave
dvt at psu dot edu


  #3  
Old September 17th, 2003, 04:23 PM
jw
external usenet poster
 
Posts: n/a
Default data to chart on primary axis

Hi,

Thank you for your response! I had tried exactly what
you suggested, but I do not want the columns to chart
from the top.

Our data is best represented when the scatter dots
overlie the precipitation bars. My other charts have
Percent Cover on the primary axis and Precipitation on
the secondary axis only because I set the scale to be the
same on each axis (kind of cheating). This will not work
with the current charts I am fixing.

Any more ideas?

Thanks again!


-----Original Message-----
jw wrote:
I have a series that I chart as a

column, "Precipitation"
and three series that I chart as XY Scatter, "Plant

Cover
1"...

I created the chart as a column chart and when I change
each of the "Plant Cover" series to an XY Scatter,

Excel
chooses the "Precipitation" column to plot on the

primary
axis. I would like "Precipitation" on the secondary

axis
so the chart matches the format of my other charts.

I have tried to select the XY Scatter series and put

them
on the primary axis, but the column just disappears.

I have tried starting with an XY Scatter chart first
also, and then changing the "Precipitation"

Sometimes I am able to get the graph I am looking for
with experimentation. But I never find a method I can
write down and use the next time. For example, when I
try to put "Precipitation" on the second axis and

select
Secondary Y and Secondary x axes, sometimes the column
charts from the top of the chart down.

How can I find a consistent method?


This worked for me.

Create the chart with all series as XY scatter. Select

the "Precipitation"
series, change it to the secondary axis. Right-click

the chart and select
Chart Options | Data tab. Enable the secondary X axis.

Now change the
Precipitation series to column.

The columns originate from the top, but I presume from

your comments that
the matching charts are also like that.

Hope this helps.

Dave
dvt at psu dot edu


.

  #4  
Old September 17th, 2003, 04:45 PM
dvt
external usenet poster
 
Posts: n/a
Default data to chart on primary axis

jw wrote:
Hi,

Thank you for your response! I had tried exactly what
you suggested, but I do not want the columns to chart
from the top.

Our data is best represented when the scatter dots
overlie the precipitation bars. My other charts have
Percent Cover on the primary axis and Precipitation on
the secondary axis only because I set the scale to be the
same on each axis (kind of cheating). This will not work
with the current charts I am fixing.

Any more ideas?


I think we may have a misunderstanding here. I think the basis of the
misunderstanding is the assumption that the secondary axes are on the
right/top of the screen, which is not necessarily true. Allow me to restate
the problem so you can correct me if I have it wrong.

You want one x-axis, preferably at the bottom of the screen. The x-axis
data for all series is the same and it is uniformly spaced so that a value
and category axis looks the same. You want two y-axes, the left y-axis
being percent cover and the right y-axis being precipitation.

Did I get that right? If so, you can move the primary y-axis to the right
and the secondary y-axis to the left side of your chart (sort of a
flipflop). You can also flipflop the x-axes. The basic idea is to select
an axis, Format | Selected axis | Scale tab, change the value next to "(X or
Y) axis crosses at:." More details if you need it.

Dave
dvt at psu dot edu


  #5  
Old September 18th, 2003, 05:53 AM
jw
external usenet poster
 
Posts: n/a
Default data to chart on primary axis

Thank you! You have correctly restated my problem. I
think I need details though. I selected the lower x axis
and adjusted the scale from "Value (y) axix crosses
between categories" to "Value (y) axis crosses at maximum
category" or "Categories in reverse order". The y axes
flipped! However, on the left side of the chart only a
title appeared, with no actual y axis. I tried to find
this y axis but it appears to be missing.

What should I try next?


I think we may have a misunderstanding here. I think

the basis of the
misunderstanding is the assumption that the secondary

axes are on the
right/top of the screen, which is not necessarily true.

Allow me to restate
the problem so you can correct me if I have it wrong.

You want one x-axis, preferably at the bottom of the

screen. The x-axis
data for all series is the same and it is uniformly

spaced so that a value
and category axis looks the same. You want two y-axes,

the left y-axis
being percent cover and the right y-axis being

precipitation.

Did I get that right? If so, you can move the primary y-

axis to the right
and the secondary y-axis to the left side of your chart

(sort of a
flipflop). You can also flipflop the x-axes. The basic

idea is to select
an axis, Format | Selected axis | Scale tab, change the

value next to "(X or
Y) axis crosses at:." More details if you need it.

Dave
dvt at psu dot edu


.

  #6  
Old September 18th, 2003, 01:02 PM
Jon Peltier
external usenet poster
 
Posts: n/a
Default data to chart on primary axis

You need to have at least one series for each axis. To assign a series
to primary or secondary axis, double click on it, and on the Axis tab,
select the desired axis.

If you've done this, and the desired axis does not show up, right click
the chart, select Chart Options from the pop up menu, click on the Axes
tab, and make sure all the desired axes are checked.

If the secondary Y axis still doesn't show up, Excel is trying to put it
and the primary axis in the same place. Repeat the last step to
(temporarily) add a secondary X axis, then format this axis so the
corresponding Y axis crosses where the primary Y axis isn't in the way.
By default, secondary axes are formatted so the axis crosses at the
maximum, so you can uncheck this box, and both Y axes should be visible.
Now you can uncheck the secondary X axis in the Chart Options/Axes dialog.

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

jw wrote:
Thank you! You have correctly restated my problem. I
think I need details though. I selected the lower x axis
and adjusted the scale from "Value (y) axix crosses
between categories" to "Value (y) axis crosses at maximum
category" or "Categories in reverse order". The y axes
flipped! However, on the left side of the chart only a
title appeared, with no actual y axis. I tried to find
this y axis but it appears to be missing.

What should I try next?


I think we may have a misunderstanding here. I think


the basis of the

misunderstanding is the assumption that the secondary


axes are on the

right/top of the screen, which is not necessarily true.


Allow me to restate

the problem so you can correct me if I have it wrong.

You want one x-axis, preferably at the bottom of the


screen. The x-axis

data for all series is the same and it is uniformly


spaced so that a value

and category axis looks the same. You want two y-axes,


the left y-axis

being percent cover and the right y-axis being


precipitation.

Did I get that right? If so, you can move the primary y-


axis to the right

and the secondary y-axis to the left side of your chart


(sort of a

flipflop). You can also flipflop the x-axes. The basic


idea is to select

an axis, Format | Selected axis | Scale tab, change the


value next to "(X or

Y) axis crosses at:." More details if you need it.

Dave
dvt at psu dot edu


.



  #7  
Old September 24th, 2003, 12:46 AM
jw
external usenet poster
 
Posts: n/a
Default data to chart on primary axis

Hi,
Thank you for the details! I will print this page and
try your directions. From the looks of the directions, I
think this may work. It took me a while to get back to
this project, and I do appreciate your help!


-----Original Message-----
You need to have at least one series for each axis. To

assign a series
to primary or secondary axis, double click on it, and on

the Axis tab,
select the desired axis.

If you've done this, and the desired axis does not show

up, right click
the chart, select Chart Options from the pop up menu,

click on the Axes
tab, and make sure all the desired axes are checked.

If the secondary Y axis still doesn't show up, Excel is

trying to put it
and the primary axis in the same place. Repeat the last

step to
(temporarily) add a secondary X axis, then format this

axis so the
corresponding Y axis crosses where the primary Y axis

isn't in the way.
By default, secondary axes are formatted so the axis

crosses at the
maximum, so you can uncheck this box, and both Y axes

should be visible.
Now you can uncheck the secondary X axis in the Chart

Options/Axes dialog.

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

jw wrote:
Thank you! You have correctly restated my problem. I
think I need details though. I selected the lower x

axis
and adjusted the scale from "Value (y) axix crosses
between categories" to "Value (y) axis crosses at

maximum
category" or "Categories in reverse order". The y

axes
flipped! However, on the left side of the chart only

a
title appeared, with no actual y axis. I tried to

find
this y axis but it appears to be missing.

What should I try next?


I think we may have a misunderstanding here. I think


the basis of the

misunderstanding is the assumption that the secondary


axes are on the

right/top of the screen, which is not necessarily

true.

Allow me to restate

the problem so you can correct me if I have it wrong.

You want one x-axis, preferably at the bottom of the


screen. The x-axis

data for all series is the same and it is uniformly


spaced so that a value

and category axis looks the same. You want two y-

axes,

the left y-axis

being percent cover and the right y-axis being


precipitation.

Did I get that right? If so, you can move the primary

y-

axis to the right

and the secondary y-axis to the left side of your

chart

(sort of a

flipflop). You can also flipflop the x-axes. The

basic

idea is to select

an axis, Format | Selected axis | Scale tab, change

the

value next to "(X or

Y) axis crosses at:." More details if you need it.

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 02:53 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.