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
