How do I add a data series in a combination chart in PPT 2003?


S

Scott

I have a combination bar/line chart showing gross revenues and passengers by
month over a 3-year period. The gross revenues are bars on the primary
y-axis and passengers are lines on the secondary y-axis.

I am trying to add gross revenues and passengers for CY2010. I am able to
add a data series for the passengers, but when I try to add a data series for
the gross revenues, the chart treats it as a series on the secondary axis as
a line.

How do I add the series as a bar on the primary axis, or alternatively,
change the series from a line on the secondary axis to a bar on the primary
axis?

Your help greatly appreciated!
 
Ad

Advertisements

E

Echo S

Right-click the series and choose Change Chart Type. Choose the column
chart.

Then right-click the series and choose Format Data Series. On the Axis tab,
choose Primary Axis.

(Going by memory here, as I don't have PPT 2003 handy right this minute. If
my memory isn't as good as it should be, holler back and we can look for
exact places.)
 
Ad

Advertisements

S

Scott

Thank you, Echo S. This worked perfectly. I actually tried this before I
saw your post; great minds thing in the same direction.
--
Scott


Echo S said:
Right-click the series and choose Change Chart Type. Choose the column
chart.

Then right-click the series and choose Format Data Series. On the Axis tab,
choose Primary Axis.

(Going by memory here, as I don't have PPT 2003 handy right this minute. If
my memory isn't as good as it should be, holler back and we can look for
exact places.)

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



Scott said:
I have a combination bar/line chart showing gross revenues and passengers
by
month over a 3-year period. The gross revenues are bars on the primary
y-axis and passengers are lines on the secondary y-axis.

I am trying to add gross revenues and passengers for CY2010. I am able to
add a data series for the passengers, but when I try to add a data series
for
the gross revenues, the chart treats it as a series on the secondary axis
as
a line.

How do I add the series as a bar on the primary axis, or alternatively,
change the series from a line on the secondary axis to a bar on the
primary
axis?

Your help greatly appreciated!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top