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

  • Thread starter Thread starter Guest
  • Start date Start date
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.
 
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/
_______
 
Back
Top