Reply:

Pasting excel chart into powerpoint
Office 2003. When I paste an excel chart into powerpoint, it's not pasting proportionally. I've added text boxes to the chart (in Excel). Also, the original chart is a full page in Excel, however when I paste it into Powerpoint, it's being reduced in size. when I enlarge it, the text boxes (that I added) then overlap one another in powerpoint, where they didn't do this in Excel. I just switched from '97 to 2003 and this wasn't a problem. Perhaps I'll also post this to the powerpoint newsgroup, in case the problem is there instead of excel. I have so...

How do I automatiicaly redefinie Source data range for a chart?
I have A Chart Defined by Category (X) values in Collumn B and Y values in Collumn C. Right now Both are defined by rows 4 to 114. I would like to be able to have the chart automatically redefine itself so if I put a value in C115 the chart would automaticaly set Y value range to be C4:C115 eithout having to manually define chart. Is this possible? If so how? I've tried OFFSET bu so far no luck. Hi, If you turn your data cells into a List, or Table in xl2007, the chart will auto expand. The named range approach will work if you set up the names correctly. See here for more info...

Pivot Table not pulling all fields or data
Hi All........ Without getting too verbose, I have a 900 row by 26 column database I am applying a Pivot Table to. The code seems to run fine, but it is not returning some of the fields, and of course the related data. I have tried reformatting the entire columns I am pulling from but no joy......however, when I reformat an errant cell from General to TEXT, that row comes in........and/or, if I change the value in one of the missing cells, it will bring that row in. The code runs fine, and was mostly derived by recording a macro in XL2k, but the data cannot be trusted becau...

importing into register
I have successfully downloaded files from my bank into my checking account register. I have one account that that downloads my account info into a separate checking account, not the one I intend. I save the file then tried to import and it still imports into the other file. Bank support told me that the download may be matched to the other account and to turn it off, then re-point it to the correct account. I do not know how to do this. I even closed the incorrect account and did the import and it still imported into this account. Any suggestions are appreciated. You'll...

Exchange data backup
I'm worried emails backup of the small office. Does SBS2008 Exchange server has a direct backup capability of whole mail database? How to backup every night Emails from server to external harddisk? Does Exchange server needs to be stopped before backup? Thanks SBS2008 Takes care of it. http://blogs.technet.com/sbs/archive/2008/11/03/introducing-sbs-2008-backup.aspx look at the comments section Russ -- Russell Grover - SBITS.Biz [SBS-MVP] MCP, MCPS, MCNPS, SBSC Microsoft Certified Small Business Specialist 24hr SBS Remote Support - www.SBITS.Biz Question or Seco...

Data Save error
GP Ver 6.0. Recently I am facing an error with normal users unable to save records, where as the system administrator is able to save the same information. Please advice on this error, what has to be done. I have disabled the windows user ID of the Database owner. Thinking of this made Dynasa as the DBO. Database is having enough free space available. Hi How big is the company database? Is it over 10GB? Regards James "Matthews" <Matthews@discussions.microsoft.com> wrote in message news:3FF3F553-5B18-4D8A-B65E-8A253BF94BB2@microsoft.com... > GP Ver 6.0. Recently I...

Problem importing dll
Hi I have an application that used some external com dlls. So in my application code i've imported those dlls as #import "path of external.dll" and i'm using smart pointers to instantiate those coms as IExternaPtr Obj("External.Interface1"); The problem i'm facing that those external com dlls are not mine so every time they are modified by thier owner i've to recompile my code too with the latest dlls otherwise my code does not work and i get Obj = NULL in the above statement. Actually those external dlls are of a software that i've provided integratio...

Salesperson reports.
Hello. Is there any way to find any reports for salespersons? (not standart one) For example I need: Quotes for last week, Orders for last week, Invoices for last week. Invoices for last year and so on? Any suggestions are very welcome. Thanks. Vitali How about SmartList? "Vitali V" <vitvov@dynamo-ny.com> wrote in message news:u%23HBC8yyEHA.748@TK2MSFTNGP14.phx.gbl... Hello. Is there any way to find any reports for salespersons? (not standart one) For example I need: Quotes for last week, Orders for last week, Invoices for last week. Invoices for last year and so on...

