Trendline Issues

Microsoft Office 2000


I have two graphs on one chart and both axis are used.  The left axis is 
based on whole numbers.  The right axis is based on percentages.  I have 
no problem adding a trendline to the line graph using the left axis.  I 
cannot add a trendline to the line graph using the right axis 
(percentages).  When I right click the line graph and select "Add 
trendline" nothing shows up.  However, the "undo" feature says "Undo add 
trendline".  Could Excel be trying to use the left axis as reference for 
this trendline?

Also, for additional information... I've had others in my workgroup 
using newer versions of Excel to try to add the trendline as well.  No 
luck with newer versions either.

Any help is greatly appreciated!

Rita Brasher
Project Engineer / Int'l MIS and Analysis
FedEx Express
0
rmpalazzi (92)
5/7/2008 1:38:19 PM
excel.charting 18370 articles. 0 followers. Follow

4 Replies
540 Views

Similar Articles

[PageSpeed] 13

Hi,

Which sub-type of line are you using? Stacked lines can not have Trendlines.

I created a line chart with 2 data series, number and percents. Placing the 
percents onto the secondary axis.
When I select either series and right click I can see the Add Trendline 
option.

The Trendline dialog, Type tab, allows me to pick which series to base the 
trendline on.
Can you see both series in the list, Based on Series: ?

Cheers
Andy

-- 

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Rita Palazzi" <rmpalazzi@fedex.com> wrote in message 
news:OZL%23PeEsIHA.524@TK2MSFTNGP05.phx.gbl...
> Microsoft Office 2000
>
>
> I have two graphs on one chart and both axis are used.  The left axis is 
> based on whole numbers.  The right axis is based on percentages.  I have 
> no problem adding a trendline to the line graph using the left axis.  I 
> cannot add a trendline to the line graph using the right axis 
> (percentages).  When I right click the line graph and select "Add 
> trendline" nothing shows up.  However, the "undo" feature says "Undo add 
> trendline".  Could Excel be trying to use the left axis as reference for 
> this trendline?
>
> Also, for additional information... I've had others in my workgroup using 
> newer versions of Excel to try to add the trendline as well.  No luck with 
> newer versions either.
>
> Any help is greatly appreciated!
>
> Rita Brasher
> Project Engineer / Int'l MIS and Analysis
> FedEx Express 

0
andy9699 (3616)
5/7/2008 2:10:57 PM
Andy,
I can see both series in the list.  As far as I can tell, they're both 
just regular lines, not stacked. One may have markers, but still just a 
regular line.   I have no issue adding a trendline if both axis values 
are whole numbers.  It's the ones with the percentage on the secondary 
axis that I am having issues with.  Can you tell me what version of 
Excel you're using?  Maybe I've missed an update somewhere along the 
way, but I'm not the only one having this issue and my version doesn't 
seem to be the only one either.

I'm so confused!  Thanks for your time in trying to help!
Rita



Andy Pope wrote:
> Hi,
> 
> Which sub-type of line are you using? Stacked lines can not have 
> Trendlines.
> 
> I created a line chart with 2 data series, number and percents. Placing 
> the percents onto the secondary axis.
> When I select either series and right click I can see the Add Trendline 
> option.
> 
> The Trendline dialog, Type tab, allows me to pick which series to base 
> the trendline on.
> Can you see both series in the list, Based on Series: ?
> 
> Cheers
> Andy
> 
0
rmpalazzi (92)
5/7/2008 2:51:18 PM
Hi,

I tested in xl2000 but see the same thing in xl2003.
If you want to email me the file off-line I will take a look,

andy AT andypope DOT info

Cheers
Andy

-- 

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Rita Brasher" <rmpalazzi@fedex.com> wrote in message 
news:eJpGDHFsIHA.2064@TK2MSFTNGP05.phx.gbl...
> Andy,
> I can see both series in the list.  As far as I can tell, they're both 
> just regular lines, not stacked. One may have markers, but still just a 
> regular line.   I have no issue adding a trendline if both axis values are 
> whole numbers.  It's the ones with the percentage on the secondary axis 
> that I am having issues with.  Can you tell me what version of Excel 
> you're using?  Maybe I've missed an update somewhere along the way, but 
> I'm not the only one having this issue and my version doesn't seem to be 
> the only one either.
>
> I'm so confused!  Thanks for your time in trying to help!
> Rita
>
>
>
> Andy Pope wrote:
>> Hi,
>>
>> Which sub-type of line are you using? Stacked lines can not have 
>> Trendlines.
>>
>> I created a line chart with 2 data series, number and percents. Placing 
>> the percents onto the secondary axis.
>> When I select either series and right click I can see the Add Trendline 
>> option.
>>
>> The Trendline dialog, Type tab, allows me to pick which series to base 
>> the trendline on.
>> Can you see both series in the list, Based on Series: ?
>>
>> Cheers
>> Andy
>> 

