labo work charting

  • Thread starter Thread starter Zekni
  • Start date Start date
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.
 
Make an XY chart
Then tell us what the question is
best wishes
 
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.
 
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
 
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/
_______
 
Thank all for the information.
We found a qsollution in the book Graphic for xl (french) by J. Walkenbach
 
You must log in or register to reply here.

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

budget chart 3
Conditional formatting in a bar chart 4
Stacked column charts that cross the X Axis 1
Chart and Zeros 2
Bar chart with no zero columns 4
"circular" concentric charts - like a pilot's plotting/nav computer 1
Pivot Tables to Charts 2
Waterfall chart difficulties 1

Back
Top