Link to home
Start Free TrialLog in
Avatar of khaledc
khaledc

asked on

Create XY Scatter Chart with Two Y axis?

I would like to create a chart of type XY Scatter that has two Y axis. (Not a line on 2 axes). How do I go about doing this in Excel 7.0
Avatar of LostMyBrain
LostMyBrain

Hi,

It is very simple: Prepare your worksheet and then click on the ChartWizard.
Choose XY scatter type and go to step 2.
in step 2 move to the Series Tab, in which you can define any number of series to put on the graph, for each one you can set the title, X values, and Y values.

If you mean anything else, please describe in more details.

-LostMyBrain.
Avatar of khaledc

ASKER

I am not asking how to do XY Scatter with more than one Y series, I need a XY Scatter with Two Y axis (on each side of the Chart).
Cheers
ASKER CERTIFIED SOLUTION
Avatar of cri
cri
Flag of Switzerland image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial