I am making a bar graph in MS Excell adn one of the bars is much larger than the others and I would like to cut the bar and y axis so that my other data is represented better. Is there a way to put in a slash line, so I can leave all the data in the graph?
bump
1. click on the Y axis, scale tab, select "log scale".
2. Normalize the data around the mean. that leaves you w/ a "fat tail"
thanks but I can't put my data on a log scale. Any other way to do this in Excel?
This data is an outlier. Normally one would exclude it.
Put it in tabular form.
Or normalize around the mean.
Why can you juxtapose two graphs next to each other, the 2nd chart to the right omit the axis details?
Or if it the image of the chart that's needed and not the actual chart, then get with hypersnap and splice two jpegs together. You can edit the images with a little jagged line to indicate a "splitscreen."
From a previous Excel question
I've hidden years 1985-1988, the graph changes.
I just thought that Excel woudl have this function. The data is not an oulier, it is just a much higher value than the others. I did not want to make it an image because I want to be able to group and ungroup when I place it in PP for publication.
Any others out there know of a better way?
How about putting the outlier on a second Y-axis? You can adjust the scale on each y-axis separately.
FIght Time wrote:
I just thought that Excel woudl have this function. The data is not an oulier, it is just a much higher value than the others. I did not want to make it an image because I want to be able to group and ungroup when I place it in PP for publication.
Won't my solution of hiding the data fields that you do want to show work?
FIght Time wrote:
The data is not an oulier, it is just a much higher value than the others.
...definition of an outlier.
Another possibility is to present the data as a bubble chart. this may compensate.
But it sounds like you should take the log of each number =LN(Cell) or =LOG(Cell, base) and chart it.
malmo wrote:
Won't my solution of hiding the data fields that you don't want to show work?
No, I need to show all the data.
I am looking at gene amplification (mRNA), so on the x axis I am listing the genes, and on the Y, the amplification normalized to a control, which is 1 for all genes. So the data is something like this:
Gene A 2.2
Gene B 3.4
Gene C 1.7
Gene D 9.6
The difference in the amplification levels b/w A,B and C are significant, but that does not show very well when D is included in the graph. Traditionally, this type of data is displayed using bar graphs. I could do the imaging you mentioned, but I was hoping to be able to splice the graph within Excel somehow. Thanks for your suggestions.
By that term perhaps, but not in the scheme of my study. I am graphing gene amplification, and I would like to include a gene that shows much higher amplification than others, while at the same time, show the significant difference b/w the others. See the above post...
A second Y axis within the same graph?
I'm not getting what you're looking for. You say you need to show all data, but don't need to show all data? I'm not getting it?
Your top chart is correct in that it shows all the data. What I am trying to explain (but not very well) is that I want to display the data so that it demonstrates the significant difference between A, B, and C, but also include D. If you look at the bottom chart you made, the differences between the smaller data sets show much better when that one large data set is not included. I don't have a way to show it but I would like the Y axis slashed, and the one bar slashed so that the middle chunk could be left out, but the top portion shown.
When only the smaller data sets are included, it is like a close-up showing the differences. This gets lost when the larger set is included.
You want to exclude values on the Y axis?