Re: [users] Re: Need Help Graphing Energy Usage

2010-03-31 Thread Ingrid Halama
On 03/29/10 10:40, PJH wrote: [...] Now my only problem is that my first date in the table is 3/16/04 but the origin of the X-axis is 1/14/04. Is there any way to make the X-axis begin at my first data point? Double click the chart. Within the menu choose Format-Axis-X-Axis... . Within the

[users] Re: Need Help Graphing Energy Usage

2010-03-29 Thread PJH
Daniel Lewis has written on 3/28/2010 8:05 PM: PJH wrote: Andreas Saeger has written on 3/28/2010 3:58 PM: PJH wrote: OK, I want an x/y scatter chart with dates as the X-axis and several Y-axes. How do I do that? Thanks. Open the chart (double-click) and change the chart type. That

Re: [users] Re: Need Help Graphing Energy Usage

2010-03-28 Thread JOE Conner
On 3/27/2010 3:54 PM, PJH wrote: JOE Conner has written on 3/27/2010 4:26 PM: On 3/27/2010 10:01 AM, PJH wrote: BIG SNIP 3) Under Chart Type, select Line and Stack Series (although it's not clear to me what Stack Series means) You would find the X-Y chart the most useful for what you are

[users] Re: Need Help Graphing Energy Usage

2010-03-28 Thread Andreas Saeger
PJH wrote: 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

[users] Re: Need Help Graphing Energy Usage

2010-03-28 Thread PJH
Andreas Saeger has written on 3/28/2010 9:29 AM: PJH wrote: 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

[users] Re: Need Help Graphing Energy Usage

2010-03-28 Thread Andreas Saeger
PJH wrote: OK, I want an x/y scatter chart with dates as the X-axis and several Y-axes. How do I do that? Thanks. Open the chart (double-click) and change the chart type. - To unsubscribe, e-mail:

[users] Re: Need Help Graphing Energy Usage

2010-03-28 Thread PJH
Andreas Saeger has written on 3/28/2010 3:58 PM: PJH wrote: OK, I want an x/y scatter chart with dates as the X-axis and several Y-axes. How do I do that? Thanks. Open the chart (double-click) and change the chart type. That is the answer to how to get an x/y scatter chart. How do I

Re: [users] Re: Need Help Graphing Energy Usage

2010-03-28 Thread Daniel Lewis
PJH wrote: Andreas Saeger has written on 3/28/2010 3:58 PM: PJH wrote: OK, I want an x/y scatter chart with dates as the X-axis and several Y-axes. How do I do that? Thanks. Open the chart (double-click) and change the chart type. That is the answer to how to get an x/y scatter chart.

[users] Re: Need Help Graphing Energy Usage

2010-03-27 Thread PJH
JOE Conner has written on 3/26/2010 12:36 AM: On 3/25/2010 4:50 PM, PJH wrote: JOE Conner has written on 3/25/2010 5:03 PM: snip INSERT - CHART brings up the chart wizard. Perhaps you should look through the helps provided at http://wiki.services.openoffice.org/wiki/Documentation JOE,

[users] Re: Need Help Graphing Energy Usage

2010-03-27 Thread PJH
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,

Re: [users] Re: Need Help Graphing Energy Usage

2010-03-27 Thread JOE Conner
On 3/27/2010 10:01 AM, PJH wrote: SNIP 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:

Re: [users] Re: Need Help Graphing Energy Usage

2010-03-27 Thread JOE Conner
On 3/27/2010 10:01 AM, PJH wrote: BIG SNIP 3) Under Chart Type, select Line and Stack Series (although it's not clear to me what Stack Series means) You would find the X-Y chart the most useful for what you are trying to do. 4) Next brings me to Data Range and I accept the default of Data

[users] Re: Need Help Graphing Energy Usage

2010-03-27 Thread PJH
JOE Conner has written on 3/27/2010 4:20 PM: On 3/27/2010 10:01 AM, PJH wrote: SNIP 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

[users] Re: Need Help Graphing Energy Usage

2010-03-27 Thread PJH
JOE Conner has written on 3/27/2010 4:26 PM: On 3/27/2010 10:01 AM, PJH wrote: BIG SNIP 3) Under Chart Type, select Line and Stack Series (although it's not clear to me what Stack Series means) You would find the X-Y chart the most useful for what you are trying to do. Pretty sure I want

Re: [users] Re: Need Help Graphing Energy Usage

2010-03-27 Thread John Boyle
PJH wrote: JOE Conner has written on 3/27/2010 4:26 PM: On 3/27/2010 10:01 AM, PJH wrote: BIG SNIP 3) Under Chart Type, select Line and Stack Series (although it's not clear to me what Stack Series means) You would find the X-Y chart the most useful for what you are trying to do.

Re: [users] Re: Need Help Graphing Energy Usage

2010-03-27 Thread JOE Conner
On 3/27/2010 3:54 PM, PJH wrote: JOE Conner has written on 3/27/2010 4:26 PM: On 3/27/2010 10:01 AM, PJH wrote: BIG SNIP 3) Under Chart Type, select Line and Stack Series (although it's not clear to me what Stack Series means) You would find the X-Y chart the most useful for what you are

[users] Re: Need Help Graphing Energy Usage

2010-03-25 Thread PJH
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

Re: [users] Re: Need Help Graphing Energy Usage

2010-03-25 Thread JOE Conner
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

[users] Re: Need Help Graphing Energy Usage

2010-03-25 Thread PJH
JOE Conner has written on 3/25/2010 5:03 PM: snip INSERT - CHART brings up the chart wizard. Perhaps you should look through the helps provided at http://wiki.services.openoffice.org/wiki/Documentation JOE, there's an overwhelming amount of material there, and no way to find exactly what

Re: [users] Re: Need Help Graphing Energy Usage

2010-03-25 Thread JOE Conner
On 3/25/2010 4:50 PM, PJH wrote: JOE Conner has written on 3/25/2010 5:03 PM: snip INSERT - CHART brings up the chart wizard. Perhaps you should look through the helps provided at http://wiki.services.openoffice.org/wiki/Documentation JOE, there's an overwhelming amount of material there,