3-D Graphs Issue

Hi, everyone. I was wondering if there is a way to 
minimize the distance between the left wall and the 
vertical Y-axis in an Excel 3-D graph. It looks like the 
options are quiet limited. I'm on Excel 2000. Any ideas?

Thank you in advance and have a great week-end.
0
anonymous (74722)
5/14/2004 9:13:18 PM
excel.charting 18370 articles. 0 followers. Follow

1 Replies
645 Views

Similar Articles

[PageSpeed] 41

Anya, not sure if this is what you want, but here goes:

Right-click the walls and select 3-D View from the shortcut menu. Use the
arrow buttons to adjust the elevation and rotation. Or enter values in the
Elevation and Rotation fields. The wireframe will give you an idea of the
result.

-- 
DDM
"DDM's Microsoft Office Tips and Tricks"
Visit us at www.ddmcomputing.com


"Anya" <anonymous@discussions.microsoft.com> wrote in message
news:d4ed01c439f8$4770bd60$a501280a@phx.gbl...
> Hi, everyone. I was wondering if there is a way to
> minimize the distance between the left wall and the
> vertical Y-axis in an Excel 3-D graph. It looks like the
> options are quiet limited. I'm on Excel 2000. Any ideas?
>
> Thank you in advance and have a great week-end.


0
DDMara (266)
5/15/2004 2:40:44 PM
Reply:

Similar Artilces:

#REF #3
Hi, I'm doing a projection spreadsheet. The new months in diff sheets will be added as and when the actual month passes, ie, up to now i have sheets up to Aug. But in the MAIN sheet, I'm supposed to have months for the whole year up to Dec. Since Sep to Dec don't have equivalent sheets yet, the cells show #Ref since my formula is =Oct!A1. I want to tell the cell to get the amount from "Oct" sheet if there's such a sheet and if not, get the amount from "Sep" sheet. I tried this "=if(Oct!A1="#REF", Sep!A1,Oct!A1)" but it doesn'...

Office XP Exel
Scenario: User's A,B, C, and D all have access to an excel XLS on a 2003 server. Users A & B have modify rights, users C&D only have read rights. If user A updates the file, the general tab in properties reflect the exact time the file was modified. After user A saves and closes the file, user D goes in. The changes are there, but in the properties general tab, the modify date in an old date (probably the actual creation date). Is this normal ? Any idea's ? ...

Excel template issues
I have a user that has a excel template on his network home dir NW 5.1 Server he says that after he creates a new file from that template - he goes to open and it tells him read only access running Excel 2000 thanks ...

Public folder issue, "messaging interface has returned an unknown error"
I'm running a SBS2003 domain and just added a public folder and a customized form for entry into the public folder. All of our clients (all XP Pro, Outlook 2003 with all updates) can get to that folder and use the form without any difficulty except for one. On one computer I get the classic "The messaging interface has returned an unknown error. If the problem persists, restart Outlook." error message. I have tried a repair install, no change. I have tried making a new profile, no change. I have tried adding / removing his PST file (currently he's not even using a pst file...

Terminal Servers in Cluster - Login/Profile Issues
Hello Gurus, Currently I am having an issue with logins and profiles as per details below. Server/Network Configuration Details: 1 X Windows Server 2008 Std FE 64bit (DC) 2 X Windows Server 2008 Ent 32bit Terminal Servers User Profiles are Roaming and exist in: \\SBSERVER\Profiles on the Domain Controller and C:\Users\ on the Terminal Servers. Approx 50 users. Problem Description Error messages when logging in the terminal servers: Your roaming profile is not synchronized correctly with the server. Windows will load your previously-saved local profile instead. See the pre...

Issue with Loan Accounts
Hi Everyone, I have been having this issue for a while - but just now trying to figure out what's happening. I have several loans (including car, equity, etc.) which I have set up on Money 7. Sometimes the interest and principle are calculated correctly - but more often, the entire sum of the payment is allocated to principle (as viewed in the account register). I've check to insure that the loan is set up okay - and it looks okay to me. Any ideas what's happening to me? Any help appreciated. Thanks. Patrick Hi, I was really hoping someone would respond to this. My ...

time formats #3
I have an Excel sheet with a long list of times spent on various projects. The times should all be in minutes and seconds. The first time reads 2:29 and I know that is accurate, for 2 min, 29 seconds. In the formula bar, it reads, 2:29:00 AM. Another...the cell displays 0:40 and I know that is right, for 40 seconds. But in the formula bar, I see 12:40:00 AM I want numbers, but apparently I am looking at times. I tried changing the format. When I check the format for 2:29, it comes up Custom and says it is hh:mm, not mm:ss. I tried changing it to mm:ss, but that changes the displa...

