Less points in graph

TheMSsForum.com: The Microsoft Software Forum

The MSS Forum ‹ Excel
- Archive
  - Biz
  - MCSE
  - CRM
  - Drivers
  - Framework
  - ADO
  - ASP
  - Compact
  - Forms
  - Dotnet
  - C#
  - VB
  - FontpageGen
  - Excel
  - WorkSheet
  - Exchange
  - Setup
  - Fox
  - Fontpage
  - ASP
  - IIS
  - Entourage
  - Money
  - Messanger
  - PocketPC
  - Powerpoint
  - Project
  - Publisher
  - Excel
  - VB
  - Security
  - Portal
  - Services
  - SQLServerDev
  - SVCS
  - SQLServer
  - VB
  - VC
  - MFC
  - ExcelGen

- Previous
  - 1
    - Excel 2007 - files open slowly Having a strange issue with Excel 2007. When I open an Excel file (.xlsx or .xls) by double-clicking the file it takes forever to open (about 60 seconds). If I have an instance of the Excel application open already, then double-click the file, it opens right away. The problem only seems to occur if the application is not already running. The other weird thing is that when it does take a long time to open, the application does not appear to be "hung". In other words, when I double-click on the file, the Excel application opens right away, but I have to wait for about a minute before the actual worksheet appears. In the meantime, the application itself seems responsive. I can click on the menus, etc without any problem. Anyone else experienced this problem? Tag: Less points in graph Tag: 110889
  - 2
    - How to add and remove spredsheets hi all I need help how do i add or remove spredsheets from excel workbook with visualbasic 6. thanks Tag: Less points in graph Tag: 110888
  - 3
    - Data validation listbox still not working after troubleshooting Hi All, The list box in each cell in ranges I've named are not working--only the top cell or record in the list box can be used for some reason. The list box, when clicked, does not even show the top value--just a blank field. Does anyone know why this would happen? It does not appear to be associated with: XP, corrupt wkbook, frames or window split, etc. I've searched this site and cannot find an answer. This boggles my mind... Thanks, Arnold Tag: Less points in graph Tag: 110882
  - 4
    - URL forwarding in Excel? Hello - might I ask for the assembled wisdom of the group. I have an Excel spreadsheet that automaticaly opens www.mywebspace.com/data.csv in Excel when I open the spreadsheet. I want to send this spreadsheet out to others, and then from time to time change the destination away from www.myspace.com simply by altering the file on my server to forward to data.csv at another location and open that fiile instead. I won't be able to change the spreadsheet itself once it's been distributed. In other words I want to do a URL redirect using Excel. How do I alter my spreadsheet to make this possible? If anyone know the answer I'd be most grateful. I'm using Office 2003 Best T Tag: Less points in graph Tag: 110881
  - 5
    - Combo Box Input Range - Variable I'm using 2000 and have a sheet where 2 selections have to be made. Selection 1 is in a Forms menu Combo box with 5 choices and works great. Selection 2 I would like to be a Forms menu Combo box, with the selection list changing for each choice in box #1. How can I code the 2nd combo box's input range so it changes based on the selection in box #1? I tried an If statement to parse the 1st box's choice, then display either the range or range name. But I couldn't get this result to be used the 2nd box's Input Range. I'm rather limited in VB skill I guess. :( Any help is appreciated. Alex Tag: Less points in graph Tag: 110878
  - 6
    - Conditional formatting does not work with MATCH / VLOOKUP I do have two sheets and use conditional formatting. One sheet works fine. When I get a value on that sheet the other sheet with MATCH and VLOOKUP, and use the same conditional formatting on that sheet, CF does not work at all. Bart Excel 2003 Tag: Less points in graph Tag: 110876
  - 7
    - how to compare two excel files i would like to know how to compare two excel files. is there any tool for that? in addtion is there any way to maintain several versions of the same file with easy way to have diff between them? thanks, -- Miri Tz. Tag: Less points in graph Tag: 110868
  - 8
    - Loan Calculation Can I get some help with some loan calculation formula? I need to calculate payments based on 360/365/366/365.25 days in a year. That's one part. The other is, I also need to figure accurate payments if the days to first payment from date of contract is not the standard 30, say it is 1, 3, 10, 45, 60, 90, 100 etc, any number that the user can opt. How do I do this? Also I see some about last payment being different from the regular payments. WHat does that mean? Thanks Frank Tag: Less points in graph Tag: 110865
  - 9
    - PROTECTING FORMULAS I have a sheet where when opened, it runs an auto macro to move cell contents from one column to another and uses a formula to do some calculations. If I select the columns I want unlocked, then protect the sheet and try to run the macro, I get an "run time error 1004 unable to set the numberformat property of the range class" When I debug the following is highlightd "Selection.NumberFormat = ";;;" " I was a Lotus user and in Lotus I could select a range of cells or columns to protect, I'm having a hard time to get Excel to do the same. I appreciate the help. Danny Tag: Less points in graph Tag: 110864
  - 10
    - Pls help Hi all, Ok, this is kinda difficult to explain but i will try to. I have a workbook with 7 sheets inside. Each sheet accounts for one big category for example Air, Noise, Pollution. Take the "Noise" active sheet for example, it has a Row named Procedure/Training in which i want to enable users to input info. This info is DocumentType and DocumentName in which i present in in this format DocumentType:DocumentName. Now my questions are as below: 1) how can i make it loop? I mean in just one cell users might need to input in more than 1 document type n document name(in pairs of course). How do i achieve this? 3) I have created a button in that cell that when the users click on it, it displays the user form. The problem is do i need to create separate buttons for each cell. This is gonna be very tedious as there are way too many cells (more than 50) and if i were to code for each n every button i cannot complete the project by next year. Please help. I know thats a lot of request in here but someone pls try to help...i need this project completed by end of this year and this portion i mentioned here is just one there are many more sections to be completed. Many thanks in advance. Kev. Tag: Less points in graph Tag: 110862
  - 11
    - Compare/Validate and add new data Friends, I am new to VBA. I need a help in the following : I have 2 spreadsheets : A) Workbook A : C1, C2, C3, C4, C5 R1 R2 R3 R4 R5 B) Workbook B C1, C3, C5 R1 R2 R3 Note the following : 1. Workbook A has more columns and rows (new rows). 2. Both workbooks will have data My Requirement: I want to update Workbook B with following requirements: 1) Look for all existing rows and columns of Workbook B in Workbook A and then update Workbook B with latest values for those already existing and then add new rows with only required columns (C1, C3 & C5) of new rows. 2) I also would like to capture the changes made to existing rows. My advance thanks to those who will help me on this. Tag: Less points in graph Tag: 110853
  - 12
    - outputting real values with dot instead of comma Hi there. I am trying to write real values to a file, but excel always uses a comma instead of a dot as delimiter. Example: -- Dim outfile As String outfile="test.txt" Open outfile For Output As #1 print #1, 5/2 print #1, 7/5 close #1 -- test.txt contains: -- 2,5 1,4 -- I would like test.txt to contain: -- 2.5 1.4 -- How can I tell excel to use dots instead of commas? Thx in advance... Tag: Less points in graph Tag: 110851
  - 13
    - calculating the sum of a range Hi. I am trying to calculate the sum of a range. In a sheet I'd just select some cell and type "=SUM(a3:a15)". But I am trying to do this in a makro and its crucial that I do not manipulate the sheet. So I need to call a function - that is available from within a cell - from outside a cell. I am looking for something like: -- dim a as double a = range(a3,a15).sum -- or -- a = calculate_excel_function("=SUM(a3:a15)") -- thanks in advance Tag: Less points in graph Tag: 110850
  - 14
    - Hiding Page Number in "Page Break Preview" Hi all, When I view my worksheet in the "Page Break Preview", I can see the Page Number shown on the worksheet as watermark. Eventhough it doesn't print, it is quite annoyance to be in the center of the screen. Is there any way I can get rid of it ...? Thanks. Zainuddin Z Tag: Less points in graph Tag: 110843
  - 15
    - refernce to a different work sheet In one of the worksheets in my xls file, I have this formula: =IF(ISERROR(VLOOKUP($A2,$K$1:$M$31,2,0)),"",VLOOKUP($A2,$K$1:$M$31,2,0)) in columns B and C The lookup table is in (on) the same worksheet. But I'd like to move the table to another worksheet in the .xls file. If I do that, how must I change the formula? The table I am referencing is K1 - M31. Tag: Less points in graph Tag: 110824
  - 16
    - A Drop down menu that eliminates selections Hello, I've been reading lots of posts and groups. And I can't find one describing how to do what i want. I have a list of options. Apple, orange, grapes. And i want to place one item in each cell in a column. I also want to eliminate the option as they are placed so that once orange is placed in a square, it cannot be placed in the next square. A person wrote about doing this on accident by a data validation source that was "=F41-F45" and this eliminated options as they were selected. I tried this, but when i go to say "ok" on the data validation box, it says "The list source must be a delimited text, or a reference to a single row or column. Both my boxes to apply it to and my source are a single column. I have MS Excel 2000 SP3. I guess that may behaving an effect since the person i read about typed in that formula and it worked... Thank you, , Mark Tag: Less points in graph Tag: 110822
  - 17
    - LOCK IN FORMULA How can I delete data without deleting the formula? Tag: Less points in graph Tag: 110817
  - 18
    - Parsing Names in Excel I have a list in Excel from A1:A100 with names like the ones mentioned below: Michelle Fooo (michelfoo@exchange.SASMOM.com) Myhaass Smith (mysmith@exchange.SASMOM.com) I want to parse them using string functions to the following format michelfoo@SASMOM.com mysmith@SASMOM.com Any ideas how to do this using a formula? Thanks in advance Michael Tag: Less points in graph Tag: 110809
  - 19
    - Random & refresh Is it possible to lock some cells so that they do not refresh? I am using Randbetween to generate a starting order for a race. and use other formulas to advance the winners to the next bracket. I need to lock out the starting order so that it does not refresh as the winners advance. Any thoughts or suggestions are welcome. Thanks! xjvs Tag: Less points in graph Tag: 110801
  - 20
    - How can I execute a macro right after the user clicks the validation drop down? I have an Excel worksheet and in $D$1 it has a validation rule (in cell drop down) that reads allowed values from A1:A3. What I want is when the user clicks on the drop-down in A1 I want to execute some basic macro. Is their a dropdown click event where I can capture it so before the user does anything else I can call my macro? Thanks in advance Michael Tag: Less points in graph Tag: 110800
  - 21
    - identify "likely a maximum" point Hi math guys/gals, I have an "oscillator", points go up and down, (amplitud or frquency not constants) and need to identify if the newest point is probably a maximun or a minimun of such a function. I say probably, because it doesn't need to be perfect, but in hindsight you can see that your solution got close to identify most of the max/min region of that oscillator.... So your solution is doing this: - the latest point is most probably (or close to) a max/min based on the recent points history. Thanks for your time. Mika Tag: Less points in graph Tag: 110796
  - 22
    - SKU011.CAB Dear Sir/Madam, I have a problem relating to the aforesaid file (SKU011.CAB). A few searches for solutions on Google has lead me to deduce that problems of this kind are extremely commonplace and difficult to resolve in the circumstances but I wanted to post on here anyway in the hope that someone might be able to help me. I am using Microsoft Office 2003 and practically everything on it seems to be working properly except for Excel. It appears to be trying to complete some sort of installation at the start and demands an original source file, SKU011.CAB, in order to do this. As Office was pre-installed on this machine and I do not have the original disks, this is rather out of the question. The bizarre thing is that I can use Excel: I just have to cancel whatever installation procedure it is attempting a couple of times every time I try to start it (I can only assume, as a result, that there are certain Excel functions as yet unknown to me, which cannot be used). Needless to say I am also largely unable to update Microsoft Office 2003. I would really be most grateful if anyone can help me out in this area. Thanking you in advance, -- Karim434 Tag: Less points in graph Tag: 110789
  - 23
    - Copying multiple rows from different spreadsheet based on a logic Dear Friends, Need your help in the following : Here is my requirement: I have a worksheet which has columns 1,3,6,8. Which has few rows with a unique values in column 1. I get a spreadsheet everyday with columns 1,2,3,4,5,6,7,8,9,10. I need to insert new rows with only columns 1,3,6,8. I need a button using which I should be able to update. It would be great if the macro gives me an option of selecting the file. Thanks in advance. Tag: Less points in graph Tag: 110785
  - 24
    - Look for name and copy Hello Is it possible to look in sheet1 in collum B to al te rows with the name John en copy al these rows to sheet2 and look for the name Mike and copy all these rows to sheet3? In want to update by opening the file and if possible with a button on the sheet (for if the file is already opened). I don`t know if this is possible. I tried some things but can`t get it don because i dont know much about VBA and formulas. Mayby there is something like this on the internet but i can find it. Ill hope somebody can help. -- Using Opera's revolutionary e-mail client: http://www.opera.com/mail/ Tag: Less points in graph Tag: 110782
  - 25
    - Date-stamping How do I put the present date on a cell such as A1 so that any day I open the file, the correct date is shown. Thanks in advance. Tag: Less points in graph Tag: 110774
