+ Reply to Thread
Results 1 to 2 of 2

Y Axis Counting Decimals

  1. #1
    Forum Contributor
    Join Date
    08-23-2013
    Location
    Alberta, Canada
    MS-Off Ver
    Excel 365
    Posts
    166

    Y Axis Counting Decimals

    I have a graph I am using to display units (y-axis) that sometimes can be in the range of 10-30 (which are no problem), and sometime 1-5. With the count that is 1-5 it shows 1,1,2,2,3,3. I am looking to just show whole numbers 1,2,3 - at the same time not making too many ticks for when a case comes with 10-30 units. I am replicating the graph so some cases may have 1-5 units and others 10-30 units on the y-axis.


    I want to adjust the settings so i can replicate the graph and the y-axis doesn't have decimals for those lower ranges 1-5.

    Hope this makes sense, thanks.

  2. #2
    Forum Guru
    Join Date
    04-13-2005
    Location
    North America
    MS-Off Ver
    2002/XP and 2007
    Posts
    15,811

    Re: Y Axis Counting Decimals

    It should be as easy as going into the format axis dialog and changing the min, max, major unit, and/or minor unit. http://www.dummies.com/how-to/conten...007-chart.html

    Is there more to the question than that?
    Quote Originally Posted by shg
    Mathematics is the native language of the natural world. Just trying to become literate.

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 2
    Last Post: 02-13-2015, 07:36 AM
  2. [SOLVED] Two Y Axis's One X, Chart Data not in sync with X axis between Y axis's
    By MJSlattery in forum Excel Charting & Pivots
    Replies: 1
    Last Post: 12-08-2013, 12:08 AM
  3. [SOLVED] Bar Graph With 2 Axis - Bars On The Primary Axis Overlap Bars On The Secondary Axis
    By Variablez in forum Excel Charting & Pivots
    Replies: 4
    Last Post: 03-11-2013, 08:38 AM
  4. Replies: 8
    Last Post: 02-12-2009, 10:12 AM
  5. [SOLVED] counting decimals
    By Warren Smith in forum Excel General
    Replies: 2
    Last Post: 08-27-2005, 12:05 PM
  6. [SOLVED] How to insert X axis scale values next to axis and X axis grid lin
    By vp23larry in forum Excel Charting & Pivots
    Replies: 2
    Last Post: 06-23-2005, 11:05 AM
  7. counting instances of decimals
    By Eden in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-21-2005, 11:23 AM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1