Re: [libreoffice-users] Re: calc

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 <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 i send
> > > 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 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: 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