How does one create a graph in Excel with 2 axes, combining a lin.

S

sundancerider

I have data for 2 years showing the number of males & females in a group, and
dollar volumes associated with each, broken down into age groups.

I want the age groups on the X axis; stacked columns showing the male/female
breakdown of people in each age group, side by side with the two years; and a
line graph plotted on a secondary Y axis for the dollar volumes - one line
for year 1, another for year 2.

Excel 2002's built in help says I should select a data series, choose
'format', click 'selected data series' then choose the axis tab. However no
axis tab appears.

Any suggestions?
 

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

Similar Threads

Adding a line to a population bar chart 0
Plotting Graph with dynamic table 3
Combining a 2-D column graph and a 2-D line graph on the same char 3
Column Chart with 2 axes 7
How do I create a bubble graph 2
Create a bar graph with three sets of labels 3
How to draw out a bar chart backed by a 3-dimension database 3
Using the full width of an Excel chart with two Y-axes 2

Top