Charts - To change axis intervals/display

G

Giri

Hi,

Suppose my current chart has intervals of 0.00, 0.50,
1.00, 1.50, 2.00, 2.50 & so on across the y-axis based on
data that i have. Can i set the display or show values for
y-axis only as 0, 1, 2, 3, 4 & so on ? OR Is it possible
to set the numeric gap for the y-axis when drawing a chart?

Your help in this regard is appreciated. Thank You.

Regards,
Giri
 
G

Giri

Hi,

I seem to have got the solution. It is FormatAxis -->
Scale. This can be invoked by selecting the axis select --
right click on the axis to be changed.
Click to expand...

Thank You.

Regards,
Giri
 

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

Value on horizontal axis 2
Excel Charts 1
Line chart - Change the Axis round 1
Changing the Y axis on a column chart 1
Reversing Dates Sequence along X axis in a chart 3
How to draw a graph with the X axis as a time line of date. 4
Non-Numeric values in X axis of a scatter chart 1
Data labels along below x axis when y axis has negative values 1

Top