Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
vp23larry
 
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   Report Post  
Barb R.
 
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   Report Post  
Collins32
 
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?

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Chart Axis Scale Auto Values Moses Bunting Charts and Charting in Excel 1 June 7th 05 11:03 PM
"Scale breaks" required in (Z) axis FH1 Charts and Charting in Excel 3 June 4th 05 06:09 AM
Hiding Values Below Z Axis Minimum Value on Axis Charts TryingToExcel Charts and Charting in Excel 1 February 18th 05 04:55 AM
Challenging Charting C TO Charts and Charting in Excel 0 January 17th 05 07:57 PM
secondary axis scale Kent Smith Charts and Charting in Excel 3 January 4th 05 08:37 PM


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

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

About Us

"It's about Microsoft Excel"