PC Review

Thread Tools Rate Thread

Re: Display of secondary axis trendline for a secondary axis plot

Jon Peltier
Posts: n/a
      21st Sep 2004
Ian -

I just made an XY chart with two series, one primary and one secondary. I was able to add a
trendline for each series, and both trendlines appeared with no problem. Perhaps I chose too
simple a model of your problem. What kind of chart is this? How different are the scales? Could
you post a sample of your data (as text right in your reply)?

- Jon
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions

iancomputing wrote:

> I'm having trouble getting an Excel XP chart to display the trend line for a
> plot related to the secondary axis. When I do so, it shows up on the legend
> list, but not (observedly) on the graph itself.
> If I change all to the primary axis, then I can get the problem line trended
> - that is, I can see the trend line (but of little use at that scaling).

Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
Re: Reversing X axis flips Primary Y axis plot but not Secondary Y axisplot Tobi Ackerman Microsoft Excel Charting 1 9th May 2012 12:12 AM
Anyway to plot a stacked bar and bar chart on Primary and Secondary axis? Father Guido Microsoft Excel Charting 2 10th Jan 2008 06:42 AM
Trendline on Secondary Axis =?Utf-8?B?SG9vY2hpIENvb2NoaSBNYW4=?= Microsoft Excel Charting 0 13th Jan 2005 06:13 PM
Display of secondary axis trendline for a secondary axis plot =?Utf-8?B?aWFuY29tcHV0aW5n?= Microsoft Excel Charting 0 20th Sep 2004 03:47 PM
How To Plot data on secondary value axis in excel chart from vb code Srinivas Reddy Microsoft Excel Programming 2 29th Mar 2004 06:37 AM




All times are GMT +1. The time now is 06:46 AM.