2nd vertical axis

I have read the thread on adding a second axis for one of
my series. But when I choose (under format serier) a
secondary axis, Excel is combining my two series together
into 1 bar (with 2 different colors). What I want is for
each category axis unit, TWO bars, each a different color,
and each tied to a different vertical axis (left and
right).

Surely this is possible? Any ideas?

Many thanks

Ben

Ben, you need to make the second data series a point plot
instead of a line. this way, it'll place the points over
top of the lines.

-----Original Message-----
I have read the thread on adding a second axis for one of
my series. But when I choose (under format serier) a
secondary axis, Excel is combining my two series together
into 1 bar (with 2 different colors). What I want is for
each category axis unit, TWO bars, each a different color,
and each tied to a different vertical axis (left and
right).

Surely this is possible? Any ideas?

Many thanks

Ben
.

Or you can add extra blank series to set the columns side by side
instead of one in front of the other:

http://peltiertech.com/Excel/Charts/...OnTwoAxes.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

Kevin M wrote:

Ben, you need to make the second data series a point plot
instead of a line. this way, it'll place the points over
top of the lines.


-----Original Message-----
I have read the thread on adding a second axis for one of
my series. But when I choose (under format serier) a
secondary axis, Excel is combining my two series together
into 1 bar (with 2 different colors). What I want is for
each category axis unit, TWO bars, each a different color,
and each tied to a different vertical axis (left and
right).

Surely this is possible? Any ideas?

Many thanks

Ben
.

I'm looking for the same thing as Ben, but I want the data
in both primary & secondary data series to appear in
column format. In other words, the data sets should both
appear in column format, but relating to 2 different
axes. When I change the secondary axis to column format,
it overlaps the primary data and the other data set
becomes hidden behind the column? How can you shift the
second data series over so they appear next to each other?

-----Original Message-----
Ben, you need to make the second data series a point plot
instead of a line. this way, it'll place the points over
top of the lines.

-----Original Message-----
I have read the thread on adding a second axis for one
of
my series. But when I choose (under format serier) a
secondary axis, Excel is combining my two series
together
into 1 bar (with 2 different colors). What I want is
for
each category axis unit, TWO bars, each a different
color,
and each tied to a different vertical axis (left and
right).

Surely this is possible? Any ideas?

Many thanks

Ben
.

.

You need to use some dummy series to get this effect:

http://peltiertech.com/Excel/Charts/...OnTwoAxes.html

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
http://PeltierTech.com/Excel/Charts/
_______

wrote:

I'm looking for the same thing as Ben, but I want the data
in both primary & secondary data series to appear in
column format. In other words, the data sets should both
appear in column format, but relating to 2 different
axes. When I change the secondary axis to column format,
it overlaps the primary data and the other data set
becomes hidden behind the column? How can you shift the
second data series over so they appear next to each other?


-----Original Message-----
Ben, you need to make the second data series a point plot
instead of a line. this way, it'll place the points over
top of the lines.


-----Original Message-----
I have read the thread on adding a second axis for one

of

my series. But when I choose (under format serier) a
secondary axis, Excel is combining my two series

together

into 1 bar (with 2 different colors). What I want is

for

each category axis unit, TWO bars, each a different

color,

and each tied to a different vertical axis (left and
right).

Surely this is possible? Any ideas?

Many thanks

Ben
.


.