Create Chart with 2 value axis in PowerPoint 2003

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to create a slide that has a chart with two seperate value axis.
On the left I would like values in Thousands (with two legend labels,
Inductions and Flight Hours), and on the right have values in Dollars in
Millions ( with two legend labels, AFM and AVDLR). Each Month would then
have the 4 entries for those values and the reader would be able to see from
the legend wheter the column they are looking at is thousands or millions.
There was a similar type question from Ken Murray answered by John Fallon,
but I couldn't really follow the answer in trying to set up my chart. John
mentions a chart that would have homes sold on the left and average cost on
the right, which seems that it would match my requirements, though I would be
having four columns, vice 2. Thank you for any guidance that can be provided.
 
Input your data and create your column chart. Then right-click the data you
want to be tied to the 2nd value axis (on the right), choose Format Data
Series, go to the Axis tab, and choose Secondary Axis. Note that you need to
use a 2D chart, not a 3D chart, in order to have the secondary axis option.
 
I'd like to follow up on this post. I too am trying to create a 2D bar chart
with two seperate y axes. I followed the directions below. While the chart
recognized the two axis, it put the bars for each data series on top of each
other as opposed to side by side. I know the chart type selected is
side-by-side. The values aren't stacked. The bars actually overlap each
other. How do i get them side by side? I've never had this issue before.
I'm using PPT 2003.

Echo S said:
Input your data and create your column chart. Then right-click the data you
want to be tied to the 2nd value axis (on the right), choose Format Data
Series, go to the Axis tab, and choose Secondary Axis. Note that you need to
use a 2D chart, not a 3D chart, in order to have the secondary axis option.

--
Echo [MS PPT MVP] http://www.echosvoice.com
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/
How to Prevent PowerPoint Overload (March 23 webcast)
http://tinyurl.com/bp2h8


Rick Taylor said:
I am trying to create a slide that has a chart with two seperate value
axis.
On the left I would like values in Thousands (with two legend labels,
Inductions and Flight Hours), and on the right have values in Dollars in
Millions ( with two legend labels, AFM and AVDLR). Each Month would then
have the 4 entries for those values and the reader would be able to see
from
the legend wheter the column they are looking at is thousands or millions.
There was a similar type question from Ken Murray answered by John Fallon,
but I couldn't really follow the answer in trying to set up my chart.
John
mentions a chart that would have homes sold on the left and average cost
on
the right, which seems that it would match my requirements, though I would
be
having four columns, vice 2. Thank you for any guidance that can be
provided.
Click to expand...
Click to expand...
 
Yes, you have to fake it.

For example, if you have a column chart with 2 series, you could add a row
of cells before the first series and another row before the second.

So your datasheet would look like

column 1: 0, 0, 0, 0
east: 20, 40, 60, 80
column 3: 0, 0, 0, 0
west: 5, 10, 15, 20

Type in 100 instead of a 0 for column 1. Right-click, format data series,
set to secondary axis.
Right-click East and set to primary axis.
Type in 100 instead of a 0 for column 3. Right-click, format data series,
set to primary axis.
Right-click the west series, format data series, set it to secondary axis.

Once you've set the axes, you can change the 100 back to 0.

If you prefer, you can skip changing the data and just select the
appropriate series from the drop-down box on the toolbar. I just suggested
the data change so you can quickly see what's happening.

Finally, delete the legend entries.

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/
PPTLive! Sept 17-20, 2006 http://www.pptlive.com

sglats said:
I'd like to follow up on this post. I too am trying to create a 2D bar
chart
with two seperate y axes. I followed the directions below. While the
chart
recognized the two axis, it put the bars for each data series on top of
each
other as opposed to side by side. I know the chart type selected is
side-by-side. The values aren't stacked. The bars actually overlap each
other. How do i get them side by side? I've never had this issue before.
I'm using PPT 2003.

Echo S said:
Input your data and create your column chart. Then right-click the data
you
want to be tied to the 2nd value axis (on the right), choose Format Data
Series, go to the Axis tab, and choose Secondary Axis. Note that you need
to
use a 2D chart, not a 3D chart, in order to have the secondary axis
option.