better reporting system?
HI this is a very gereric question. I am working on excel for last couple of months. I am automating reports for my finance user. THe process being followed doesnt seem intelligent to me. I want to take experts opinion ... I will expalin the whole senario. The data I am using comes from IT department to our department. The data originally stored is in oracle. AND to us it comes in excel format where some massaging is done with the data per requirement. Infact our departmetn also uses data from other departmetns say planning,etc. Finally the data comes from the IT deaprt only. Since...

Short Crystal Reports Question
Hi all, How do I display a running total in a subreport in the parent report in Crystal Reports for CRM 1.2? Thanks all Tom You need to do code to do this. You can declare what are in effect global variables in the main report and track the running total in those variables. Becuase they are global the sub report should be able to access them as well. you may also be able to pass the contents of the running total variable directly into the sub report as a parameter as well This book may help you get started. Its the only book I have used for crystal in crm http://www.amazon.com/gp/p...

Click on Project number to generate report
I have a report "rptProjects" that I want run and filtered to show the details of just one project based on the project number clicked on in a summary form (continous form). The target report is linked directly to the data table and contains subreports linked to their respective data tables. I can get the Projects form to open to the specific record fine using the DoCmd.Openform, but DoCmd.Openreport does not work. I have placed the projects' PKeys on both the summary form and within the report and am using these in my code e.g REPORTID = Me!ReportID. Can anyone help wit...

drawing excel like grids on access reports
Hi All, I want to draw excel like grids on my access reports. The line should start from the top of each label in the page footer to the bottom of the corresponding text box in the page footer.(For each text box in the detail section, there's one unbound text box in the page footer to display totals). I don't know how to do this. can anyone please help me? -- from chanakya Baruva Can't you use rectangle or line controls in your various sections? These should work unless your sections are set to Can Grow. If this is the case, you may need to use the Line method ...

The Afternoon Newspaper : Daily Market Report for: Thursday (October 22, 2009)
NSE India : S&P CNX Nifty The Afternoon Newspaper : Daily Market Report for: Thursday (October 22, 2009) (Based on the activity of the previous trading day) By Dominic Rebello Review of the Previous day: The Nifty fell substantially on Wednesday (October 21, 2009) a net 50.85 points (0.99%) and closed at 5063 point level. The market opened down then turned up and continued so until 09:58 a.m. when it reached its day high at 5117 points. It then fell and turned into a range bound movement until closing near the day low. The market moved in a range of 66 points. Heavy selling was witnes...

cell range not changing when refreshing linked data- sumproduct fo
The cell range is not updating correctly to reflect the last row in the data sheet that is being refreshed. 5878 is the correct number of rows and 5824 is not. I can find and replace in my formulas to correct the problem, but it does it each time the data is refreshed. Any suggestions as to why? =(SUMPRODUCT((Expense!$B$2:$B$5878=$C$2)*(Expense!$C$2:$C$5878=$C$3)*(Expense!$W$2:$W$5824=$A6)*(Expense!$M$2:$M$5878))) I gave you the INDIRECT option y'day, but received no feedback from you in that thread. Looks like you're more interested in knowing why? One simple hunc...

column totals on stacked column chart
Hi. Is there a good way to get the column totals on a stacked column chart to appear above the columns? All I have gotten so far is the individual pieces of the column to show their values inside of the column, but the user wants the column total, above the column. Thanks. Mark Hi, Assuming your chart is a 2d stacked column you could use dummy data series plotted on the secondary axis to display the total. Create yourself a helper column on your worksheet that sums the values of each column. Add this to the chart. At first it will be an extra portion on each stack. Select the serie...

Data vs. forms & Unload/reload questions
A .mdb file seems to encompass both the database and all the 'code' (forms, modules, and logic) used to CRUD the data in the tables. 1) Is there any way to separate the database from the code into separate files, eg. the db is mydata.mdb and the 'code is in a separate file, eg. code.mdb? 2) Say you have v1.0 of an app and the tables and attributes are populated with data. You then go and build v2.0 of the app, adding tables and columns to what already existed in v1.0, and perhaps moving some of the v1.0 attributes into different tables. What is the recommended way to unload/reloa...

