I want to draw such a kind of column for marine benthos. how i can draw it. is it possible to draw it with Excel or Graphpad Prism?
Mohammad,
There's an easy Excel hack that will let you generate your chart within Excel cells... no graph tool required. Super easy. Set up your data and then create the bars in text characters using the REPT function (which repeats the text character for each value in your data) and a "box" character in a wingding font. I've attached an example in excel and a screenshot. With some attention to formatting, font, & character selection it can be publication quality.
maybe are you talking about multivariate dataset? i'm not sure i understood your question....anyway here is my answer: using excel you can enter one species for one column from left to the right and density data on rows, exactly on the first column on the left. you have to create a column with depth and rewrite depth in all rows linking density to the right depth measured in the field. is this the answer you are waiting for?
Dear Francesco
I have data from depth and macroinvertebrates. I want to draw a column as like as in the picture.
This column contains 3 axis. one for depth, one for density and one for macroinvertebrates communities. My goal is to combine all these data,s to one chart
@Mohammad,
The attached sample chart may give you some directions. Some modification are necessary fit around your data set.
Sure......... It was my fault.....now it is liclear....sorry for misunderstanding....the example si perfect bit remember that you van also draw single graph for each taxa and finally cut and copy alla graph in a single file using photoshop or other software.
Hi Mohammad
That's easily done with Tableau, using the same column and row variables and specifying the variable (e.g. species) that would generate the separate sections. Or you could just use Excel and cut and paste separate graphs together.
Dear John
Thank you very much
can you explain more about Tableau and method?
Hi
Tableau is a data visualization software. You can use it free as long as you don't mind your data being public. You can find it at http://tableausoftware.com. Once you've uploaded your data, you'd just define your row and column variables, choose the bar graph format, then specify the "species" (or whatever it is) variable as the level of detail.
Dear John
I wanted to open the web address but i can not access.
this message appears:
You don't have permission to access "http://www.tableausoftware.com/" on this server.
Something to do with your server, I think. Can't help with that! Sorry.
Mohammad,
There's an easy Excel hack that will let you generate your chart within Excel cells... no graph tool required. Super easy. Set up your data and then create the bars in text characters using the REPT function (which repeats the text character for each value in your data) and a "box" character in a wingding font. I've attached an example in excel and a screenshot. With some attention to formatting, font, & character selection it can be publication quality.
Dear Jack
It was not work for me. please see the attached screenshot.
how i can fix it?
Thanks to @Jack for his valuable contribution.
@Mohammad,
Some of your problems on graphics have been solved (see the attached).
But you should do something with uneven range in the measured data for each depth category.
Also have a look on your data against high values according to your observations (may need to check the outliers in the last category (>20)).
Thanks @Raoof for the update.
@Mohammad
the font issue in my example comes from me using a Mac and you using a Windows PC. All you need to do is swap out the Mac wingding character with an appropriate Windows wingding character. Check out the following for details. http://windows.microsoft.com/en-us/windows/using-special-characters-character-map-faq#1TC=windows-7
Camelia...that's very cool. I guess I need to learn the new excel tricks :)
- Badges
- Science topic