Multiple Language Issues
Hi all, Has anyone successfully manually updated a non-English supported 5.5 to 2003? (The reason for the manual update was a broken admin account.) Mail and contacts were all exported to PST files, and then imported to 2003. However, although the text of the messages is fine (English and Russian), the text for contact names and message subjects gets gorched if they contained any Russian text. Does anyone know the correct sequence to follow to take messages and contacts in Russian (or other languages) from 5.5 to 2003, while retaining the non-English subject lines and contact names? ...

New Computer #3
How do I move my settings, emails, address book, etc... to my new computer. I'm mostly concerned with Outlook because it's the program I use most often. I have an older computer running WIN2K Pro. I purchased a new Dell computer with Windows XP Pro also with Office 2003. Again how do I make my new Outlook have all the information and settings that my old computer has. I do have both computers connected on my home network and they can see each other. But I'm not sure what to copy over. Any help would be very helpful. Thank You, Paul The file you need to copy and re-use up ...

CRM 3.0
Folks Any way that we can assign leads / opportunities / other entities to teams rather than individuals? All the best Hany Hi Hany, Team ownership is not supported in CRM 3.0. Could you describe your scenario, and maybe we could provide some alternatives? Thanks -- Jay Grewal Microsoft Dynamics CRM This posting is provided "AS IS" with no warranties and confers no rights. "Electronic Workplace" <info@electronicworkplace.LoseThisBit.com> wrote in message news:O0cfzAT$FHA.140@TK2MSFTNGP12.phx.gbl... > Folks > > Any way that we can assign leads /...

Importing #3
I had a previous version of Money and just got a new computer with Money 2004. I have a backup disk made with the info from the previous version. How can I import that into the new version? File|Restore?!? <anonymous@discussions.microsoft.com> wrote in message news:075a01c3d169$a360b0a0$a001280a@phx.gbl... > I had a previous version of Money and just got a new > computer with Money 2004. I have a backup disk made with > the info from the previous version. How can I import that > into the new version? ...

Debt Reduction Planner #3
The debt reduction planner on my version of Money 01 does not take the minimum payment due into account. It expects me to short some accounts to make bigger payments to other accounts. Obviously that is not feasable, as the late charges for not making the minimum payment would negate any possible savings. Is there a way to fix this so at least the minimum payment is listed? ...

Converting from Lotus 1, 2, 3 docs
I have a user who has a bunch of Lotus 1, 2, 3 spreadsheets that he is trying to convert to Excel. His version of Lotus is old (version 5), his version of Excel is 2000 sp2. The files convert but they are missing pages or headings or other unacceptable qualities. Anyone any advice? Michael If you open the files using Excel and save them to an .xls format in the current version you are losing data? A while back I needed to do this. I wrote an application in VB that loops through the files, opens them using Excel (add a reference in VB to MS Office 10) and then save them in the current ...

Calculating dates #3
Can anyone tell me what I should use (in the way of helper cells) to take any date (mm/dd/yyyy) and turn it into that same month and day for specific year? For instance, turn... 10/12/2009 into 10/12/2010 and 4/6/1998 into 4/6/2010 I'm trying to determine anniversary date based on start date and do it starting in 2010. TIA -- Jordon Try this: =3DDATE(2010,MONTH(A1),DAY(A1)) Assuming your date is in A1. Hope this helps. Pete On Jan 5, 5:35=A0pm, Jordon <jordon@REMOVE~THISmyrealbox.com> wrote: > Can anyone tell me what I should use (in the way of helper cells) > to tak...

Money 2005 Password Issue
I have been using Money 2005 for about 8 months and suddenly I cannot sign in using my usual hotmail.com passport. The error message is "the e-mail address or password is incorrect". However, I can sign in using the same e-mail address/password pair to hotmail and MSN Money in IE. I've tried KB Q331123 but no luck. Any ideas? More details: 1) I can get into my Money file in offline mode 2) I even tried to change passport password. The new password works in IE, but not Money. "MM" wrote: > I have been using Money 2005 for about 8 months and suddenly I cannot...

Cell References #3
I have 2 separate work sheets. I want to copy the values of cells in work sheet A to cells in Work sheet B. The values in A are separated by at least 4 rows. Cells in B where I want those values are separated by 1 row. How can I copy the values without having to enter each cell reference indivudually in B? Is there a formula to add columns or rows such as cell A1+3 = cell D1 or cell A1 + 3 = cell A4 gman Wrote: > I have 2 separate work sheets. I want to copy the values of cells i > work > sheet A to cells in Work sheet B. The values in A are separated by a > least > 4...

