Line Chart with 2 Y-AXES

E

edvolchok

How do I create a line chart with 2 Y-Axes? Y1 on left would be for
frequency, Y2 on right would be for percentage.

Thanks for your help.

Edward Volchok
 
L

little_creature

Hello,
Select the data series in the chart you want to put on another axis (click
on that line) and do Format>selected data series>axis>and pick secondaty
axis.
Hope this helps, if not post back
 
E

edvolchok

Hello,
Select the data series in the chart you want to put on another axis (click
on that line) and do Format>selected data series>axis>and pick secondaty
axis.
Hope this helps, if not post back

Thanks for you reply. I'm missing something. I god to Format>selected
data series>axis>and pick secondaty
axis. But, the plot on primary and secondary axis are greyed out.

Clearly I missing something. This is frustrating as I used to create
these charts a dozen years ago. Any suggestions?

Edward Volchok
 
L

little_creature

Thanks for you reply. I'm missing something. I god to Format>selected
data series>axis>and pick secondaty


Clearly I missing something. This is frustrating as I used to create
these charts a dozen years ago. Any suggestions?

Edward Volchok

Hello,
which chart type do you use?
I have tried now on PC randomly change the chart type, but in all
trial I still was able to put some data on secondary axis.

Are in your chart more than 1 series? That must be in order to put one
on primary and second on secondary.

If you can/would like you can send me your file to
litttle.creature.incATgmail.com so I will have a look, I do not assure
you that I will solve it, but it's always easier for debuging to have
hands on that particular file.
just replace AT by @ in my email address.
 

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