PDA

View Full Version : microsoft excel help



yingxuan
01-06-2003, 04:18 PM
Im doing a science project and I need to plot some data

Im doing a bar graph.

And it goes across right?
Now how do i change the colour of the bar for the bar graph
I have like 7 datas along and it goes like starch iodine starch idone
And the first starch and iodine is for apple juice .The 2nd starch iodine is for orange juice.Since excel draws the graph all in blue.
How do i tell it to draw the first 2 bars in blue the 2nd bars in red etc..?

Capt Jimbo
01-06-2003, 06:19 PM
You should be able to format each bar separately by rightclicking on the bar itself.
There will be an option to select colours.

nomad
01-06-2003, 06:34 PM
right click on the actual bars choose --) format data series --> under first tab u can choose (pattern).

N.

yingxuan
03-06-2003, 11:28 AM
How do u change the series of the graph?
As in it says series one.how do u change it so that it goes in ,2,3,4 ?

I want to be able to use the bar graph and plot my data in.Since the drops of iodine and starch are the same it should go acrossin the x axis and the y axis would be the amount of drops for iodine and starch.
Now underneath where it says

Starch/Iodine/starch/ iodine
apple juice Milk

Now how do i put those words underneath?umm do u understand what i mean?

Capt Jimbo
03-06-2003, 02:46 PM
> How do u change the series of the graph?
> As in it says series one.how do u change it so that
> it goes in ,2,3,4 ?
> I'm not quite sure what you want to do here but I suggest that you either go Chart\Source Data\Series. Or double click on the series (on the chart itself) and format the scale.
> I want to be able to use the bar graph and plot my
> data in.Since the drops of iodine and starch are the
> same it should go acrossin the x axis and the y axis
> would be the amount of drops for iodine and starch.
> Now underneath where it says
>
> Starch/Iodine/starch/ iodine
> apple juice Milk
>
> Now how do i put those words underneath?umm do u
> understand what i mean?

Chart\Chart Options\Legend Tick legend and select "Bottom".