--
Echo [MS PPT MVP] http://www.echosvoice.com
Fixing PowerPoint Annoyances
http://www.oreilly.com/catalog/powerpointannoy/
How to Prevent PowerPoint Overload (March 23 webcast)
http://tinyurl.com/bp2h8


Rick Taylor said:
I am trying to create a slide that has a chart with two seperate value
axis.
On the left I would like values in Thousands (with two legend labels,
Inductions and Flight Hours), and on the right have values in Dollars
in
Millions ( with two legend labels, AFM and AVDLR). Each Month would
then
have the 4 entries for those values and the reader would be able to see
from
the legend wheter the column they are looking at is thousands or
millions.
There was a similar type question from Ken Murray answered by John
Fallon,
but I couldn't really follow the answer in trying to set up my chart.
John
mentions a chart that would have homes sold on the left and average
cost
on
the right, which seems that it would match my requirements, though I
would
be
having four columns, vice 2. Thank you for any guidance that can be
provided.
Click to expand...
Click to expand...
Click to expand...
 
Sorry Echo but I'm not getting this. I'm trying to make a two-column chart
with two axis lines, one for $billions and one for $millions. Much simplier
than Rick's but I just can't figure out how to do it without having the
columns stack.
--
etf


Echo S said:
Yes, you have to fake it.

For example, if you have a column chart with 2 series, you could add a row
of cells before the first series and another row before the second.

So your datasheet would look like

column 1: 0, 0, 0, 0
east: 20, 40, 60, 80
column 3: 0, 0, 0, 0
west: 5, 10, 15, 20

Type in 100 instead of a 0 for column 1. Right-click, format data series,
set to secondary axis.
Right-click East and set to primary axis.
Type in 100 instead of a 0 for column 3. Right-click, format data series,
set to primary axis.
Right-click the west series, format data series, set it to secondary axis.

Once you've set the axes, you can change the 100 back to 0.

If you prefer, you can skip changing the data and just select the
appropriate series from the drop-down box on the toolbar. I just suggested
the data change so you can quickly see what's happening.

Finally, delete the legend entries.

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://www.oreilly.com/catalog/powerpointannoy/
PPTLive! Sept 17-20, 2006 http://www.pptlive.com

sglats said:
I'd like to follow up on this post. I too am trying to create a 2D bar
chart
with two seperate y axes. I followed the directions below. While the
chart
recognized the two axis, it put the bars for each data series on top of
each
other as opposed to side by side. I know the chart type selected is
side-by-side. The values aren't stacked. The bars actually overlap each
other. How do i get them side by side? I've never had this issue before.
I'm using PPT 2003.

Echo S said:
Input your data and create your column chart. Then right-click the data
you
want to be tied to the 2nd value axis (on the right), choose Format Data
Series, go to the Axis tab, and choose Secondary Axis. Note that you need
to
use a 2D chart, not a 3D chart, in order to have the secondary axis
option.

--
Echo [MS PPT MVP] http://www.echosvoice.com
Fixing PowerPoint Annoyances
http://www.oreilly.com/catalog/powerpointannoy/
How to Prevent PowerPoint Overload (March 23 webcast)
http://tinyurl.com/bp2h8


I am trying to create a slide that has a chart with two seperate value
axis.
On the left I would like values in Thousands (with two legend labels,
Inductions and Flight Hours), and on the right have values in Dollars
in
Millions ( with two legend labels, AFM and AVDLR). Each Month would
then
have the 4 entries for those values and the reader would be able to see
from
the legend wheter the column they are looking at is thousands or
millions.
There was a similar type question from Ken Murray answered by John
Fallon,
but I couldn't really follow the answer in trying to set up my chart.
John
mentions a chart that would have homes sold on the left and average
cost
on
the right, which seems that it would match my requirements, though I
would
be
having four columns, vice 2. Thank you for any guidance that can be
provided.
Click to expand...
Click to expand...
Click to expand...
 
You're not plotting by columns, are you? (Data | Series in Columns vs Data |
Series in Rows)

