View Single Post
  #4   Report Post  
Posted to microsoft.public.excel.programming
Jon Peltier[_4_] Jon Peltier[_4_] is offline
external usenet poster
 
Posts: 90
Default Tricky Graph Question

Thanks, Don, for the plug. But I think I'll give Neil a brief intro
right here.

Put your A values in one column (how about A?), and the B values in the
next column (B). Select a single cell in the range of data, or select
the entire range to be plotted. Run the chart wizard, either from the
button that looks like a little column chart, or from Chart on the
Insert menu. In step 1 of the chart wizard, select one of the XY
Scatter chart types (fifth choice on the left), not the Line chart
(third choice). Follow along with whatever embellishments you want, or
set them later.

Sample data:

10 8
9 7
3 3
1 1.5
0.5 0.5

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______


Neil wrote:

Hi, I have two raw materials A & B, I measure the amount
of each of them during a reaction. If the ratio of A:B is
ok the reaction will proceed with no further additions of
either raw material, I want to generate a tram line graph
that shows the aging of the reaction. "A" would be along
the bottom and "B" up the side, I would have two columns
of reation results, each time I would measure both A & B.
If I plot this info I get a graph with two lines on it,
how do I plot a variable amount of A against a variable
amount of B ? e.g. A=10, B=8, next data A=9, B=7, next
data A=3, B=3, next data A=1, B=1.5 and ultimately A=0.5
B=0.5.