Hi,
I'm trying to use a histogram to graph some experiment data. The data is categorical because we found the means of chemicals in the body, im now trying to show how they cmpare to each other. The problem is some values are so small i.e. 0.01 and others are up to 8. So when I graph that data the small value bars are so small it's almost impossible to seem them. I've tried using a log graph, but that is of no use because I also need to add error bars to the graph.
Please let me know if you have any ideas on how i can show the data thanks!
I was wondering if there was any way for the Large and Small functions to also return the row number in which it found the largest and smallest values?
column A is labels
column B is values
and I want output a sorted list without macros.
This is pretty easy if there are no duplicate values, but
I've been using
Column C. rank(B:B,switch)+row()/70000 to eliminate
duplicates
Column D. rank(C:C,switch)
Column E. match(row(1:1),C:C,0)
Column F. indirect("A"&[row from column E])
Column G. indirect("B"&[row from column E])
So I have 3 intermediate columns between input and output
Besides the obvious copy>paste>sort and without macros,
is there a quicker way to do this?
Hello!
Quick question, I'm using a SMALL function to determine a selection of the (worst in this case) values in a list, but my INDEX/MATCH is returning the same result when the values duplicate. Here's what I mean:
DOG 1
CAT 1
RAT -4
BAT -4
MAT 2
my report will list the smallest 4 properly, but if I use an INDEX/MATCH function to retrieve the value in the name column, it'll always return the first value. So : RAT, RAT, DOG, DOG.
Any ideas how to get around this? :/
Hi all,
I am trying to get the minimum value out of a column of values (A), based on a condition being furfilled in another column (E).
The values are in the following array: A2:A8 and the array that need to be checked against is E2:E8.
The formula I wrote is as follows:
=MIN(($E$2:$E$8
Hello everyone,
what I am trying to achieve with the final graph is:
1) horizontal axis: the continuous variable of interest with different class intervals
2) vertical axis: the frequency density given by Frequency/Class width
....I have no problem doing the first 2 points...the tricky bit is the following
3) I want to insert the data label in every column, which in this case should be represented by the frequency (the area) given by width*height of every rectangle
Whenever I try to insert data label it comes up with the data of the vertical axis (density frequency) and not frequency...
Hope I've been clear enough...
Thanks
Max
Hi,
I have to make a 5 class histogram,In analysis toolpak when I select histogram it creates number of bins itself,I cant specify the number ,for my data it makes 6 bins,but I need 5,What to do?
Can anyone please help me?
I will really appreciate any help
Thank you
Sadie
I'm writing an application in Excel, its a little over 5MB after I've run through UsedRegion and trimmed stuff, 94 worksheets. I'm encountering a fair number of crashes these days. My OS is fully patched as is MS Office. Running Windows server 2003 and Excel 2007.
I was wondering about the pros and cons of writing an application in one large workbook or many smaller ones. So far its been one large one but these crashes are really impeding my progress.
What's the best way to remedy these crashes or even start to diagnose?
Hi all,
I have a excel which was 560Kb in size.
Today i made a small change on a column:->
I clicked on a column ->
Went to Data-> Validation-> Settings tab->Selected Allow List->SOurce: yes,No
I made this change to the cell and copied it to all cells.
After this change size of the excel sheet became 3Mb
Why is this happening?
-Glen.
I would like to split an excel file of 60,000 rows into small text files (.txt) of 5000 rows (or lines) Is there any way I can split one large excel file into many text files?
I could find a macro that creates a text file from Excel data on another forum, but some how it doesn't seem to work in excel 2007
Code:
Sub Export()
Dim objFs As Object
Dim objText As Object
Dim strData As String
Dim n As Integer
Set objFs = CreateObject("Scripting.FileSystemObject")
'create the text file with Path & text filename
Set objText = objFs.CreateTextFile("C:\MyExcelData.txt", 1)
'create a string from the data
For n = 0 To 20
strData = strData & ActiveSheet.Range("B2").Offset(n, 0).Text & vbCrLf
Next n
'write the string to the text file
objText.WriteLine (strData)
'close the text file
objText.Close
'remove the file system object
Set objFs = Nothing
End Sub
Any help? anyone?
