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