- Next
  - 1
    - I Need More Than 256 columns hi everybody is it posible to have a spredsheet with more than 256 columns ? i need to make a spredsheet with 365 columns (1 year) thanks Tag: Less points in graph Tag: 110773
  - 2
    - formatting cells Question: Recently, when attempting to format cells, whether it's for color fill or lines, boldface for type,and a variety of other cell formats--I now get a warning box which says 'too many different cell formats' even when I work with a duplicate of the spread sheet from which I have cleared all formats. Is there some way to correct this malfunction. I have worked for over ten years with excel and have not had this problem. It appeared on my G4 and now has carried over to my G5. I'm running Excel 2004 11.3 Tag: Less points in graph Tag: 110767
  - 3
    - Can't separate spreadsheets Using Excel 2000, I've suddenly lost the ability to have different spreadsheets appear in different windows (ie, to open Excel in different windows) which I can move around the screen. They all replace each other in the same window. I can toggle between them using the list in the "Windows" drop-down menu, but I can't have them side-by-side on the screen. Even the "tile" command doesn't work. Can someone suggest how to fix this? Bobbi Tag: Less points in graph Tag: 110755
  - 4
    - Visual Basic Book I'm thinking of purchasing a visual basic book to use as a reference. I use VB often and have a pretty good basic understanding but would like to get something to use as a reference for more complicated issues I come accross. Any suggestions on a good book? Tag: Less points in graph Tag: 110751
  - 5
    - How to make data stand out after selecting it in a filter Hi there, I have a worksheet with about seven ranges (class periods in a school day). At the top of the worksheet is a list of students' names and other info. I would like to add a filter to the worksheet so that users (teachers) could select a student, and the student's name or cell would either be highlighted in all the ranges, or all the other student names would be hidden in the ranges, making it easier for teachers to locate where a student is at a particular time of day. Thankyou for any info you could provide. Arnold Tag: Less points in graph Tag: 110738
  - 6
    - Excel 2000 sorting doesn't remember sort columns I have an excel 2000 file that has several different worksheets. A few I need to sort occasionally. One of them has no problem, I can just go to data->sort and it remembers what I sorted by last time. A couple of others I have to re-choose the columns each time; it doesn't even remember whether the worksheet had a header row. Anyone know a fix for this? Thanks, Steve Tag: Less points in graph Tag: 110737
  - 7
    - Is there a function that can ...? Good Day. I hope someone can help me with this little problem. Source data is a list of Names (col A) with corresponding numerical values (cols B to F). Each Name can have multiple, varying occurrences within this list. I wish to summarise, in another worksheet, the sum for each individual person. I am using sumif to sum each personâ??s values, which is working fine. The problem is how to have the summary table automatically find and list the names from the source, with the name occurring only once, with the numerical value being the sum of all the values for that personâ??s multiple occurrences (sumif as mentioned above). Also if a new name appears in the source, it automatically appears in the summary listing, with its applicable summary. Pivot table did not work. Which function would be best to use? Many thanks in advance. DeanH Tag: Less points in graph Tag: 110721
  - 8
    - import external data hey we have little problem when importin data from txt file. if file is in ANSI mode excel understant that is japanise but it contain finnish. If in than ansi file contain charters "Ã¶ Ã? Ã¤ Ã?" then that won't work. Tag: Less points in graph Tag: 110720
  - 9
    - Insert row macro I'm trying to build a macro that runs down my culumn C and inserts 1 blank row each time there is a change in the value from the previous cell. For example, if I have 100 rows of data and the first five are "CX104" and then the next ten are "CX105", and then the five after that are "CX106" and so on - that it would insert a blank row between the CX104 and the CX105 info, and a blank row between the CX105 and CX106 info...so in other words, if C2 does not equal C1, insert row... Any ideas? EggHeadCafe.com - .NET Developer Portal of Choice http://www.eggheadcafe.com Tag: Less points in graph Tag: 110717
  - 10
    - sumif vs sumproduct question Hi, I have a simple spreadsheet with column B containing all dates, and column D containing all numerical values. The dates range throughout a year. At the bottom of the sheet I've entered January through December in another column. To the immediate right of the month named, I have a formula which gives me the total for that month. For instance, next to January my formula reads: =sumproduct(--(month(b6:b370)=1),d6:d370) this formula works, but it seems to me I should be able to use SUMIF too. I've tried =sumif(d6:d370,month(b6:b370)=1,d6:d370) but that just returns a blank cell. I know this is silly, but it's driving me nuts. Can someone explain what I'm missing? TIA, Jim -- "The trouble with the world is that the stupid are cocksure and the intelligent are full of doubt." --Bertrand Russell Tag: Less points in graph Tag: 110714
  - 11
    - A Holiday Wish I just wanted to wish all of you good folks a safe and happy holiday season where ever you are. I get a tremendous amount of help from this group and it's appreciated. I'm leaving for California tomorrow for my vacation / holiday get away. I hope that all of you do something special as well. Best regards, Brian -- Tag: Less points in graph Tag: 110713
  - 12
    - Macro Loop Throws 1004 error I wrote a loop to skip through some data (with the idea of selecting and copying it). For some reason, when i=44 and the ActiveCell = HM2, a 1004 error is thrown on the .Offset(0,i).Select method. Dim i i = 0 Do While IsEmpty(ActiveCell.Offset(0, 1)) = False ActiveCell.Offset(0, i).Select i = i + 4 Loop There is no difference in the data on worksheet in the columns before and after the HM column. It is not at the edge of the worksheet. This is the error: "Run-time error '1004' Application-defined or object-defined error" What could cause this? -- The Texeme Construct http://you-read-it-here-first.com http://john-bailo.blogspot.com Tag: Less points in graph Tag: 110704
  - 13
    - Function with an error Please help debug this. I'm trying to turn a text string deliminated with | into an array. Option Compare Text Function Txt_Ary(Txt As String) As Range 'Turns the string value to a multi value range Dim Cnt As Integer Dim n As Integer Dim Tmp_Ary As Range Dim Tmp_Txt As String Dim Sel_Case As Integer Txt_Ary = Tmp_Ary With Application.WorksheetFunction 'Finds the number of values deliminated by a ; Cnt = Len(Txt) - Len(.Substitute(Txt, "|", "")) + 1 'there is "" or only one value then select case 1 otherwise select case 2 If .IsError(.Find(Txt, "|")) Then Sel_Case = 1 Else Sel_Case = 2 End If End With Select Case Sel_Case 'Select if there are no | in the text string Case 1 Txt_Ary = Txt Exit Function 'Select if there is a | in the text string Case 2 With Application.WorksheetFunction Tmp_Txt = Txt For n = 0 To Cnt If .IsError(.Find(Tmp_Txt, "|")) Then Tmp_Ary(n + 1) = Tmp_Txt Else Tmp_Ary(n + 1) = Left(Tmp_Txt, .Find("|", Tmp_Txt) - 1) Tmp_Txt = .Substitute(Tmp_Txt, Left(Tmp_Txt, .Find("|", Tmp_Txt)), "") End If Next End With End Select End Function EggHeadCafe.com - .NET Developer Portal of Choice http://www.eggheadcafe.com Tag: Less points in graph Tag: 110692
  - 14
    - need help with pivot tables i'll try to explain the best i can here: i have 3 sheets, 1. table with my quantity info, 2. (source data) table 1 transposed, 3. many "mini tables" referencing sheet 2 i first setup my pivot tables and got the "mini tables" setup the way i needed. then of course quantities changed, then after updating sheet 1 and copying a transposed version to the second sheet and deleting and adding rows and columns (so the headers will work for pivot table) data dissappears from my pivot tables. what am i doing wrong? is there a better procedure to accomplish what i need. thanks ahead of time for any info jeff jpurl@nospamkeys-shehan-engr.com Tag: Less points in graph Tag: 110691
  - 15
    - Missing password in DSN file Hi, I have a DSN file that i've been using successfully for some time to connect to my data source. It's in the format of: [ODBC] DRIVER=SQL Server SERVER=<my server name> DATABASE=<my database name> [Microsoft Office] UID=<my user name> PWD=<my password> The problem i'm now getting is that when I connect to a query i've created (or create a new one) using this DSN i'm being prompted for my password. It's populating the username with the on in the file, so I guess it must be reading hte file correctly. The only thing I can think of is that i've recently upgraded to Excel 2003 from Excel 97, but I can't find any info on why it no longer regognises the password when googeling. Any ideas? Cheers, <M> Tag: Less points in graph Tag: 110677
  - 16
    - 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 cell Thanks in advance, Bill Tag: Less points in graph Tag: 110672
  - 17
    - Modified date Please can anyone tell me how I can place in a cell on a sheet the date the workbook was last modified? Thanks Shane. Tag: Less points in graph Tag: 110667
  - 18
    - Need Help With Two Projects Crossword Puzzle and Lottery Ticket.. Excel 2002. How to Do? Templates Available? Thanks Barry Tag: Less points in graph Tag: 110664
  - 19
    - Excel 2000 Never noticed that before: Undo and redo are unavailable after applying Auto filter. Is this a known issue or something's wrong with my copy of Excel (or system)? Tag: Less points in graph Tag: 110657
  - 20
    - Open 'Save As' dialogue box using Macro I have chosen to hide the Menu Bar. How do I let users save their work? I plan to create a button and assign a MACRO to it so that users can click and 'SAVE AS' their file by first typing in the file name. Can someone come out with a macro command for this? Also a macro command to EXIT button (without saving the file). Thank you so much. Zainuddin Z Tag: Less points in graph Tag: 110656
  - 21
    - Join / Merge sheet data to a consolidated list Hello All Is it possible to join or merge data in multiple sheets to form a results sheet. eg. Sheet1 contains indeterminate number of records (variable unknown number of records) in column A, and an indeterminate number of similar records on Sheet2, Sheet3 etc. I want to read all entries in column A on all sheets and consolidate them all to one sheet for sorting purposes. Is this possible using a function in excel??? Thanks Jake Tag: Less points in graph Tag: 110651
  - 22
    - Separate macros for each cell. Hi all, Ok, this is kinda difficult to explain but i will try to. I have a workbook with 7 sheets inside. Each sheet accounts for one big category for example Air, Noise, Pollution. Take the "Noise" active sheet for example, it has a Row named Procedure/Training in which i want to enable users to input info. This info is DocumentType and DocumentName. For this purpose, i have created a user form with combo box for DocumentType and text box for DocumentName plus "Ok","Cancel" and "Clear Form" command buttons. The macro works fine except for it only returns the Document Name not the Document Type. I was expecting an input like "Document Type": "DocumentName". Here is the coding for the user form initialize Private Sub UserForm_Initialize() With cboDocument .AddItem "Corporate Guideline" .AddItem "Site Specific Guideline" .AddItem "Training Course" .AddItem "MDS" .AddItem "Vspec" End With cboDocument.Value = "" txtName.Value = "" cboDocument.SetFocus End Sub The coding for Ok button is as below: Private Sub cmdOk_Click() ActiveWorkbook.Sheets("SERI_EQA1").Activate Range("G3").Select ActiveCell.Value = cboDocument.Value ActiveCell.Value = txtName.Value Range("G3").Select End Sub 2) Now moving to next problem, assuming users can input the DocumentType and DocumentName, how can i make it loop? I mean in just one cell users might need to input in more than 1 document type n document name. How do i achieve this? 3) I have created a button in that cell that when the users click on it, it displays the user form. The problem is do i need to create separate buttons for each cell. This is gonna be very tedious as there are way too many cells (more than 50) and if i were to code for each n every button i cannot complete the project by next year. Please help. I know thats a lot of request in here but someone pls try to help...i need this project completed by end of this year and this portion i mentioned here is just one there are many more sections to be completed. Many thanks in advance. Kev. Tag: Less points in graph Tag: 110650
  - 23
    - Automatic sorting in excel I would like to be able to have a column sorted alphabetically contiuously. In other words, whenever data is entered, the whole column gets arranged alphabetically without having to "click' on the sort function. I am not a power user of excel, but I now understand the basics of running a macro. I have been guided to use the following macro example and adapt it to my worksheet. I have tried a few changes, but I cannot get it to work. Lets say the filename is "mybook" and the worksheet name is "sheet1" and the range I want to sort automatically is B1:B20 Private Sub Worksheet_Change(ByVal Target As Range) Columns("B:B").Select Selection.Sort Key1:=Range("B1"), Order1:=xlAscending End Sub However, I am not sure exactly which part I need to change in this code, for it to work on my worksheet. Thanks. Tag: Less points in graph Tag: 110649
  - 24
    - Summing within a Cell Hi, I have some cells that look like this: $10 red $4 Blue $13 Silver Is there a way to sum the dollar values while ignoring the text? Thanks, Tom Tag: Less points in graph Tag: 110644
  - 25
    - plus and minus I created a spread sheet to track capital gains/losses. If my cost basis is say A1 and sold is B1 what formula would work for the capital gains cell C1. Keep in mind it's a plus or minus. Thanks. JI Tag: Less points in graph Tag: 110638

Hello,
Is there a way to lessen the number of data points on the graph?
I would like to pick the entire column for the function, but to see in
the plot only part of the point.
Is it possible?
Thanks,
Noga

Top

Re: Less points in graph by Bernard

Bernard
Tue Dec 26 14:05:25 CST 2006

No but something close it.
Suppose your x-values are in A2:A201, and y-values in B2:B201
In C2 enter =IF(MOD(ROW(),5)=0,B2,NA())
Copy down to C201
Select A1:A201; hold CTRL and select C1:C201 and make chart
You will see every fifth data point
best wishes
--
Bernard V Liengme
www.stfx.ca/people/bliengme
remove caps from email

"Noga" <nogarybko@gmail.com> wrote in message
news:1167157344.511153.126870@42g2000cwt.googlegroups.com...
> Hello,
> Is there a way to lessen the number of data points on the graph?
> I would like to pick the entire column for the function, but to see in
> the plot only part of the point.
> Is it possible?
> Thanks,
> Noga
>

Top