Results 1 to 2 of 2
  1. #1

    Member Since
    Jul 06, 2010
    Excel - Modify horizontal axis data
    Hello everybody, nice to meet you all (it's my first post here).

    I need to create a very simple columns graphic in Excel.

    In the horizontal axis, I want to put the years (from 2000 to 2010).
    In the vertical axis, I want to put amounts of money

    As you can see in the JPG attached, in the horizontal axis there are the numbers 1, 2, 3, 4, 5, 6, 7, 8, 9, 10 and 11.

    What should I do to put the years 2000-2010 there?
    I clicked (right button) on those numbers (1, 2, 3...) and tries 2 ptions:
    1. "Dar formato al Eje" (literally "Give format to axis"), but it only offers me changes related to size, font, alignment, etc. I can¡t modify the numbers themselves.
    2. "Select data". It only allows me to change the data related to the amounts of money, not the one related to the years.

    I hope you can help me, thank you very much.
    Attached Images Attached Images

  2. #2

    Member Since
    May 20, 2004
    iMac 21" 8GB, MBP 15" 2.5 Penryn, 4 GB/180 GB
    I think it relates to formatting the numbers in the table as year. Then go back to the first (or second) step in creating the chart, there is an option for ensuring that the x-axis refers to the right one. (I'm doing this from memory of 2 years ago).
    Mellel 3, NWP 2, Scrivener 2.3.1, Tinderbox 5.11.2
    LibreOffice 3.6, Accordance 10.0, Adobe CS4, DTP 2.4.3
    OS X 10.8.2

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Excel Data Sort
    By poc in forum Switcher Hangout
    Replies: 9
    Last Post: 12-19-2013, 04:09 PM
  2. Replies: 0
    Last Post: 11-26-2013, 06:24 AM
  3. how to label axis in excel
    By Oistrakh in forum OS X - Apps and Games
    Replies: 2
    Last Post: 06-20-2009, 01:39 PM
  4. Excel Data Validaton
    By dekalaked in forum OS X - Apps and Games
    Replies: 0
    Last Post: 04-18-2008, 02:02 PM
  5. excel data import on Mac OS X
    By dtkachov in forum OS X - Development and Darwin
    Replies: 9
    Last Post: 12-12-2007, 03:10 AM

Posting Permissions

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