Projectwise Resource Engaged & Availability report
Hi, I am new to MSP & MSPWA. We generally use MSP & PWA to manage our projects. Now we require a report that shows status (Allocated and Available) of all active resources on a particular day or daywise. Is there any existing report for it or how can it be developed? Please help me out. Hi, a tip for your next question: to get answers for project server questions, it is better to ask in microsoft.public.project.server. There are several methods to see what you want to see. Depends if you want to have a graphical overview, on the number of your active resources, .... ...

Set color for chart serie in excel 2007/2010
Hi! I want to do a macro that sets the color for the chart series to the color the company has desided to use. We have a theme but we can only set color for the first 6 series and we often use much more series. I have understod that this isnt so easy as to loop thru the series and set the color since the color is set on different ways depending on the charttype for the serie, or is it a way to do this so it works for all chart types? thanks As you say only six basic colours are available. However each subsequent set of six is a shade lighter, although each incremental differe...

Data Format: how can I re-format
The spreadsheet that was exported for me to use has the information in paragraph form: It is customer ID name and billing info but it is like a long series of address labels. I want to be able to have them listed under captions like company name, contact, address, city, etc.. so I can use the data. There is an empty row between each entry. Each entry is 3 or 4 rows. There are about 500 records so i dont want to manually set them up. Thanks Try tinkering around with these steps Assuming your list is in col A, data in A2 down (If data starts in A1 down, insert a new row for the co...

Excel charts into powerpoint
Is there some simple code that I can use to get a group of excel charts into an existing powerpoint presentation? ...

Custom Type Charts Problem
I am using Custom Type Charts in Excel, which uses Pivot Table as the Data Source. The problem that I am facing here is that whenever I Refresh the data using the Refresh icon, the Custom Type charts LOOSE their formatting. To make my problem clearer, I am attaching a sample Excel sheet herewith. In the sample file, go to 3rd sheet "Custom Type Chart" and have a look at the "Tubes" chart. Now click on the "!" Icon (this is the Refresh icon). The formatting of the chart changes. Try this out with the "Normal Chart". The formatting remains the same. ...

Display comments as data #2
thanks a lot , this worked exactly as required, the comment go converted to data Now just one more thing . is the vice versa possible i.e if i have dat in column A can it be shown as comment in column B. the reason i need this is bcos i am shifting some data with thei comments to MS access(Hence the need to convert omments to data) processing them and again converting them to excel (the need to conver data back to comments -- sonik ----------------------------------------------------------------------- sonika's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=...

Chart turns gray.. can anyone help
Hi, I am working with a large file.. but not as big as others. This one has a few charts. When I add another it starts acting weird... turning totally gray unless I click on it...? its it the fact that its not embedded or not in front or in back of the worksheet? Thanks for any helpful ideas on correcting this. Go to Options on the Tools menu, click on the View tab, and under Objects, select View All. - Jon ------- Jon Peltier, Microsoft Excel MVP Peltier Technical Services http://PeltierTech.com/Excel/Charts/ _______ Steve Kay wrote: > Hi, I am working with a large file.. but ...

Count invalid data entries
I am using the following macro to identify invalid data entries in cells with data validation applied. Sub CheckOrder() ' Application.CommandBars("Formula Auditing").Visible = True ActiveSheet.CircleInvalid Sheets("Configuration").CircleInvalid Sheets("Parts_TakeOff").CircleInvalid MsgBox ("Check for Red Circled Invalid Data Entries on" & Chr(10) & " Configuration and Parts_TakeOff Sheets") End Sub Is there a way to count the number of invalid data entries (red circles) and write the number to a particular ce...

User defined series in chart
Hello, I need to create a chart, whose X axis follows the following series from lowest to highest (1,2,3,4-,4,4+,5-,5,5+). These numbers basically represent a ratings system, with 1 being the worst rating and 5+ being the best rating. I have the data populated in excel, I just don't know how to graph it. Thanks, Paul Put the series in a column as text; these will be the category (x-) values In the next column; enter the y-values Make a LINE chart best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email <prayesm@gmail.com> wrot...