dual y axis

G

Guest

Hello,

I am trying to have a graph with 2 y axis.
Left Y axis will represent dollars and right Y axis percents.

I am used to creating these in excel 2003 without a problem, but now can not
do so.

I like to use Bars for dollar axis (left Y axis) and Line for percent axix
(right Y axis).
 
A

Andy Pope

Hi,

Assume you are now using xl2007. Here are some instruction for creating
combination chart with 2 y axis.

Create a standard clustered column chart based on both sets of data.
Select the percents series, right click and pick Change Series chart
type...
Select the line chart type.
Select the new line series and right click, pick Format Data Series. Select
Series Option, if not already active, and set secondary axis.

Cheers
Andy
 

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

Make Y-axis values correspond to x- axis value 1
How do I put words as the Y axis values? 0
Graphs: 2 Lines on secondary Y-axis? 1
move y-axis to the left of x-axis "0" 2
One Column on 1st y-axis and 3 lines on 2nd y-axis 1
How to add another y-axis range into chart? 1
Changing y axis labels 1
Chart distorts secondary axis when the x-axis is logarithmic 5

Top