Trendline Question- Graph with TWO Y Axis???

P

phil6666

I have a graph which uses a primary & a secondary Y axis.

The trendline works fine for the series which uses the primary Y axis,
but the series using the secondary Y axis adds a trendline based on
the primary Y axis.

Am I doing something wrong?

thnx
 
A

Andy Pope

When you use the Add trend line dialog check that the trend line is
based on the correct data series.
 

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

Trendline Question- Graph with 2 Y Axis 5
color coordination between primary y and secondary y axis 1
extrapolating points on a trendline 1
Trendline equation and data do not match up 3
Exel - add vertical line to two axis graph 0
Excel chart does not start at zero. 1
how can i plot two different y-axis graph with same x-axis 1
Excel Chart question using two y axes 2

Top