Chart science class

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Zekni - 26 Feb 2006 18:03 GMT

sorry for the table.

col A from minus 3 till 3 (-3 -3 -2 -2 -1 -1 0 1 1 2 2 3 3

Col B different values f.ex.
- 0,489509284/-0,488875019/-0,327080458/ -0,327080458 / -0,326668095
/ -0,163325963 / -0,163325963 / 0 / 0,165047606 / 0,165047606 / 0,329416007
/ 0,33010255 / 0,494447635 / 0,49507961

Reply to this Message

Tushar Mehta - 26 Feb 2006 19:21 GMT

Select the data in columns A and B. On the Standard Toolbar, click the
Chart Wizard button. Select the XY Chart type (*not* the Line chart).

Signature

Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions

> sorry for the table.
>
[quoted text clipped - 4 lines]
> / -0,163325963 / -0,163325963 / 0 / 0,165047606 / 0,165047606 / 0,329416007
> / 0,33010255 / 0,494447635 / 0,49507961

Reply to this Message

Zekni - 28 Feb 2006 19:00 GMT

Please see the posting to B. Liengme

Thank you for helping

> Select the data in columns A and B. On the Standard Toolbar, click the
> Chart Wizard button. Select the XY Chart type (*not* the Line chart).
[quoted text clipped - 8 lines]
>> 0,329416007
>> / 0,33010255 / 0,494447635 / 0,49507961

Reply to this Message

Zekni - 28 Feb 2006 19:07 GMT

thanks!

how can i arrange for the Y-axis to cut the X-axis in the zeropoint? I'd
like the graph to look like a cross with four quadrants. I, II, III and IV.

At this moment, the Y-axis of the graph cuts the X-axis in the value -3.

> sorry for the table.
>
[quoted text clipped - 4 lines]
> / -0,163325963 / -0,163325963 / 0 / 0,165047606 / 0,165047606 /
> 0,329416007 / 0,33010255 / 0,494447635 / 0,49507961

Reply to this Message