0
andy9699 (3616)
5/7/2008 3:13:10 PM
Ok Andy,
In all of my frustration, I realized I didn't have labels assigned to my 
secondary axis.  As soon as I assigned the labels, my trendline showed 
up. Sooo I thought I'd figured it out and was showing my coworkers with 
the same issue my fix.  When one girl opened her file, she already had 
both axis labels defined and no second trendline.  When she deleted the 
labels for the secondary axis, not only did her trendline show up, but 
all 5 of them she tried to add were showing.

When I went back to another chart where I had both axis labels and 
deleted my secondary ones, I could add see my trendline.  I don't know 
when these issues started, but I'm wondering now if an automatic update 
somewhere along the way has caused a bug here...

At any rate, I at least have a work-around and will do what I can to 
report it to Microsoft (do they even listen??)

Thanks for taking the time to look into this for me...
Rita



Andy Pope wrote:
> Hi,
> 
> I tested in xl2000 but see the same thing in xl2003.
> If you want to email me the file off-line I will take a look,
> 
> andy AT andypope DOT info
> 
> Cheers
> Andy
> 
0
rmpalazzi (92)
5/7/2008 4:25:49 PM
Reply:

Similar Artilces:

Public store move/ESM management issues
I have moved my Public folder store to another physical drive......everything is working, users can access the folders through outlook. But, when I try and manage the folders through ESM I get an "error ID no: 80040e19 - The object is no longer available." Any thoughts from anyone on this? Thanks, Brad I know the error message isn't idential but try to connect to a different Exchange server. Right-click the Public Folders object in ESM and then click Connect To. See KB 289492 "Brad" <bcraig1971@yahoo.com> wrote in message news:3c0391e3.0408240534.7888f2d9@...

Outlook 2007 Configuration issue
Hi all, Here I have exchange server 2007 in the local configuration its working fine. I have two systems which i have configured with outlook 2007 with POP3 to my exchange server these two systems aslo working fine. these two systems are not at all in domain and the configuration is POP3:mail.domian.com SMTP:mail.domain.com and i checked that option "Leave a copy of message in Server" Now I am going to change those two systems, for that i have taken the backup and i am trying to configure the same account in the new system then its downloading all the mails fr...

Display Name sorting issue
I have a need to sort a bunch of users and groups to the bottom of the Address List in Exchange. I can prefix the Display Name with an underscore to force an item to the top of the list, but what can I do to sort them to the end of the list. there are two situations where I need this. One is schedulable resources (we are using AutoAcceptAgent) which I need to see in the address list, but I want them below all the general users, not above. If I hide them from Exchange Address Lists then they don't show up in the Resources list either. And because they are Users, they show up in the ...

Issue with Publisher 2000 and Kyrocera Printer
Hello, I have an HP printer and a Kyrocera printer. The HP is directly connected to my computer, the Kyrocera (copier/printer) is connected to another machine across the office. I have a mapped printer to the Kyrocera. From Publisher 2000 I can print fine to the HP. With Word and other applications I can print fine to the Kyrocera. When I try to print Publisher 2000 file sto the Kyrocera they often appear in this little tiny block at the end of the page... all the text is huge like it's at the wrong resolution or something and smashed into this little box at the bottom of...

Quick Print issue
We are having an issue when using the Quick Print Setup. In general we have three main sites (which are named X, Y, and Z) with a printer defined for each site (using the Named Printers utility). When printing the pick tickets we specify to print separate picking ticket per site (each site has its own printer). If we do this printing process manually we get each picking ticket in its corresponding printer (per site). To make things easier we decided to use the Quick Print in this process. When using the Quick Print, only the pick ticket associated to the X site is being printed in the X site ...

