Graphs: 2 Lines on secondary Y-axis?

V

Valerie

My data has dollars and two sets of percentages that go with the dollars.
Ideally, I would like to bar graph the dollars on the primary Y-axis and line
graph the two sets of percentage data off the secondary Y-axis . . . is this
possible? I am not having any luck.

If not, could Excel graph the two pecentages as lines off the primary Y and
then bar graph off the secondary Y axis? The secondary axis only seems to be
a line and never a bar.
Thank you,
Valerie
 
L

LouiseD

Start with a line graph then change the dollar line to a column graph using
'change graph type". Then right click on one of the % lines to 'format data
series' and change it to the secondary axis. Do the same for the other %
line. good luck
 

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

Secondary axis not aligning to X axis 1
Make Y-axis values correspond to x- axis value 1
Coordinate secondary y axis to primary y axis 2
Exel - add vertical line to two axis graph 0
Secondary axis. 3
How do I change where category x axis crosses the 2nd y axis? 7
create bar graph with two series and secondary y axis 2
Swap Y-Axis numbers 3

Top