Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I eliminate duplicate values on y axis of an Excel chart?
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. |
#2
|
|||
|
|||
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/ _______ Paul wrote: 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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hiding Values Below Z Axis Minimum Value on Axis Charts | Charts and Charting in Excel | |||
interchangine catergory and values axis | Charts and Charting in Excel | |||
How do you find duplicate values in excel- 2 columns of numbers | Excel Discussion (Misc queries) | |||
catergory on the X axis; values on the Y axis | Charts and Charting in Excel | |||
Removing duplicate values in a column | Excel Worksheet Functions |