outbox issue I can't fix
This is the best way I can discribe this problem, sorry I'm a novice. 1.I send an email 2.two identical emails transfer to outbox 3.icons on the left appearence in the outbox shows, one has a envelope (as if it's normal and ready to send)and one has an envelope with a letter(as if it's already been read). 4.email sends, and the envelope one transfers to the sent mail file, the evelope with the icon remains in the outbox file. 5.Note the copy that remains is an opened viewed mail because it is not bold and the icon states it as an enveope with a letter. 6. in order to clear my outbo...

compatibility issues
Version: 2008 Operating System: Mac OS X 10.5 (Leopard) Processor: Intel Word keeps telling me there are compatibility issues with a document and tells me what to change the settings to I did, they're still changed but but it keeps coming up with the same issues? It says it's set to word 6.0/95 settings and to switch to 2000-2004 and X which I did. And it's still set to the 2000-2004 and X, so what's wrong? It's making the spacing between words look too big but their not when I count them out. Like in between sentences there's two spaces but it looks like 3 or 4 space?...

Econnect / XP SP2 / issues
Hello there, We'd been using the econnect client on a computer running Windows XP Pro SP1 for quite sometime with no trouble at all. But ever since the operating system was upgraded to SP2, the econnect stopped working. We think that the Windows XP SP2 firewall might have something to do with this trouble; but even though we turned it off, the error remains. We're using the econnect sending utility to connect to a SQL Server 2000 SP4 server running on Windows 2K SP4 via a DSN. We get the following error: Error number = -2147168246 Error description = New transaction cannot enlist...

CDF migration issues
hello, I am moving from a goldmine CRM to MSCRM. So far things are going good, i have written some perl scripts to read the goldmine Dbase databases and stick em into the cdf database. Everything appears to be be importing just fine into the CDF database, but when i go to migrate the activities using the migration tool, it fails to migrate any activity whose "Description" field contains more than 6 characters. when loading the CDF DB i am moving the "NOTES" field from goldmine and when the notes field is empty i stick in a "<none>" All the record...

Great Plains Integration Issue
Hello, i am an extreme newbie when it comes to great plains, but long story short we payed a company to help us do our integration from another SQL based software to GP. The intergrations don't work and well me being one of the IT guys and SQL guy, my boss has asked me to figure this out. so here is the error i am getting when i run the integration. The query for the source is correc tin preview, and the count is correct. but i get this error for every row in my table. DOC 2 ERROR: Unknown Great Plains field subtype '10016'. this info may help also, but i am not sure.status...

Current Issues Article Archive
A growing archive of fascinating media articles on current issues & affairs. Available at Arcis Foundation Website: www.arcis.co.uk/php/ -- Posted by News Bulk Poster Unregistered version ...

SFO Go Offline Issue
I am trying to go offline and get an error message: "The specified domain does not exist or coulkd not be contacted" Am connected directly to the LAN when trying to go offline I have XPSP2 everything else seems to work ok. any suggestions would be helpful.. -- Jeanne Conde, MCP SynEcology I resolved issue by applying a Hotfix to the CRM server Knowledgebase Article 834859 You must call Microsoft for the hotfix. "SynEcology" wrote: > I am trying to go offline and get an error message: > "The specified domain does not exist or coulkd not be contacted"...

XmlTextWriter and Text.Encoding.UTF8 issues
Hi, I'm an XML newbie, and not sure if this is the appropriate newsgroup to post my question, so feel free to suggest other newgroups where I should post this message if this is the case. I'm having issues using XmlTextWriter, saving it out to a file with UTF8 encoding, and seeing "dirty", or "human unreadable" characters show up *right before* the XML declaration. I need to have the XML declaration state "encoding = utf-8", but also get rid of the dirty characters. I was hoping that using System.Text.Encoding.UTF8 in the constructor of the XmlTextWrite...

Windows Installer Issue....
Hi All, A couple of weeks ago, one of our (under-protected) office PC's was infected by some sort malware or spyware (I wasn't involved in this process). Following it's removal with a new installation of Kaspersky anti-virus, Windows Installer wants to run whenever we launch certain applications. I've gone and shut-off Windows Installer globally by disabling it using the Group Policy Editor, but it(Windows Installer) still flashes up for a couple of seconds before going away. Is it possible to restore whatever was lost during the malware eradication to preven...

Outlook 2003 "OFFLINE" issue.
Hi, Since we upgraded the Exchange 2003 to SP2, some of our users encountered an issue where their Outlook client 2003 were "Offline" by itself. The users need to manually uncheck the "Work Offline" to reconnect the server. As far as i know, if there is a network issue, it should be "Disconnected", I did simulate this by unplug the network cable. Is there any issue with SP2 ? Please help... Thanks. Rgrds, Zul I am having the same problem. At first I thought it was a windows thing with a SID and the domain but now I think it is Outlook and some problem...

Excel Chart Trendlines and percentages of increase or decrease
Does anyone know how to get the exact percentage of the overall trend rate when you trend data via Excel? If you want to know what percentage B1 is of A1, use the formula =B1/A1 and format as percentage. If you are wanting to calculate a different percentage, modify the formula accordingly. -- David Biddulph "no trend wizard" <no trend wizard@discussions.microsoft.com> wrote in message news:29C72517-AEB0-49C8-A19B-49DB21226040@microsoft.com... > Does anyone know how to get the exact percentage of the overall trend rate > when you trend data via Excel? Do you m...

