Michael D. Roush has written on 3/25/2010 3:06 PM:
PJH wrote:
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).
Logically, the years would not be major columns, they would be more like
"major rows", since your rows are months. If Row 1 contains the cost
items (gas, electric, etc), then Row 2 should have "2007" in Column "A"
(spanning 12 rows), and Row 2 should have "January" in Column "B"
(spanning one row).
This way, your series can run consecutively down the column (in other
words, the cell for January 2008 will be directly below December 2007,
not 11 rows higher in a different column).
You may find the graphing to go much simpler (and the wizard will get
you much closer to where you want to get) if you make that adjustment to
your labeling.
Wizard?
--
Pete Holsberg
Columbus, NJ
Talk sense to a fool and he calls you foolish...
-- Euripides
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
