PJH has written on 3/25/2010 2:43 PM:
I want to set up a spreadsheet with the following layout:
The rows are the months, Jan..Dec
The "major" columns are years, 2007..2009
under each year there is a set of columns: gas, elect, degree days, cost
(or I could do simple columns: 2007 gas, 2007 elec, 2007 DD, etc.)
Not difficult to set up (but I'm open to suggestions).
I want to graph each year's "minor" columns as a line graph, one on top
of the other with the months as the X-axis.
That is, on each chart (gas, elect, DDs, $), there would be three lines,
one for each year.
Can someone point me to a how-to for that?
Many thanks.
I'm going to post my feeble attempts at getting a line chart done in the
hopes that (a) I will eventually be successful and (b) someone else will
benefit from my flounderings.
I have a spreadsheet with the following columns and data ranges:
A: date
B: odometer reading -- now up to about 60000
C: trip odometer -- 100-500
D: gas purchased -- 20 max
E: cost -- $60 max
F: cost/gal -- $5.00 max
G: MPG - 20-40
I want a plot of B, E, F and G vs A. I would like separate scales for
each Y-axis value.
Here's what I did.
1) Select all the data in the chart from the first row of interest to
the last.
2) Insert > Chart
3) Under Chart Type, select Line and Stack Series (although it's not
clear to me what "Stack Series" means)
4) Next brings me to Data Range and I accept the default of "Data Series
in columns"
5) Under Data Series, I remove all data series except columns A, B, E, F
and G. I have no idea what to do with "Range for Y-Values".
6) Chart Elements, I leave alone for the time being.
Result is a chart where A is not the X-axis variable, and there is only
one scale for all of B, E, F and G!!
So, three questions:
1) How do I make A the X-axis variable?
2) How do I make separate scales for the Y-axis variables?
3) How do I insert the chart on Sheet 2 instead of sheet 1?
Thanks.
--
Pete Holsberg
Columbus, NJ
There is nothing better than a friend, unless it is a friend with
chocolate...
--Charles Dickens
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
