Double y-axis scatter plot.....?

C

Chikngizrd

I've encountered a problem that seems like it should be easy but I'v
played with it and can't get it to work acceptably.

I have 2 y-variables related to a single x variable. Specifically I'
comparing Parallax shift to distance and the associated percent erro
of distance measurement to the distance.

The x, of course is my actual distance to the star. One y quantity i
parallax shift. The other is % Error.

I can get Excel to do a double y line graph, no problem. My proble
stems from the fact my x data values are not evenly distributed as a
Excel line graph plots them to be. A scatter graph plots correctly bu
that only gives me a single y-axis and both lines are plotted agains
the same scale.

What I need is a scatter plot that will have 2 y-axis and then I ca
insert a trendline for each quantity.

Any help
 
T

Tushar Mehta

Create the XY Scatter chart. Then, on the chart double-click one of
the series. In the resulting dialog box, from the Axis tab select
Secondary.

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 

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

Scatter chart with categories on x-Axis 2
Non Linear Scatter plot, need to find y value 3
Make Y-axis values correspond to x- axis value 1
How do I stop trendline from touching the y-axis? 7
Reversing X axis flips Primary Y axis plot but not Secondary Y axis plot 1
Making Equal Spacing between --> X-Axis = Y-Axis, in a char 1
Use text descriptors as Y axis units 1
Charting scientific data - Excel 2003 5

Top