On 3/25/2010 1:50 PM, PJH wrote:
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?
INSERT -> CHART brings up the chart wizard. Perhaps you should look
through the helps provided at
http://wiki.services.openoffice.org/wiki/Documentation
Joe Conner, Poulsbo, WA USA
---------------------------------------------------------------------
To unsubscribe, e-mail: [email protected]
For additional commands, e-mail: [email protected]
