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 <bugquestcontri@online.de>
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 <bugquestcontri@online.de> I am not sure if i understand your problem correct but try to give youand 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 changethe 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 <bugquestcontri@online.de> 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 isend a screenpic of the grey area and the diagram? Sometimes a pic can tell more then text. /Magnus 2012/9/12 MiguelAngel <mariosv@miguelangel.mobi> 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 they-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 aregrateful for that, but IMHO we do not need to be encouraged with these adjectives. Regards. Miguel Ángel. -- For unsubscribe instructions e-mail to: users+help@global.libreoffice. **** ** org <users%2Bhelp@global.****libreof**fice.org < http://libreoffice.org>< users%252Bhelp@**global.**libreoffice.org<http://global.libreoffice.org> <users%**25252Bhelp@global.libreoffice.**org<users%2525252Bhelp@global.libreoffice.org>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: users+help@global.libreoffice. **** ** org <users%2Bhelp@global.**libreof**fice.org <http://libreoffice.org>< users%252Bhelp@**global.libreoffice.org<users%25252Bhelp@global.libreoffice.org>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: users+help@global.libreoffice.** ** org <users%2Bhelp@global.**libreoffice.org<users%252Bhelp@global.libreoffice.org>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: users+help@global.libreoffice.** org <users%2Bhelp@global.libreoffice.org> 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: users+help@global.libreoffice.org 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