Maybe I should label the data like this -- it might help. I named the rows
"columns" below, and that's confusing.

1st Q 2nd Q 3rd Q 4th Q
dummy data A: 0 0 0 0
east: 20 40 60 80
dummy data B: 0 0 0 0
west: 5 10 15 20

When I set up the chart, I changed the first 0 to 100 in dummy data A. This
was just so I could select the series easily and see the bar on the chart.

I did the same for dummy data B -- using the 2nd 0.

After you set each data series to the correct axis, change the 100s back to
0 so no data shows in the dummies and looks like it does above.

Basically you're just forcing positioning by putting in dummy data. DDA (on
the secondary axis) overlaps East (on the primary axis) in the first
position. West (on the secondary axis) overlaps DDB (on the primary axis) in
the second position.

When you change the DDA and DDB data to all 0s, they don't show, so you
shouldn't see any overlap. You should just see East on the primary in the
first position and West on the secondary axis in the second position.

Does that make sense?

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx


etf said:
Sorry Echo but I'm not getting this. I'm trying to make a two-column chart
with two axis lines, one for $billions and one for $millions. Much
simplier
than Rick's but I just can't figure out how to do it without having the
columns stack.
--
etf


Echo S said:
Yes, you have to fake it.

For example, if you have a column chart with 2 series, you could add a
row
of cells before the first series and another row before the second.

So your datasheet would look like

column 1: 0, 0, 0, 0
east: 20, 40, 60, 80
column 3: 0, 0, 0, 0
west: 5, 10, 15, 20

Type in 100 instead of a 0 for column 1. Right-click, format data series,
set to secondary axis.
Right-click East and set to primary axis.
Type in 100 instead of a 0 for column 3. Right-click, format data series,
set to primary axis.
Right-click the west series, format data series, set it to secondary
axis.

Once you've set the axes, you can change the 100 back to 0.

If you prefer, you can skip changing the data and just select the
appropriate series from the drop-down box on the toolbar. I just
suggested
the data change so you can quickly see what's happening.

Finally, delete the legend entries.

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances
http://www.oreilly.com/catalog/powerpointannoy/
PPTLive! Sept 17-20, 2006 http://www.pptlive.com

sglats said:
I'd like to follow up on this post. I too am trying to create a 2D bar
chart
with two seperate y axes. I followed the directions below. While the
chart
recognized the two axis, it put the bars for each data series on top of
each
other as opposed to side by side. I know the chart type selected is
side-by-side. The values aren't stacked. The bars actually overlap
each
other. How do i get them side by side? I've never had this issue
before.
I'm using PPT 2003.

:

Input your data and create your column chart. Then right-click the
data
you
want to be tied to the 2nd value axis (on the right), choose Format
Data
Series, go to the Axis tab, and choose Secondary Axis. Note that you
need
to
use a 2D chart, not a 3D chart, in order to have the secondary axis
option.

--
Echo [MS PPT MVP] http://www.echosvoice.com
Fixing PowerPoint Annoyances
http://www.oreilly.com/catalog/powerpointannoy/
How to Prevent PowerPoint Overload (March 23 webcast)
http://tinyurl.com/bp2h8


I am trying to create a slide that has a chart with two seperate
value
axis.
On the left I would like values in Thousands (with two legend
labels,
Inductions and Flight Hours), and on the right have values in
Dollars
in
Millions ( with two legend labels, AFM and AVDLR). Each Month would
then
have the 4 entries for those values and the reader would be able to
see
from
the legend wheter the column they are looking at is thousands or
millions.
There was a similar type question from Ken Murray answered by John
Fallon,
but I couldn't really follow the answer in trying to set up my
chart.
John
mentions a chart that would have homes sold on the left and average
cost
on
the right, which seems that it would match my requirements, though I
would
be
having four columns, vice 2. Thank you for any guidance that can be
provided.
Click to expand...
Click to expand...
Click to expand...
 
That did it Echo! Thanks a million. Chat with you soon.
--
etf


Echo S said:
You're not plotting by columns, are you? (Data | Series in Columns vs Data |
Series in Rows)

