There is no problem with the Heading. The problem is with the Headings that are at the bottom of each column. They seem to be unmovable. Anyhow what is use as a Heading for the column is tricky. If X12 (any letter before any number) is a column heading the column heading under the column will be just the 12. If a space is put between the X and the 12, the column heading will be X 12. I can not figure out how to manage the column heading. When the column heading are too long to fit below the columns, and something is set properly, the heading we be in alternating rows so they can be read. If the settings are not set properly the heading will be in just one row and can not be read.
On Fri, Dec 23, 2011 at 4:53 PM, Tom Davies <[email protected]> wrote: > Hi :) > I think you can move the heading. Can you click into the chart somewhere > and then imagine a frame around the heading and try to click on it? Once > you have found and selected the frame it should be fairly easy to drag it > somewhere. > Regards from > Tom :) > > --- On Fri, 23/12/11, Walter Hildebrandt <[email protected]> wrote: > > From: Walter Hildebrandt <[email protected]> > Subject: Re: [libreoffice-users] Chart in Calc > To: [email protected] > Date: Friday, 23 December, 2011, 17:24 > > Yes Tom, something is a bit wondy (As an American I do not know the true > meaning of the word wonky but it sounds both good and correct). > And yes, the guide you gave the link to is a good guide. I used Chapter > 3, Creating Charts and Graphs when I first started to learn about Charts. > It did show me how to create a column chart very quickly. The problem with > all the teaching documentation is that it is written by people with a lot > of knowledge so that you have to have more knowledge that the average > person has in order to understand what the teaching documentation is > saying. I originally started the website Tutorials for OpenOffice. At one > point there were more people coming to the Tutorials for OpenOffice website > than coming to the User Group at OpenOffice. If anyone is interested I > would be glad to discuss this more. There is a need to have teaching > material that supplements the official teaching documentation of LOo. > > I have done just about nothing with the chart. I will watch to see if the > lag time is a problem. I do have a problem. The labels do go correctly > at the bottom of the charts when there are some negative numbers below the > zero line. However if I make the chart wider, the negative part of the > column covers the title of the column > > On Fri, Dec 23, 2011 at 11:11 AM, Tom Davies <[email protected] > >wrote: > > > Hi :) > > There is a good guide here > > > > > http://wiki.documentfoundation.org/Documentation/Publications#LibreOffice_Calc_Guide > > > > I'm not really sure how to summarise as it sounds like you are doing the > > right thing but something is obviously a bit wonky. When you enter new > > data to replace values in the data-range do you press enter and then give > > it a little moment? It doesn't take long but it's not exactly instant. > > Perhaps a minute or less. > > > > Apols and regards from > > Tom :) > > > > > > --- On Fri, 23/12/11, Walter Hildebrandt <[email protected]> wrote: > > > > From: Walter Hildebrandt <[email protected]> > > Subject: Re: [libreoffice-users] Chart in Calc > > To: [email protected] > > Date: Friday, 23 December, 2011, 14:16 > > > > Thank all of you for the help. The chart is an embedded object that I > can > > change and save. > > > > On Fri, Dec 23, 2011 at 3:14 AM, Steve Edmonds > > <[email protected]>wrote: > > > > > Hi. > > > I think if you click on the chart you should get handles on the outside > > of > > > the chart. > > > You should be able to click on the lines (and other components) in the > > > chart and get handles. > > > You should be able to right click on these components with handles and > > > change properties. > > > steve > > > > > > > > > On 23/12/11 4:01 PM, Walter Hildebrandt wrote: > > > > > >> No, I do not have a chart that can be updated. I open the spreadsheet > > >> that > > >> has the data wanted in the chart. I then highlight (select) the data > > that > > >> is to be in the chart. I click on the Chart icon. A good column > chart > > >> is > > >> automatically created and the Chart Wizard appears. I can use the > Chart > > >> Wizard to modify what is in the chart such as adding a title. I then > > >> click > > >> Finish which puts the chart in the spreadsheet as an image plus the > > Chart > > >> Wizard closes. The image of the chart can not be modified. What can > be > > >> done so that there is a chant that can be updated? > > >> > > >> On Thu, Dec 22, 2011 at 8:59 PM, Tom Davies<[email protected] > **> > > >> wrote: > > >> > > >> Hi :) > > >>> Have you already got a chart that updates when you update the data? > It > > >>> should do unless you have done the classic of over-complicating > things > > >>> which i'm sure we all do from time-to-time. > > >>> Regards from > > >>> Tom :) > > >>> > > >>> > > >>> --- On Thu, 22/12/11, Walter Hildebrandt<[email protected]> wrote: > > >>> > > >>> From: Walter Hildebrandt<[email protected]> > > >>> Subject: Re: [libreoffice-users] Chart in Calc > > >>> To: [email protected] > > >>> Date: Thursday, 22 December, 2011, 20:34 > > >>> > > >>> Thank you Jay for the help that allowed me to figure out how to solve > > my > > >>> problem. > > >>> > > >>> On Thu, Dec 22, 2011 at 12:50 PM, Walter Hildebrandt< > [email protected] > > >>> > > >>>> wrote: > > >>>> I have inserted the chart onto a spreadsheet and it is now an image. > > Am > > >>>> > > >>> I > > >>> > > >>>> correct that the only way to change the image is to start all over > > again > > >>>> and create a new chart? If so, how can I save the new chart so that > > it > > >>>> > > >>> is > > >>> > > >>>> always available to be changed? I am using WindowsXP. > > >>>> > > >>>> > > >>>> On Thu, Dec 22, 2011 at 11:02 AM, Jay Lozier<[email protected]> > > >>>> wrote: > > >>>> > > >>>> On 12/22/2011 10:01 AM, Walter Hildebrandt wrote: > > >>>>> > > >>>>> I made a chart that had 2 problems. > > >>>>>> > > >>>>>> 1st problem: There was a series of numbers under the columns > that I > > >>>>>> believe were the names of each column. The first column was 1, > the > > >>>>>> second > > >>>>>> column was 2, etc. How do I change the number to the real name I > > >>>>>> want > > >>>>>> to > > >>>>>> use? > > >>>>>> > > >>>>>> Either insert a new row A and enter the names or replace the > place > > >>>>> holders with the correct names in row A. > > >>>>> > > >>>>> > > >>>>> 2nd problem: some of the columns were negative numbers and were > > below > > >>>>>> the > > >>>>>> zero line. This caused the column to be over the number (over the > > >>>>>> > > >>>>> name) > > >>> > > >>>> of > > >>>>>> the column thereby hiding the number/name. How do I correct this? > > >>>>>> > > >>>>>> Where you graphing the numbers? > > >>>>> > > >>>>> > > >>>>> -- > > >>>>> Jay Lozier > > >>>>> [email protected] > > >>>>> > > >>>>> > > >>>>> -- > > >>>>> For unsubscribe instructions e-mail to: > > [email protected]. > > >>>>> > > >>>> ** > > >>> > > >>>> org<users%2Bhelp@global.**libreoffice.org< > > users%[email protected]> > > >>>>> > > > >>>>> Problems? http://www.libreoffice.org/**** > > >>>>> get-help/mailing-lists/how-to-****< > > http://www.libreoffice.org/**get-help/mailing-lists/how-to-**> > > >>>>> unsubscribe/< > > >>>>> > > >>>> http://www.libreoffice.org/**get-help/mailing-lists/how-to-** > > >>> unsubscribe/< > > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/> > > >>> > > > >>> > > >>>> Posting guidelines + more: http://wiki.**documentfoundati** > on.org/**< > > http://documentfoundation.org/**> > > >>>>> Netiquette<http://wiki.**documentfoundation.org/**Netiquette< > > http://wiki.documentfoundation.org/Netiquette> > > >>>>> > > > >>>>> List archive: http://listarchives.**libreoff** > ice.org/global/users/< > > http://libreoffice.org/global/users/> > > >>>>> < > > >>>>> > > >>>> http://listarchives.**libreoffice.org/global/users/< > > http://listarchives.libreoffice.org/global/users/> > > >>> > > > >>> > > >>>> All messages sent to this list will be publicly archived and cannot > be > > >>>>> deleted > > >>>>> > > >>>>> > > >>>>> -- > > >>> For unsubscribe instructions e-mail to: > [email protected]. > > ** > > >>> org <users%[email protected]> > > >>> Problems? > > >>> http://www.libreoffice.org/**get-help/mailing-lists/how-to-** > > >>> unsubscribe/< > > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/> > > >>> Posting guidelines + more: http://wiki.**documentfoundation.org/** > > >>> Netiquette <http://wiki.documentfoundation.org/Netiquette> > > >>> List archive: http://listarchives.**libreoffice.org/global/users/< > > http://listarchives.libreoffice.org/global/users/> > > >>> All messages sent to this list will be publicly archived and cannot > be > > >>> deleted > > >>> > > >>> > > >>> -- > > >>> For unsubscribe instructions e-mail to: > [email protected]. > > ** > > >>> org <users%[email protected]> > > >>> Problems? > > >>> http://www.libreoffice.org/**get-help/mailing-lists/how-to-** > > >>> unsubscribe/< > > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/> > > >>> Posting guidelines + more: http://wiki.**documentfoundation.org/** > > >>> Netiquette <http://wiki.documentfoundation.org/Netiquette> > > >>> List archive: http://listarchives.**libreoffice.org/global/users/< > > http://listarchives.libreoffice.org/global/users/> > > >>> All messages sent to this list will be publicly archived and cannot > be > > >>> deleted > > >>> > > >>> > > >>> > > > -- > > > For unsubscribe instructions e-mail to: [email protected]. > ** > > > org <users%[email protected]> > > > Problems? > http://www.libreoffice.org/**get-help/mailing-lists/how-to-** > > > unsubscribe/< > > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/> > > > Posting guidelines + more: http://wiki.**documentfoundation.org/** > > > Netiquette <http://wiki.documentfoundation.org/Netiquette> > > > List archive: http://listarchives.**libreoffice.org/global/users/< > > http://listarchives.libreoffice.org/global/users/> > > > All messages sent to this list will be publicly archived and cannot be > > > deleted > > > > > > > > > > -- > > For unsubscribe instructions e-mail to: > [email protected] > > Problems? > > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > > List archive: http://listarchives.libreoffice.org/global/users/ > > All messages sent to this list will be publicly archived and cannot be > > deleted > > > > > > -- > > For unsubscribe instructions e-mail to: > [email protected] > > Problems? > > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > > List archive: http://listarchives.libreoffice.org/global/users/ > > All messages sent to this list will be publicly archived and cannot be > > deleted > > > > > > -- > For unsubscribe instructions e-mail to: [email protected] > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted > > > -- > For unsubscribe instructions e-mail to: [email protected] > Problems? > http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette > List archive: http://listarchives.libreoffice.org/global/users/ > All messages sent to this list will be publicly archived and cannot be > deleted > > -- For unsubscribe instructions e-mail to: [email protected] Problems? http://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: http://wiki.documentfoundation.org/Netiquette List archive: http://listarchives.libreoffice.org/global/users/ All messages sent to this list will be publicly archived and cannot be deleted