View Crystal reports issues
Hi All, I have just gone through all the necessary steps to rebuild my aps database due to some other issues. This was easy enough and it originally looked as though everything was fixed as I was able to view reports in CRM. However, after clicking a few others, I get some reports complaining like this: CrystalReportViewer updateViewState failed Your request was cancelled. The necessary security privileges could not be verified. Please contact your system administrator And some others complaining like this: CrystalReportViewer Information is needed before this report can be process...

DoCmd.OpenForm issue.
Hello, I have a form that has a drop down box, in the drop down box there are lists of names, if the name you want is not in the list, you double click and it takes you to another form that allows you to input a name and user information. As of now it always opens a new record when double clicked, I am wanting it to work a bit differently, but cant seem to get it right. I want it to do this: If the name you want is not in the list, and blank, when you double click it takes you to a new record (which it does now) but if the name is already there, or it is in the list and selected, it ta...

please help with this issue
I have a workbook with approx. 25-30 worksheets in it with the last being an overview of the others. I use this workbook to track some basketball stats. What I need to do is to: countif cell A9 of sheet 1 thru sheet 30 are populated with a text letter (P for played), the resultant of the countif will be used to divide into an overall sum of points - thus giving an average points per game. Any suggestions Thanks Dudley Hi Dudley if you list the names of your sheets in an area of the summary worksheet (e.g. A1:A30) you can use the following formula =SUMPRODUCT(COUNTIF(INDIRECT("'...

2002 Send/Receive Issue
Greetings all: I am getting an error code: 0x800ccc0d. The message says "Server not found." I, too, was able to send POP3 test messages, and pick them up inOE, but Outlook is not functioning. Right now, it's just occupying drive space :'(. Have you tried outlook /safe from the run line. It sounds like a 3rd party program or a program associated with outlook. "Delwyn X. Campbell" <dxcj4life@hotmail.com> wrote in message news:u51$cqZ%23DHA.220@TK2MSFTNGP09.phx.gbl... > Greetings all: > I am getting an error code: 0x800ccc0d. The message says "...

Address issue: How do you deal with such a scenario in MS CRM?
I have an account A1 A1 has a primary address ADD_1 A1 has a sub account called A2 A2 has a primary address ADD_2 A2 also has multiple addresses in "More Addresses" ADD_3, ADD_4 A2 has a contact C1 that is related to ADD_3 A2 has another contact C2 that is related to ADD_4 Now when I am creating C1, address fields should automatically be populated with ADD_3 details. Similarly when I am creating C2, address fields should automatically be populated with ADD_4 details. Since ADD_3 and ADD_4 are already entered in Account A2 level, users will not type these addresses again while cre...

does CRM support IE7? I have a strange issue...
Hi, I'm admin of the CRM. if I access the users page using a Win 2003 computer with IE6, I can add / edit etc... a user account from my XP station with IE7 Beta 2, I can'T !!!! on the 2 systems I'm authenticated as myself. does it an IE7 issue? or else? thanks. Jerome. Curious I'm using IE7 Beta 2 with no problems at all. Make sure that Outlook is not open (it will knock out Settings area in CRM) and try clearing cookies in case that's a problem but got 4 people here currently using IE7 without this problem Roger "J�j�" <willgart_A_@hotmail_A_.com...

Is there a stability issue when working with graphs?
Every time I copy a graph from Excel into PowerPoint 2007 then try to format the graph, PowerPoint freezes up. For kicks I waited over an hour to no avail. This problem also occurs when I choose to build the graph within PowerPoint. Does anyone know why this is happening and if there is a solution? Thx Start by making sure you have SP2 installed...and then install this hotfix: http://blogs.technet.com/arykhus/ -- Echo [MS PPT MVP] http://www.echosvoice.com What's new in PPT 2007? http://www.echosvoice.com/2007.htm Fixing PowerPoint Annoyances http://tinyurl.com/36g...

Excel-Remote Desktop Issue
Does anyone know what is causing Remote Desktop to do this to my Local machine's Excel 2007? http://img243.imageshack.us/my.php?image=officeproblemfk9.jpg The problem only occurs with Office 2007 products (Excel most frequently, but I use it the most as well). It occurs 1. upon closing a remote desktop window 2. when a RD is up for a while 3. when I have to come back from "sleep mode" in either the server or the local machine It does not occur with 100% incidence, but very frequently (every day). The problems seem to occur more frequently when I have multiple inst...

Links Issue ?
Can anyone explain why what I see happening, described below, is occurring. I have a weekly report submitted to me by Email. The structure of each these weekly submission is identical as it made from a template file. The users insert links into the template which brings in figures. I do not have access to these linked files. When I open the Emailed version I choose not to update links and the data is fine and correct, and I see the link paths in the cells. The problem which requires explanation - If I open up last weeks Emailed version of the file at the same time as this weeks, rather than ...