labo work charting

Z

Zekni

I want to make a linear chart
In col a we have figures between minus 3 en plus 3
In col B we have negative numbers zero, 4895 till positive numbers
zero,49507961.

Former postings came back. Impossible to post it.
 
Z

Zekni

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.
 
B

Bernard Liengme

Click on y-axis; format it; specify where it is to cross x-axis (in your
case 0)
To see four quadrants: change the scales of both axis to a range with
negative minimum values.
best wishes
 
J

Jon Peltier

Did you make an XY chart as Bernard suggested, or a Line chart? By default,
the axes of an XY chart automatically cross at 0,0.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______
 
Z

Zekni

Thank all for the information.
We found a qsollution in the book Graphic for xl (french) by J. Walkenbach
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Trendlines: When They Will Be Generated, And When They Will Not BeFor A Scatter Chart 0
budget chart 3
Chart and Zeros 3
Conditional formatting in a bar chart 4
Trendline Question 1
Regarding Dynamic chart 0
Stacked column charts that cross the X Axis 1
Chart x axis Col A, Y axis Col b 0

Top