i think i get how you mean, if i understand you right using your method will get me one bar on 0, one bar on 5, one bar on 10 etc. I want the bars to be on varius places on the x.axel depending on the chart i am doing, but i want only to see every fifth number on the x-axel line. For example say i want one bar on position 3 on the x-axis but that number shouldnt be shown on the axis,
2012/9/13 rost52 <[email protected]> > Now I understand you. > > Im afraid there is not such a solution you are looking for. Charts in > general are based on a defined data range for the x-axis where all data on > this range are includeded. But you want to make a data selection using a > chart. You real task, the seclection of data (your x-axis data) is one > step before making a chart. > > I am afraid you have to do this manually or using a selecting criteria > which allows you to pick up every 5th set of data and create a new x-axis > with the relevant data on for the y-axis. > > As you have only a data set of 35 and need to select only 7 data sets, I > would simply do this manually. It's a 5 minute job. > > > On 2012-09-13 18:14, a a wrote: > >> ok now to the problrm in detail, In the original file that i want to >> change, i have numbers 1-35 on the x-axel, which all shows in the diagram, >> What i now want is to show only every 5 numbers (0.5.10 etc) so its easier >> to read the chart. in pic Y-axel, i can change max/minimum range , >> intervalls between numbers etc. But when i try the same in x-axel i dont >> get the alternatives to change them, as shows in the pic x-axel, the >> options arent just there. btw i didnt mean that it as malfuncioanal >> program, since its greatly done, but sometimes there are issuses needed to >> improve. >> >> 2012/9/13 rost52 <[email protected]> >> >> I am not sure if i understand your problem correct but try to give you >>> and >>> answer based on my understanding. >>> >>> I you want to change the range for the x-axis you need (also in MS Excel) >>> to change the range and you cannot do this in the window (X-axis) you >>> opened, You must expand you x-axis data range beyond cell A10 to cover >>> the >>> entire range you want to see in the chart. >>> >>> Right click on the chart >>> select data range >>> select data series >>> select categories and expand the range here. You can keep the new cells >>> empty or continue from 10 to where you want to go. >>> >>> LO Calc works correct. The mathematical logic in LO is correct. >>> >>> If my answer does not help you, could you please explain why you want to >>> do what? >>> >>> ROSt >>> >>> On 2012-09-13 17:28, a a wrote: >>> >>> I am now sending 2 pics, first shows how i want it, Where i can change >>>> the >>>> values, (Y-axel) Second file is the malfuncional one? (X-axel) When i do >>>> same thing on another computer i get Y-axel choices in grey, when i try >>>> the >>>> x-axel ,which doesnt allowe me to change the values. On this comp i get >>>> what you see on X-axel pic. Problem remains in other words. >>>> /Magnus >>>> >>>> 2012/9/13 rost52 <[email protected]> >>>> >>>> Yes do so. All addtional information can help. >>>> >>>>> >>>>> On 2012-09-13 15:45, a a wrote: >>>>> >>>>> Ty for all help, but i want to make a bar diagram X/Y wise. Should i >>>>> >>>>>> send >>>>>> a >>>>>> screenpic of the grey area and the diagram? Sometimes a pic can tell >>>>>> more >>>>>> then text. >>>>>> /Magnus >>>>>> >>>>>> 2012/9/12 MiguelAngel <[email protected]> >>>>>> >>>>>> El 12/09/12 16:26, Andreas Säger escribió: >>>>>> >>>>>> Am 12.09.2012 15:35, a a wrote: >>>>>>> >>>>>>> Hey, >>>>>>> >>>>>>>> When i am creating a diagram i can change the numeric values of the >>>>>>>>> y-axel, >>>>>>>>> but when i try the same procedure for the x-axel, the template with >>>>>>>>> options >>>>>>>>> stay grey and imposible to change. How can i do to make this grey >>>>>>>>> area >>>>>>>>> black again so i can change the numeric values? >>>>>>>>> >>>>>>>>> /Magnus östlund >>>>>>>>> >>>>>>>>> >>>>>>>>> Change the chart type to x/y-scatter chart. >>>>>>>>> >>>>>>>>> Ignore Tom Davies. He is the most verbose ignorant on this list. >>>>>>>> >>>>>>>> >>>>>>>> >>>>>>>> Hi Andreas, >>>>>>>> >>>>>>>> please forgive us, I believe, we all learn from you, and we are >>>>>>> grateful >>>>>>> for that, but IMHO we do not need to be encouraged with these >>>>>>> adjectives. >>>>>>> >>>>>>> Regards. >>>>>>> Miguel Ángel. >>>>>>> >>>>>>> >>>>>>> -- >>>>>>> For unsubscribe instructions e-mail to: >>>>>>> [email protected]. >>>>>>> **** >>>>>>> ** >>>>>>> org <users%2Bhelp@global.****libreof**fice.org < >>>>>>> http://libreoffice.org>< >>>>>>> users%252Bhelp@**global.**libreoffice.org<http://global.libreoffice.org> >>>>>>> <users%**[email protected].**org<users%[email protected]> >>>>>>> > >>>>>>> Problems? http://www.libreoffice.org/***** >>>>>>> ***get-help/mailing-lists/how-<http://www.libreoffice.org/******get-help/mailing-lists/how-> >>>>>>> **to-*<http://www.libreoffice.**org/****get-help/mailing-** >>>>>>> lists/how-to-*<http://www.libreoffice.org/****get-help/mailing-lists/how-to-*> >>>>>>> > >>>>>>> *** <http://www.libreoffice.org/******get-help/mailing-lists/how-** >>>>>>> to-****<http://www.libreoffice.org/****get-help/mailing-lists/how-to-****> >>>>>>> <http://www.**libreoffice.org/**get-help/**mailing-lists/how-to-**<http://www.libreoffice.org/**get-help/mailing-lists/how-to-**> >>>>>>> > >>>>>>> unsubscribe/<http://www.****libr**eoffice.org/get-help/**<** >>>>>>> http://libreoffice.org/get-**help/**<http://libreoffice.org/get-help/**> >>>>>>> > >>>>>>> mailing-lists/how-to-******unsubscribe/<http://www.** >>>>>>> libreoffice.org/get-help/****mailing-lists/how-to-****unsubscribe/<http://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/** >>>>>>> <ht**tp://documentfoundation.**org/**<http://documentfoundation.org/**>< >>>>>>> http://documentfoundation.**org/**<http://documentfoundation.org/**> >>>>>>> > >>>>>>> **> >>>>>>> Netiquette >>>>>>> <http://wiki.****documentfoundat**ion.org/****Netiquette<http://ion.org/**Netiquette> >>>>>>> <http://**documentfoundation.org/****Netiquette<http://documentfoundation.org/**Netiquette> >>>>>>> > >>>>>>> <http://**wiki.**documentfoundation.org/****Netiquette<http://wiki.documentfoundation.org/**Netiquette> >>>>>>> <http://wiki.**documentfoundation.org/**Netiquette<http://wiki.documentfoundation.org/Netiquette> >>>>>>> > >>>>>>> List archive: http://listarchives.******libreoff**ice.org/global/** >>>>>>> users/ <http://ice.org/global/users/>**<http://libreoffice.org/** >>>>>>> global/users/ >>>>>>> <http://libreoffice.org/**global/users/<http://libreoffice.org/global/users/> >>>>>>> >> >>>>>>> <http://**listarchives.**libre**office.org/**global/**users/<http://libreoffice.org/**global/**users/> >>>>>>> <h**ttp://listarchives.**libreoffice.org/**global/**users/<http://listarchives.libreoffice.org/**global/users/> >>>>>>> > >>>>>>> >>>>>>> <http://listarchives.**libreof**fice.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%2Bhelp@global.**libreof**fice.org <http://libreoffice.org>< >>>>> users%252Bhelp@**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-*> >>>>> *** >>>>> <http://www.libreoffice.org/****get-help/mailing-lists/how-to-****<http://www.libreoffice.org/**get-help/mailing-lists/how-to-**> >>>>> > >>>>> unsubscribe/<http://www.**libr**eoffice.org/get-help/**<http://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/** >>>>> <ht**tp://documentfoundation.org/** <http://documentfoundation.org/**> >>>>> **> >>>>> Netiquette >>>>> <http://wiki.**documentfoundat**ion.org/**Netiquette<http://documentfoundation.org/**Netiquette> >>>>> <http://**wiki.documentfoundation.org/**Netiquette<http://wiki.documentfoundation.org/Netiquette> >>>>> > >>>>> List archive: http://listarchives.****libreoff**ice.org/global/** >>>>> users/ <http://ice.org/global/users/><http://libreoffice.org/** >>>>> global/users/ <http://libreoffice.org/global/users/>> >>>>> <http://**listarchives.**libreoffice.org/**global/**users/<http://listarchives.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%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] 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
