Microsoft Office Forums

Go Back   Microsoft Office Forums > >

Reply
 
Thread Tools Display Modes
  #1  
Old 07-11-2016, 12:19 PM
kurite kurite is offline Excel logarithmic scale acting up Mac OS X Excel logarithmic scale acting up Office 2016
Novice
Excel logarithmic scale acting up
 
Join Date: Jul 2016
Posts: 3
kurite is on a distinguished road
Default Excel logarithmic scale acting up

Hello,
Im currently trying to logarithmically plot data that starts at .2 and goes up to 100. For some reason when I turn this into a graph an axis pops up in the middle of the graph. Could someone please help me figure out how to shift it left? I have attached a picture of the problem.
Thank you
Attached Images
File Type: png Screen Shot 2016-07-11 at 2.17.01 PM.png (15.2 KB, 15 views)
Reply With Quote
  #2  
Old 07-12-2016, 08:59 AM
xor xor is offline Excel logarithmic scale acting up Windows 10 Excel logarithmic scale acting up Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Can you please upload the Excel file instead of a picture?
Reply With Quote
  #3  
Old 07-12-2016, 01:03 PM
kurite kurite is offline Excel logarithmic scale acting up Mac OS X Excel logarithmic scale acting up Office 2016
Novice
Excel logarithmic scale acting up
 
Join Date: Jul 2016
Posts: 3
kurite is on a distinguished road
Default

Thank you for your reply! I have attached it to this reply.
Attached Files
File Type: xlsx CT Data and graphs.xlsx (33.2 KB, 9 views)
Reply With Quote
  #4  
Old 07-12-2016, 08:50 PM
xor xor is offline Excel logarithmic scale acting up Windows 10 Excel logarithmic scale acting up Office 2016
Expert
 
Join Date: Oct 2015
Posts: 1,097
xor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to allxor is a name known to all
Default

Select the y-axis.
In the Format Axis dialog click Labels.
In Label Position select Low.
Attached Files
File Type: xlsx CT Data and graphs_2.xlsx (13.6 KB, 13 views)
Reply With Quote
  #5  
Old 07-13-2016, 12:17 AM
kurite kurite is offline Excel logarithmic scale acting up Mac OS X Excel logarithmic scale acting up Office 2016
Novice
Excel logarithmic scale acting up
 
Join Date: Jul 2016
Posts: 3
kurite is on a distinguished road
Default

Thank you so much!
Reply With Quote
Reply



Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel logarithmic scale acting up Tables Acting Up CrossReach Word Tables 10 05-30-2016 03:22 AM
Help with excel 2003, sliding scale commission structure GoldenSlumbers Excel 4 12-14-2012 11:43 PM
fix a scale, or save a view oompa_l Project 0 11-17-2010 01:14 PM
help with formatting my project, particular to issues of scale oompa_l Project 0 11-17-2010 01:10 PM
Where is "scale to fit" option (for charts) in Excel 2007? yinchiao Excel 0 04-08-2010 05:00 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 11:24 AM.


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