New To Mac-Forums?

Welcome to our community! Join the discussion today by registering your FREE account. If you have any problems with the registration process, please contact us!

Get your questions answered by community gurus • Advice and insight from world-class Apple enthusiasts • Exclusive access to members-only contests, giveaways and deals

Join today!

 
Start a Discussion
 

Mac-Forums Brief

Subscribe to Mac-Forums Brief to receive special offers from Mac-Forums partners and sponsors

Join the conversation RSS
OS X - Apps and Games Discussion of applications and games available for Mac OS X.

Excel - Modify horizontal axis data


Post Reply New Thread Subscribe

 
Thread Tools
eleonb

 
Member Since: Jul 06, 2010
Posts: 1
eleonb is on a distinguished road

eleonb is offline
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.
Enrique.
Attached Images
File Type: jpg Gráfico F CNTV 2000-2010.jpg (229.4 KB, 4 views)
QUOTE Thanks
shades

 
Member Since: May 20, 2004
Posts: 243
shades is a jewel in the roughshades is a jewel in the rough
Mac Specs: iMac 21" 8GB, MBP 15" 2.5 Penryn, 4 GB/180 GB

shades is offline
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
QUOTE Thanks

Post Reply New Thread Subscribe


« EyeTV Lite and MBP Sleep Issues | Facebook/Flickr Picture Uploading Issues »
Thread Tools

Currently Active Users Viewing This Thread: 1 (0 members and 1 guests)
 
Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off
Forum Jump

Similar Threads
Thread
Thread Starter
Forum
Replies
Last Post
Question about Boot Camp-How to store Data markw10 Running Windows (or anything else) on your Mac 3 09-08-2009 05:11 PM
transfer pc->mac acash0902 Switcher Hangout 10 11-14-2007 12:58 PM
Transfering Movies and Music from a pc to my iBook rollershoer4MAC OS X - Operating System 6 04-21-2007 04:08 AM
Mail to Excel data merge/macro? Small giraffe OS X - Apps and Games 1 01-29-2007 10:55 AM
How to best handle data with Parallels markw10 Running Windows (or anything else) on your Mac 3 11-13-2006 01:29 PM

All times are GMT -4. The time now is 03:49 PM.

Powered by vBulletin
Copyright ©2000 - 2014, Jelsoft Enterprises Ltd.
X

Welcome to Mac-Forums.com

Create your username to jump into the discussion!

New members like you have made this community the ultimate source for your Mac since 2003!


(4 digit year)

Already a member?