How do I eliminate duplicate values on y axis of an Excel chart?

G

Guest

I've created a simple line chart with smoothing. The chart has two data
series. The chart looks fine except that the Y axis has each value
duplicated.
 
J

Jon Peltier

Paul, this might be due to a number format which shows no decimal digits
but a major tick spacing of 0.5. Excel wants ticks at 0, 0.5, 1, 1.5, 2,
2.5, and 3, but the number format forces them to 0, 1, 1, 2, 2, 3, 3.
Change either the tick spacing or the number format to make it right.

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

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

Using the full width of an Excel chart with two Y-axes 2
Positioning x axis at bottom of chart with negative values 5
Chart - Secondary Y-axis with different values/scale 2
One extra x axis item that wont go away - can anyone help? 3
How do I plot multiple LINES vs a Y Axis on a BAR Chart ? 4
Chart distorts secondary axis when the x-axis is logarithmic 5
How do I adjust marker spacing in Excel scatter plot? 1
One Column on 1st y-axis and 3 lines on 2nd y-axis 1

Top