Making a bar graph (Excel)

Homework giving you a headache? Math gives you a migraine? Can't quite figure out how to do something in photoshop? Never fear, the other members of CAA share their expertise in this forum.

Making a bar graph (Excel)

Postby Ingemar » Mon Jan 17, 2005 2:17 pm

I have to report data on a graph for my lab report. How do I make a bar graph? For instance, I have three samples, each with its own concentration. I imagine the X axis will have "sample 1, sample 2, sample 3" and the Y axis will be the amount.

Thoughts? Help? :eh: This thing is due on Thursday afternoon.
Job 7:16

I loathe my life; I would not live forever. Let me alone, for my days are but a breath.
User avatar
Ingemar
 
Posts: 2244
Joined: Sun Mar 28, 2004 12:43 pm
Location: A Dungeon

Postby ClosetOtaku » Tue Jan 18, 2005 4:51 am

Title a column "Samples". Title the column beside it "Concentration" (mg/dl), or whatever units you are using.

Now, right below "Samples", type in that cell "Sample 1". In the cell below it, "Sample 2". And so on.

Now, in the column "Concentration", beside Sample 1, type in the concentration, 0.31 or what have you.

Repeat for each sample.

Now, select the area (including the "Sample" and "Concentration" title columns).

Select, from the main toolbar, the Chart Wizard.

Select, from the Chart Wizard, Column Graph (or Bar Graph, if you want to go horizontal rather than vertical).

Push the "Press and Hold to View Sample" bar to get an idea what your basic chart looks like. Modify the parameters as necessary to get the chart to look the way you want.

Good luck!
"If I find in myself a desire which no experience in this world can satisfy, the most probable explanation is that I was made for another world." -- C.S. Lewis
User avatar
ClosetOtaku
 
Posts: 927
Joined: Tue Jul 06, 2004 3:12 am
Location: Alexandria, VA

Postby Mave » Tue Jan 18, 2005 6:59 am

Like what ClosetOtaku said,

1) highlight your numerical data and variables. (see attachment)

2) click on where the black arrow points to. Or you could use Insert>Chart.

3) the rest should be straightforward such as x and y labels and graph titles
You do not have the required permissions to view the files attached to this post.
User avatar
Mave
 
Posts: 3662
Joined: Tue Aug 12, 2003 9:00 am

Postby glitch1501 » Tue Jan 18, 2005 11:55 am

this reminds me of business systems applications from school....ewwww

Glitch's Photostream


He wants them to learn to walk and must therefore take away His hand; and if only the will to walk is really there, He is pleased even with their stumbles.

Image

Healing hands of God have mercy on our unclean souls
once again. Jesus Christ, Light of the World, burning
bright within our hearts forever. Freedom means love
without condition, without beginning or an end. Here's
my heart, let it be forever Yours, only You can make
every new day seem so new.
Every New Day - On Distant Shores - Five Iron Frenzy

Nail pierced hands they run with blood
A splitting brow forced by the thorns
His face is writhing with the pain yet it's comforting to me
Passion - Kutless
:thumb:
Image
User avatar
glitch1501
 
Posts: 2177
Joined: Mon Oct 20, 2003 6:50 pm
Location: the debris section

Postby Ingemar » Tue Jan 18, 2005 5:52 pm

Prof says data for this report won't need a graph of any kind *smacks head*

But I will need help for a x vs. y graph, so stick around...
Job 7:16

I loathe my life; I would not live forever. Let me alone, for my days are but a breath.
User avatar
Ingemar
 
Posts: 2244
Joined: Sun Mar 28, 2004 12:43 pm
Location: A Dungeon


Return to Tutorials

Who is online

Users browsing this forum: No registered users and 213 guests