Re: chart on zero

It sounds as though the data are being imported as text, instead of
numbers. To convert them to numbers:

1. Select an empty cell on the worksheet
2. Choose Edit>Copy
3. Select cells A1:A7
4. Choose Edit>Paste Special
5. Select Add, click OK

afdmello wrote:
> I imported data from Business objects to Excel . Then filtered into another
> sheet and made a line chart.
> The problem is all the data was on the zero intersection of X and Y axis.
>
> I resolved it by typing the data again one by one and the plot was OK. Just
> wanted to know why did it happen to been on the zero line

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

Correction to Step 3:

1. Select an empty cell on the worksheet
2. Choose Edit>Copy
3. Select the cells that contain the imported numbers
4. Choose Edit>Paste Special
5. Select Add, click OK

Debra Dalgleish wrote:
> It sounds as though the data are being imported as text, instead of
> numbers. To convert them to numbers:
>
> 1. Select an empty cell on the worksheet
> 2. Choose Edit>Copy
> 3. Select cells A1:A7
> 4. Choose Edit>Paste Special
> 5. Select Add, click OK
>
> afdmello wrote:
>
>> I imported data from Business objects to Excel . Then filtered into
>> another
>> sheet and made a line chart.
>> The problem is all the data was on the zero intersection of X and Y axis.
>>
>> I resolved it by typing the data again one by one and the plot was OK.
>> Just
>> wanted to know why did it happen to been on the zero line

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html

A way to do this in place is to place a 1 in a presently empty unformatted
cell and then copy / paste special multiply against the area with values
that are imported as text.

--
Chris Nicholas, MCSE
"A man may fail many times, but he isn't a failure until he begins to blame
someone else."
--Knox Manning


"Debra Dalgleish" <dsd@contextures.com> wrote in message
news:3F0721CE.30407@contextures.com...
> Correction to Step 3:
>
> 1. Select an empty cell on the worksheet
> 2. Choose Edit>Copy
> 3. Select the cells that contain the imported numbers
> 4. Choose Edit>Paste Special
> 5. Select Add, click OK
>
> Debra Dalgleish wrote:
> > It sounds as though the data are being imported as text, instead of
> > numbers. To convert them to numbers:
> >
> > 1. Select an empty cell on the worksheet
> > 2. Choose Edit>Copy
> > 3. Select cells A1:A7
> > 4. Choose Edit>Paste Special
> > 5. Select Add, click OK
> >
> > afdmello wrote:
> >
> >> I imported data from Business objects to Excel . Then filtered into
> >> another
> >> sheet and made a line chart.
> >> The problem is all the data was on the zero intersection of X and Y
axis.
> >>
> >> I resolved it by typing the data again one by one and the plot was OK.
> >> Just
> >> wanted to know why did it happen to been on the zero line
>
> --
> Debra Dalgleish
> Excel FAQ, Tips & Book List
> http://www.contextures.com/tiptech.html
>

Thank you Debra.I will try it out and let you know. BTW your site is a
blessing to beginners like me.

VAA

Chris -

Did you try Debra's technique? It does Paste Special - Add, but does
not require entering a '1' into a cell somewhere, since a blank cell is
interpreted as zero. And you can also check the Values option in the
top part of the Paste Special dialog to prevent applying unwanted formats.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
http://www.geocities.com/jonpeltier/Excel/index.html
_______

Chris Nicholas wrote:
> A way to do this in place is to place a 1 in a presently empty unformatted
> cell and then copy / paste special multiply against the area with values
> that are imported as text.
>

thank you it worked

VAA

You're welcome, and thanks for coming back and reporting that it worked.

afdmello wrote:
> thank you it worked
>
> VAA

--
Debra Dalgleish
Excel FAQ, Tips & Book List
http://www.contextures.com/tiptech.html