Re: Create Chart with 2 value axis in PowerPoint 2003

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 data*** 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" <sglats@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:5417B5F8-0D91-4E01-86B8-086481A4757B@xxxxxxxxxxxxxxxx
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" wrote:

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" <RickTaylor@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:0CBA066D-384D-4B47-8FE4-9655CA46B964@xxxxxxxxxxxxxxxx
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.





.