Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-07-2021, 11:07 PM
ketanco ketanco is offline How to adjust horizontal axis Windows 7 64bit How to adjust horizontal axis Office 2010 64bit
Expert
How to adjust horizontal axis
 
Join Date: Dec 2011
Posts: 279
ketanco is on a distinguished road
Default How to adjust horizontal axis

Hello
I made a chart for costs from january to december for 12 months. But on the chart instead of months in horizontal axis it displays numbers from 1 to 12. How can I make them write month names instead of numbers from 1 to 12?
Reply With Quote
  #2  
Old 07-07-2021, 11:28 PM
Pecoflyer's Avatar
Pecoflyer Pecoflyer is offline How to adjust horizontal axis Windows 7 64bit How to adjust horizontal axis Office 2010
Expert
 
Join Date: Nov 2011
Location: Brussels Belgium
Posts: 2,766
Pecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant futurePecoflyer has a brilliant future
Default

Please post a sample sheet. Thx
Reply With Quote
  #3  
Old 07-08-2021, 12:13 AM
wiganken wiganken is offline How to adjust horizontal axis Windows 10 How to adjust horizontal axis Office 2019
Expert
 
Join Date: Jul 2018
Posts: 279
wiganken will become famous soon enough
Default

If you wrote the months as text then they should show as text. See photo of my example.
Attached Images
File Type: png Excel Months.png (28.9 KB, 15 views)
Reply With Quote
  #4  
Old 07-08-2021, 12:43 AM
ketanco ketanco is offline How to adjust horizontal axis Windows 7 64bit How to adjust horizontal axis Office 2010 64bit
Expert
How to adjust horizontal axis
 
Join Date: Dec 2011
Posts: 279
ketanco is on a distinguished road
Default

Here is the graph
Yes I wrote months in text
I dont know why they appear as number in horizontal axis
I want to see months from january to december on horizontal axis
Attached Images
File Type: jpg ooo.jpg (45.9 KB, 17 views)
Reply With Quote
  #5  
Old 07-08-2021, 12:57 AM
wiganken wiganken is offline How to adjust horizontal axis Windows 10 How to adjust horizontal axis Office 2019
Expert
 
Join Date: Jul 2018
Posts: 279
wiganken will become famous soon enough
Default

Is it possible that you did not select the 'months' column when you created the chart and this may force Excel to use numbers instead? Maybe you only selected the 'Cost' column?


Try recreating the chart making sure both Month and Cost columns are selected.
Reply With Quote
  #6  
Old 07-08-2021, 01:28 AM
ketanco ketanco is offline How to adjust horizontal axis Windows 7 64bit How to adjust horizontal axis Office 2010 64bit
Expert
How to adjust horizontal axis
 
Join Date: Dec 2011
Posts: 279
ketanco is on a distinguished road
Default

ok yes it worked. thanks
and another thing. how can I get rid of the "$-" in the bottom of vertical axis?
ANd also how can I make scale of vertical axis larger?
Reply With Quote
  #7  
Old 07-08-2021, 02:06 AM
wiganken wiganken is offline How to adjust horizontal axis Windows 10 How to adjust horizontal axis Office 2019
Expert
 
Join Date: Jul 2018
Posts: 279
wiganken will become famous soon enough
Default

To remove the $ from the chart try deleting the $ column.


I don't know about the scaling but will check into it when I have time or maybe some else will help on that aspect.
Reply With Quote
  #8  
Old 07-08-2021, 05:23 AM
ketanco ketanco is offline How to adjust horizontal axis Windows 7 64bit How to adjust horizontal axis Office 2010 64bit
Expert
How to adjust horizontal axis
 
Join Date: Dec 2011
Posts: 279
ketanco is on a distinguished road
Default

$ is not a separate column it is how numbers in second column is written - in dollar format
ok
Reply With Quote
  #9  