Sent faxes in CRM 3 doesn't show in history
I am reposting this as I've had no answers to my previous post which is now buried in all the other ananswered posts. Surely someone knows the answer to this??? It's pretty fundamental to what customers will want. Anyone??? ------------------------------------------------------------------- I'm using CRM 3 under SBS 2003. When I send a fax using the "New activity / Fax" option within a contact record it sends successfully. . However there is no record of it stored in the contact history? If I check the fax console on the server the fax has been sent (also verifi...

Graph question #2
Hi Folks, Quick query with regards to how data is read by a graph. I have a sheet featuring the number of staff assigned to the call centre at 1/2 hour points throughout the day. This data is stored in a sheet called 'Data' and in cells D17, E17, F17 etc etc. The data within this page is not very well presented as it is run automatically from the system we use here so I have made a more presentable table and graph. For the table for each 1/2 i simply reference the cell in the data page so that all i have to do to update the sheet week by week is paste fresh data in. Using =Data!D17 t...

Native Resolution Issue
I have 298 laptops my section supports and recently we started running into issues with higher native resolutions. Some of our users don't like the higher resolutions because it makes everything too small, so we adjust them to lower reslutions, but the settings revert back to the native resolution whenever the laptops go to sleep, get removed from the dock or if someone else logs onto them. We use HP and Dell laptops with various models. Is there one setting in Windows XP Pro SP3 where we can "turn off" native resolution? Thanks for any help -- J Wilson ...

Issue opening documents in MSOffice 2003
Hello I wonder if anyone can answer my question? I have a new laptop running Windows 7 Pro with Office 2003 and I notice that when I seek to open an Excel or Word file with a .doc, .docx, .xls or .xlsx extension, that Excel or Word opens the file but also an empty window of opens at the same time, e.g. I have two windows of Excel open, one with the document I want and the other is empty. Is this a default action for any reason or a bug? This is more of an anomaly than a major issue but I am curious? Any advice would be welcomed. Thanks Martin O'Shea. "...

Outlook Express address Book #3
My address book is no longer visible. How do I correct the problem. This is a group to support Outlook from the Office group of programs. Outlook Express is a part of Internet Explorer and is a quite different program despite its similar name.. You will probably get a faster and more expert answer if you post this to an outlook express news group. Try posting in one of these newsgroups: microsoft.public.windows.inetexplorer.ie5.outlookexpress for OE 5.x microsoft.public.windows.inetexplorer.ie55.outlookexpress for OE 5.5x microsoft.public.windows.inetexplorer.ie6_outlookexpress for OE 6.x ...

Analytical Accounting Error #3
Hi, I am getting the error 'This record has been created since your attempt to create. Changes will not be saved'. This I am getting while I am trying to add additional transaction dimension. Any idea? Ramesh ...

IF statement with FALSE value being text AND cell reference? #3
Once again, figured it out on my own. Oh, and thanks for the repl Frank. Needed to use the ROUND function: =IF(D9>1,D9*D8,"<" & ROUND((D9*D10),2) -- jcob ----------------------------------------------------------------------- jcob2's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=1560 View this thread: http://www.excelforum.com/showthread.php?threadid=27157 ...

Strange ADC issue
This problem is really strange. Here is the background. We have a 2003 AD and several Exchange 2003 SP1 in this AD forest. These 2003 servers are all part of 5.5 sites. We have an Exchange 5.5 server that is located overseas in it's own 2000 AD forest. The connector is setup to create disabled accounts in our 2003 AD when a new user is created in the 2000 AD. We had a user in our domain that transferred to the overseas location and instead of deleting his account in our domain, we hid it and then renamed it to the replacement credentials. The 2000 domain admin overseas created a new...

2007 RDP issue
I RDP to my home PC that has Money 2007 and it keeps redrawing the screen and wont start. This was annoying in 2005 but eventually it would calm down and you could use it, but now you cant Just need a simple start screen or way to bypass etc. Michael, I use Remote Desktop with Money 2007 Premium across my LAN It works flawlessly. Are you using it across the internet? Are you using the new version of RDP? I think it's version 6.0.6 -Kevin "Michael" <Michael@discussions.microsoft.com> wrote in message news:5FCC33A9-BB7A-4FE6-9545-0ACF1866DEFB@microsoft.com... >I RDP ...