Maybe I should label the data like this -- it might help. I named the rows
"columns" below, and that's confusing.

1st Q 2nd Q 3rd Q 4th Q
dummy data A: 0 0 0 0
east: 20 40 60 80
dummy data B: 0 0 0 0
west: 5 10 15 20

When I set up the chart, I changed the first 0 to 100 in dummy data A. This
was just so I could select the series easily and see the bar on the chart.

I did the same for dummy data B -- using the 2nd 0.

After you set each data series to the correct axis, change the 100s back to
0 so no data shows in the dummies and looks like it does above.

Basically you're just forcing positioning by putting in dummy data. DDA (on
the secondary axis) overlaps East (on the primary axis) in the first
position. West (on the secondary axis) overlaps DDB (on the primary axis) in
the second position.

When you change the DDA and DDB data to all 0s, they don't show, so you
shouldn't see any overlap. You should just see East on the primary in the
first position and West on the secondary axis in the second position.

Does that make sense?

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances http://tinyurl.com/36grcd
PowerPoint 2007 Complete Makeover Kit http://tinyurl.com/32a7nx


etf said:
Sorry Echo but I'm not getting this. I'm trying to make a two-column chart
with two axis lines, one for $billions and one for $millions. Much
simplier
than Rick's but I just can't figure out how to do it without having the
columns stack.
--
etf


Echo S said:
Yes, you have to fake it.

For example, if you have a column chart with 2 series, you could add a
row
of cells before the first series and another row before the second.

So your datasheet would look like

column 1: 0, 0, 0, 0
east: 20, 40, 60, 80
column 3: 0, 0, 0, 0
west: 5, 10, 15, 20

Type in 100 instead of a 0 for column 1. Right-click, format data series,
set to secondary axis.
Right-click East and set to primary axis.
Type in 100 instead of a 0 for column 3. Right-click, format data series,
set to primary axis.
Right-click the west series, format data series, set it to secondary
axis.

Once you've set the axes, you can change the 100 back to 0.

If you prefer, you can skip changing the data and just select the
appropriate series from the drop-down box on the toolbar. I just
suggested
the data change so you can quickly see what's happening.

Finally, delete the legend entries.

--
Echo [MS PPT MVP] http://www.echosvoice.com
What's new in PPT 2007? http://www.echosvoice.com/2007.htm
Fixing PowerPoint Annoyances
http://www.oreilly.com/catalog/powerpointannoy/
PPTLive! Sept 17-20, 2006 http://www.pptlive.com

I'd like to follow up on this post. I too am trying to create a 2D bar
chart
with two seperate y axes. I followed the directions below. While the
chart
recognized the two axis, it put the bars for each data series on top of
each
other as opposed to side by side. I know the chart type selected is
side-by-side. The values aren't stacked. The bars actually overlap
each
other. How do i get them side by side? I've never had this issue
before.
I'm using PPT 2003.

:

Input your data and create your column chart. Then right-click the
data
you
want to be tied to the 2nd value axis (on the right), choose Format
Data
Series, go to the Axis tab, and choose Secondary Axis. Note that you
need
to
use a 2D chart, not a 3D chart, in order to have the secondary axis
option.

--
Echo [MS PPT MVP] http://www.echosvoice.com
Fixing PowerPoint Annoyances
http://www.oreilly.com/catalog/powerpointannoy/
How to Prevent PowerPoint Overload (March 23 webcast)
http://tinyurl.com/bp2h8


I am trying to create a slide that has a chart with two seperate
value
axis.
On the left I would like values in Thousands (with two legend
labels,
Inductions and Flight Hours), and on the right have values in
Dollars
in
Millions ( with two legend labels, AFM and AVDLR). Each Month would
then
have the 4 entries for those values and the reader would be able to
see
from
the legend wheter the column they are looking at is thousands or
millions.
There was a similar type question from Ken Murray answered by John
Fallon,
but I couldn't really follow the answer in trying to set up my
chart.
John
mentions a chart that would have homes sold on the left and average
cost
on
the right, which seems that it would match my requirements, though I
would
be
having four columns, vice 2. Thank you for any guidance that can be
provided.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top