Quick google spreadsheet help w/ regards to graph

[MikeMike]

need to make a very simple graph.. but yet I cant figure out how to do it...

the High end of the range is $3.41
the Low End of the range is $3.07

All I want is a simple graph that has two lines across it one at high one at low, with the area in between highlighted...

Thats it

 

[Mr. Pedantic]

It's not hard.

3.07 in A1
3.41 in B1.

Press the graph button.
Select the graph type with the shading under the line
Done.

 

[MikeMike]

It's not hard.

3.07 in A1
3.41 in B1.

Press the graph button.
Select the graph type with the shading under the line
Done.

yea, because that does what I am asking???

lol no it doesnt.

 

[busydude]

You mean like this?

 

[MikeMike]

You mean like this?

does that...

look like

two lines across it one at high one at low, with the area in between highlighted

$3.41|---------------------------|
     |xxxxxxxxxxxxxxxxxxxxxxxxxxx|
     |xxxxxxxxxxxxxxxxxxxxxxxxxxx|
     |xxxxxxxxxxxxxxxxxxxxxxxxxxx|
     |xxxxxxxxxxxxxxxxxxxxxxxxxxx|
     |xxxxxxxxxxxxxxxxxxxxxxxxxxx|
$3.07|---------------------------|

x = shading
- = the line

 

[busydude]

does that... look like

That is most dumbest graph I have ever seen.

 

[MikeMike]

That is most dumbest graph I have ever seen.

obviously there is more numbers on the graph outside of that range... but that represents the optimal pricing according to consumers for the price of gas in April of 2011