Excel Sine Wave Graph/function Making
Feb 15, 2010i have some numbers as data, i want to find the function that generate thiese numbers and also i want to view the chart of it, its kind of sine wave graph.
View 9 Replies
ADVERTISEMENT
Identify Max And Min Peaks Of Sine Wave
Dec 2, 2013I have raw data from a cyclic test that needs to be refined to generate a simple trend.
The raw data has about 1000 points to each complete cycle and im only interested in the maximum and minium values of the peaks. This would be easy but I am typically dealing with 15 cycles a second and in some instances up to 5,000,000 cycles in one test.
The amount of data is too large to be completed in one file but if done in parts I can then use a formula to reduce the number of max and min peaks chosen i.e. 1 in 100.
Making A Trend Graph With Multiple Values?
Jul 17, 2014I was asked to make a trend graph showing activation's and deactivation's over time. My boss wanted it to be done automatically when you placed values into a simple excel sheet like the attached image (the graph would be below this).
View 14 Replies View RelatedMaking Chart/graph From Text By Occurrence
May 29, 2009I track inventory/sales for a very small sole proprietorship. I'm looking to track the number of items that I sell based on the text that I enter in a certain column.
Specifically, I want to have a visual chart/graph to show the percentage of each size/color of an item that I sell, as I sell it. When I enter the words "3T pink" I want the chart/graph/whatever to show another quantity of this category. As I sell a new item, I want the chart to reflect it.
The problem I'm having, is that the graphs/charts require two data sets, but I want the graph to calculate it for me! All I want to do is enter the text for specific items, and when the text occurs subsequent times, I want this reflected in the graph/chart.
It seems so much more simple in my head....basically I want a dynamic chart, not based on a static data set.
Making Single Graph With Two Datasets That Have Individual Dates
Apr 3, 2014I want to make a single graph from two data sets that have individual dates.
help!.xlsx
E.g.
Data set 1
1. January 2010 2. january 2010 ... 10. december 2010 etc
10 15 ... 10 etc
Data set 2
1. January 2010 ... 1. January 2015 etc
200 ... 200 etc
Excel 2010 :: Camera Function - Take Picture Of Graph And Pasting To Alternative Sheet?
May 21, 2014Excel 2010 and the camera function.
I have been using it to take a picture of a graph, pasting to an alternative sheet within the same workbook, and renaming the picture by a defined name. S by selecting the names from a drop down list the picture will select various different sized graphs defined within my drop down.
What I am experiencing is when I initially do this the pic works great and resizes automatically with each selection, however the next day some of the pictures resize and some do not.
Is this a glitch within excel or am I missing a setting which will resolve this?
Sine Of An Angle X By Summing An Infinite Series In VBA
Jul 18, 2006i was set some work related to maths to be carried out in VBA. the problem for me is im finding it very hard to understand either and so i cannot seem to work out how to complete the assignment given.
i can attach the assignment to save space and time reading on here however if you would like me to post up the assignement i can do that too....
Function Making Worksheet
Apr 24, 2008I'v got a school task about making a excel worksheet.
But we have just started and i havent gotten all the functions to work yet.
The task itself is :
Make function that tests if D9 is larger then 100 and I9 is less then 50. If true "Kontroll" if not "OK" should be written.
Also, if "Kontroll" shows up it should have a dark green "OK " should just be black
Its roughly translated from norwegian. If you need some more information I will try to provide it
Making A Case Function
Nov 13, 2008i am trying to get the following function to work
i want it to look at 2 cells, depending on the number in the second cell i want it to multiply the first sell by a specific number.
for exaple (Below) function in a3 looks at a2 sees it is a 2 and multiplies a1 by 1.09 shown in the code below
A1=load
A2=factor
A1 A2 A3
100 2 Function
Function Pmax(Load, Factor) As Double
Select Case (Factor)
Case "1"
Pmax = Load
Case "2"
Pmax = Load * 1.09
Case "3"
Pmax = Load * 1.12
Case "4"
Making Complicated Sumproduct Into Function?
Jul 9, 2014So I have a rather complicated IF, Countif, Sumproduct combo in a formula right now. As you can imagine this makes my worksheet run rather slowly. I was curious if there is any way to make this formula into a User Defined Function. The formula looks like this:
[CODE]
=IF(A15="","",IF((AND(COUNTIFS(J:J,J15,AM:AM,ABS(AM15),AD:AD,AD15)>1,
(SUMPRODUCT(--($J$17:$J$10000=$J15),--($AD$17:$AD$10000=$AD15),--(ABS($BD$17:$BD$10000)
=ABS($BD15)),--($AX$17:$AX$10000=$AX15),$BD$17:$BD$10000))
[CODE]
I would not be surprised if this isn't possible but thought I would try. Another possible approach would be to make this into a macro and instead of the output being "Duplicate" or "Research" just have the "Duplicate" Cells Highlighted in Red and the "Research" Celss highlighted in yellow.
Making Standard Deviation Function Dynamic
Dec 10, 2013Basically i have a list of data for example from B2 to B2000 for which i want to calc a standard deviation across however the number of data points in the standard deviation need to be dynamic.
For example in Cell a1 i can enter 150 it will then calc the standard div across the first 150 data points (points 1 to 150) then in the cell below calculate the next standard div.
Standard Div Points10
Data PointData ListStandard div
10.167442459
20.539073451
30.29740845
40.309440859
50.640742715
[code].....
Making User-defined Function Accessible To All Workbooks
Apr 16, 2002I've got a couple of user-defined functions that I coded in via one workbook (wkb A), but would like these functions to be accessible to any workbook (wkb B...Z). How is this done so that when I start a new blank wkb I can use these user-defined functions there as well?
View 9 Replies View RelatedFind Average Of Different Wave Lengths
Aug 14, 2013I have attached an excel file. What I would like to find is the average of column D (number) with respect to column A (Genotype ) and also different wave length (Column C). i.e.:
Genotype 1 to its corresponding value in column D for wave length 450
Genotype 1 to its corresponding value in column D and for Wave length 470 to and so on.
Attached File : test2.xlsx
Calculate Wave Time Cycle
Sep 24, 2007how to calculate in data serie cyles the:
- Mean Amplitude
- The Time (minutes) cycle between Maximum and Minimum cycle values (If the Cycle value X Amplitude)
- Cycle Mean Time.
Play Wave Sound Then Stop Playing It
Jan 5, 2003I'm using this simple code to play a wav file I loaded into a worksheet:
ActiveSheet.Shapes("Object 1").Select
Selection.Verb Verb = xlclose
I attached the macro to a button and it works. Now I need to stop the wave sound playing, by attaching another macro to a button. Is that possible? What syntax shall I use to stop playing the sound?
Play Wave Sound Then Stop Playing It?
Sep 14, 2013I'm using this simple code to play a wav file I loaded into a worksheet:
ActiveSheet.Shapes("Object 1").Select
Selection.Verb Verb = xlclose
I attached the macro to a button and it works. Now I need to stop the wave sound playing, by attaching another macro to a button. Is that possible? What syntax shall I use to stop playing the sound?
Graph Rational Function
Jun 20, 2007when graphing a rational function (y = 1/x) i get a line crossing the asymptote (y axis for this function...)
View 5 Replies View RelatedGraph Trigonometric Function Results
Sep 20, 2007graphing trigonometric functions...
sin and cos seem to work easily, but i'm having trouble getting the tangent function to graph (look) correctly...?
SMALL Function For Update Graph Dynamically
Apr 21, 2009I have a Big Question about the SMALL Function in Excel. I would like to know if it is possible to use a syntax that will make the small function update my graph dynamically.
Personnel transfer out of the Department on know dates... but they come in to the Department all the time. I would like to know if I can increase the "range of my data" even if I don't have data in the cells (i.e. B2:B6 have data, I want the range to include B7:B16, which has no data)... When I have no data in the cells I get errors/ circular references...
Ideally, I would like be able to add or remove personnel and the SMALL function would "organize/update" my graph dynamically. Is this possible?
Square Root Spiral Function Graph...
Nov 10, 2006Square Root Spiral Function Graph. i was looking for vba code to graph the Square Root Spiral from Pythagorus in Excel...?
View 8 Replies View RelatedMaking AutoRun CD Opening Excel?
Mar 5, 2003How to make a CD AutoRun an excel page? I know you can do this with a few different formats but I'm not having any luck with it working on an Excel file.
View 4 Replies View RelatedMaking Labels From Excel File?
Sep 9, 2012making labels from excel file
View 1 Replies View RelatedMaking List Of Excel File Authors?
Sep 18, 2013I have a bunch of excel files in a folder, and I want to make an excel spreadsheet that makes a list of them all. This drive is a shared drive and their are different authors for files. I have already made the list, with the file name, date modified, date created, etc. However, I am having trouble importing the list of the authors for the files. Is there a way to automatically import a list of excel files in an excel, with an "authors" column? I can't do it manually, for their are hundreds of excel files.
View 1 Replies View RelatedExcel 2010 :: Making A Planning - To Show In A Report?
Dec 2, 2013I would like to make a planning, to show in a report. Is this possible to do with Excel 2010? Or do I need another programm?
View 2 Replies View RelatedMaking A Two Columm Word Document From Excel Data
Mar 6, 2010I want to take data from an Excel 2003 Worksheet as shown below:...
View 9 Replies View RelatedExcel 2010 :: Making Chart Title From Cell Contents?
Jan 10, 2014I am trying to make the contents of a cell into a chart title.I know I can do it like this...
ActiveChart.ChartTitle.Select
Selection.Caption = "=tab_name!R2C1"
However, I am trying to use the same macro on several different tabs in the same EXCEL worksheet. Obviously, I can't have the tab name in the macro. But, I don't get a title at all when I try to remove it like this...
ActiveChart.ChartTitle.Select
Selection.Caption = "=R2C1"
or
ActiveChart.ChartTitle.Select
Selection.Caption = "=A2"
Is this possible? I am (kinda new at) using EXCEL2010.
Excel 2010 :: Making Portions Of Drag Down Formula Skip Cells
Feb 11, 2014I have set up a formula to sum data from specific columns in multiple sheets in the same file. The simple formula had worked perfectly until I needed the data from the last sheet. In all of the other sheets the data that I need to pull is all in consecutive rows but in the last sheet the data that I need pulled and added is in every 4th row. The sheet looks like this:
All of the columns I've filled in work fine. The ones blank are the ones I am running into issues with. When I drag down the formulas excel pulls the next consecutive rows, which is perfect for the first four sheets I am summing, but for the fifth sheet (I'll ref the Test1 column) I need it to pull 'Wayne 2014'!C6 and then 'Wayne 2014'!C10 in the next row and so forth.
Date
All Test
Test1
Test2
Test3
Test4
$ Amt.
Jan.16
=SUM(C2+D2+E2+F2)
[Code] ........
The first four sheets look like this, which is why they work fine:
Date
All Test
Test1
Test2
Test3
$ Amt.
Jan. 16
=SUM(C2:E2)
[Code] ........
The fifth sheet looks like this: I only want the formulas from the first sheet to pull the data from the dated rows in this sheet.
Date
All Test
Test1
Test2
Test3
$ Amt.
Jan. 16
=SUM(C2:E2)
=SUM(C3:C5)
[Code] ......
Is there any way in Excel 2010 to get it do what I want? (I am not sure how that one cell became outlined and I do not know how to fix it.)
Excel 2010 :: Making Worksheet Open In Full View Mode At User End
Sep 3, 2013I'm using Excel 2010. I have a workbook with only 1 worksheet in it and it will be sent to several people. I want that excel file to open in Full View when the end user opens it. Is this possible without any VBA codes?
View 2 Replies View RelatedGet Data Out Of Graph Into Excel?
Aug 5, 2014I was wondering, if I can extract data out of a excel graph what is been paste into word document and send to me, without the excel data sheet.
So I want to get data out of more then one graphs that are paste into word. and i want to do this in a fast way. In order to create a datasheets.
Plotting Graph In Excel
Mar 26, 2014nrel25mar.xls
I have attached Excel sheet as above. I wanted to plot graph time vs pic-zenith,pic-azimuth,pic-elevation .
I tried to plot graph but value of point in excel sheet is differ from table value. For single graph no problem,When all put together leading some problem. What kind of char can plotted above reading values.