Re: [libreoffice-users] Re: Linear Graph with X,Y data

2016-02-17 Thread Brian Barker
At 13:50 17/02/2016 -0800, Joel Madero wrote: Pedro Pedlino wrote: (BTW if you make the first date value 1/15/2007 and the second 2/15/2007 you can simply drag the X values all the way down and LO is smart enough to always use the 15th of every month) I had this kind of a setup before and it

Re: [libreoffice-users] Re: Linear Graph with X,Y data

2016-02-17 Thread libreoffice-ml . mbourne
Joel Madero wrote: Hi Regina and Pedro, Technically it is possible, but it is cumbersome and instable. I would not go that way, but generate a one-dimensional list from the data. With such list, you can use a real time axis. That's what I figured - so I'll have to have a ghost list somewhere

Re: [libreoffice-users] Re: Linear Graph with X,Y data

2016-02-17 Thread Joel Madero
Hi Pedro, > > In my experience this is simply not possible. To have a linear graph the > X-values have to increase (in this case with year). You have 12 text values > on the X-axis. > You really have to convert this to a two column structure (BTW if you make > the first date value 1/15/2007 and

Re: [libreoffice-users] Re: Linear Graph with X,Y data

2016-02-17 Thread Joel Madero
Hi Regina and Pedro, > > Technically it is possible, but it is cumbersome and instable. I would > not go that way, but generate a one-dimensional list from the data. > With such list, you can use a real time axis. That's what I figured - so I'll have to have a ghost list somewhere (probably

Re: [libreoffice-users] Re: Linear Graph with X,Y data

2016-02-17 Thread Regina Henschel
Hi Joel, Joel Madero schrieb: Hi All, Please see this file: https://drive.google.com/file/d/0B2kdRhc960qdV2dTVUh5aWZIUWc/view?usp=sharing I'm hoping to create a linear graph from January of 2007 -> Current Month using this data. I can't think of a way to do this without putting the data in a

[libreoffice-users] Re: Linear Graph with X,Y data

2016-02-17 Thread Pedro
Hi Joel jmadero wrote > I'm hoping to create a linear graph from January of 2007 -> Current > Month using this data. I can't think of a way to do this without putting > the data in a different format (possible but not ideal). Can anyone > think of a different solution for a single line chart

[libreoffice-users] Re: Linear Graph with X,Y data

2016-02-17 Thread Joel Madero
Hi All, Please see this file: https://drive.google.com/file/d/0B2kdRhc960qdV2dTVUh5aWZIUWc/view?usp=sharing I'm hoping to create a linear graph from January of 2007 -> Current Month using this data. I can't think of a way to do this without putting the data in a different format (possible but