A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Charts and Charting
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

How to insert X axis scale values next to axis and X axis grid lin



 
 
Thread Tools Display Modes
  #1  
Old June 23rd, 2005, 03:16 PM
vp23larry
external usenet poster
 
Posts: n/a
Default How to insert X axis scale values next to axis and X axis grid lin

I usually create charts with logarithmic scale on the X axis.
I find that using "Scatter" chart function allows this to be done easily.
The final chart inserts the grid ticks but does not insert X axis values (or
even grid lines).
Does anyone know the simple way to achieve what I want?
  #2  
Old June 23rd, 2005, 03:26 PM
Barb R.
external usenet poster
 
Posts: n/a
Default

What is the min/max value for your X axis? As I recall, only axis labels
are put only for each decade, and not for anything in the middle. (shows
0.1, doesn't show 0.2-0.9, shows 1). You can do that, but it requires some
additional work.

"vp23larry" wrote:

I usually create charts with logarithmic scale on the X axis.
I find that using "Scatter" chart function allows this to be done easily.
The final chart inserts the grid ticks but does not insert X axis values (or
even grid lines).
Does anyone know the simple way to achieve what I want?

  #3  
Old June 23rd, 2005, 03:45 PM
Collins32
external usenet poster
 
Posts: n/a
Default

Min is 10, max is 1000. major axis values of 10, 100, 1000 is desiredalong
with major grid lines.

"vp23larry" wrote:

I usually create charts with logarithmic scale on the X axis.
I find that using "Scatter" chart function allows this to be done easily.
The final chart inserts the grid ticks but does not insert X axis values (or
even grid lines).
Does anyone know the simple way to achieve what I want?

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Using dates for x-axis values as string instead of creating a scale cs_weirdo Charts and Charting 0 June 16th, 2005 08:03 PM
Chart X axis values are wrong! Sorin Setting Up & Running Reports 0 December 17th, 2004 10:05 PM
Excel Charts - Value Y axis scale - locking values to preventchanging Andy Pope Charts and Charting 0 June 22nd, 2004 04:31 PM
average, eliminating zero values Chris Worksheet Functions 6 May 14th, 2004 11:36 PM
Newbie: How to I reverse X and Y axis values? Larry Woods Charts and Charting 3 September 27th, 2003 05:16 AM


All times are GMT +1. The time now is 10:10 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.