Old 07-08-2021, 04:10 PM
Marcia's Avatar
Marcia Marcia is offline How to adjust horizontal axis Windows 10 How to adjust horizontal axis Office 2019
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

The $- at the bottom is your first scale, representing zero dollar, next is $1,000.00. Try setting your minimum amount to $1,000.00. You can also adjust the vertical scales in the same setting.
Reply With Quote
  #10  
Old 07-09-2021, 12:24 AM
wiganken wiganken is offline How to adjust horizontal axis Windows 10 How to adjust horizontal axis Office 2019
Expert
 
Join Date: Jul 2018
Posts: 279
wiganken will become famous soon enough
Default

Another way to change the vertical scale is to click on the chart to reveal its eight 'handles'. These are small circles, one at each corner and one in the centre of each side. Click and drag on either the top or bottom centre handle to increase/decrease the chart height.


I also notice that your currency data column doesn't look right? I would expect to see $4500 and not $ 4500 (with large space between the $ and 4). That's why I thought the $ was in a column of its own so how did this large space happen?
Reply With Quote
  #11  
Old 07-09-2021, 01:12 AM
Marcia's Avatar
Marcia Marcia is offline How to adjust horizontal axis Windows 10 How to adjust horizontal axis Office 2019
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Maybe the amount was formatted in Accounting, not Currency.
Reply With Quote
  #12  
Old 07-09-2021, 02:08 AM
wiganken wiganken is offline How to adjust horizontal axis Windows 10 How to adjust horizontal axis Office 2019
Expert
 
Join Date: Jul 2018
Posts: 279
wiganken will become famous soon enough
Default

I tried using Accounting format and the cells on my PC show $4,500 (no spaces) and not $ 4,500. Very odd behaviour! I still can't see how the OP's photo shows the $ so far away from the amount figures without it being in a column of its own.


Ah well it seems the OP may be sorted now.
Reply With Quote
  #13  
Old 07-09-2021, 03:50 AM
Marcia's Avatar
Marcia Marcia is offline How to adjust horizontal axis Windows 10 How to adjust horizontal axis Office 2019
Expert
 
Join Date: May 2018
Location: Philippines
Posts: 526
Marcia has a spectacular aura aboutMarcia has a spectacular aura aboutMarcia has a spectacular aura about
Default

Quote:
Originally Posted by wiganken View Post
I still can't see how the OP's photo shows the $ so far away from the amount figures without it being in ...
I use the Accounting format in the Financial Statements that I prepare. The wider the column width, the farther the currency symbol is to the number.
Reply With Quote
  #14  
Old 07-09-2021, 04:08 AM
wiganken wiganken is offline How to adjust horizontal axis Windows 10 How to adjust horizontal axis Office 2019
Expert
 
Join Date: Jul 2018
Posts: 279
wiganken will become famous soon enough
Default

Yes, you are right. I've never used Accounting format, only Currency. Thank you for explaining.
Reply With Quote
Reply

Thread Tools
Display Modes


Similar Threads
Thread Thread Starter Forum Replies Last Post
how to move horizontal axis labels on bar graph gib65 Excel 2 10-31-2017 08:49 PM
Pre-set visible horizontal axis UHD PowerPoint 0 10-04-2017 06:58 AM
my excel 2010 line chart has a secondary axis. Its horizontal date axis is incorrect. jalea148 Excel 3 01-06-2017 09:04 AM
How to adjust horizontal axis How to add a NEW varaible to a secondary horizontal axis Boyko Excel 1 03-02-2015 01:09 PM
Secondary Horizontal Axis excel 2013 darksupernova Excel 0 02-27-2013 08:46 AM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:44 PM.


Powered by vBulletin® Version 3.8.11
Copyright ©2000 - 2024, vBulletin Solutions Inc.
Search Engine Optimisation provided by DragonByte SEO (Lite) - vBulletin Mods & Addons Copyright © 2024 DragonByte Technologies Ltd.
MSOfficeForums.com is not affiliated with Microsoft