Forums
New posts
Articles
Product Reviews
Policies
FAQ
Log in
Register
What's new
Search
Search
Search titles only
By:
New posts
Menu
Log in
Register
Install the app
Install
Forums
Apple Computing Products:
macOS - Apps and Programs
Excel - Modify horizontal axis data
JavaScript is disabled. For a better experience, please enable JavaScript in your browser before proceeding.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an
alternative browser
.
Reply to thread
Message
<blockquote data-quote="eleonb" data-source="post: 1078909" data-attributes="member: 164501"><p>Hello everybody, nice to meet you all (it's my first post here).</p><p></p><p>I need to create a very simple columns graphic in Excel.</p><p></p><p>In the horizontal axis, I want to put the years (from 2000 to 2010).</p><p>In the vertical axis, I want to put amounts of money</p><p></p><p>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.</p><p></p><p>What should I do to put the years 2000-2010 there?</p><p>I clicked (right button) on those numbers (1, 2, 3...) and tries 2 ptions:</p><p>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.</p><p>2. "Select data". It only allows me to change the data related to the amounts of money, not the one related to the years.</p><p></p><p>I hope you can help me, thank you very much.</p><p>Enrique.</p><p></p><p>[ATTACH=full]13111[/ATTACH]</p></blockquote><p></p>
[QUOTE="eleonb, post: 1078909, member: 164501"] 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. [ATTACH=full]13111[/ATTACH] [/QUOTE]
Verification
Name this item. 🍎
Post reply
Forums
Apple Computing Products:
macOS - Apps and Programs
Excel - Modify horizontal axis data
Top