#1   Report Post  
Old April 29th 09, 08:10 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Mar 2007
Posts: 9
Default Log Scale Units

Good afternoon. I would like to modify the y-axis units (in log) from 10,
100, 1000 to (for example) 7, 70, 7000. Is this possible? Thanks!

  #2   Report Post  
Old April 29th 09, 08:53 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Feb 2007
Posts: 8,651
Default Log Scale Units

Not in Excel 2003. I believe that the options in Excel 2007 may be
different, but whether that is possible I don't know.
--
David Biddulph

RussG wrote:
Good afternoon. I would like to modify the y-axis units (in log) from
10, 100, 1000 to (for example) 7, 70, 7000. Is this possible? Thanks!



  #3   Report Post  
Old April 29th 09, 09:30 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Jul 2006
Posts: 103
Default Log Scale Units

RussG

You can make a custom axis that will give you what you want.

Here's a link to a how to
http://processtrends.com/pg_charts_custom_axis.htm

Kelly O'Day
http://processtrends.com




"David Biddulph" <groups [at] biddulph.org.uk wrote in message
news
Not in Excel 2003. I believe that the options in Excel 2007 may be
different, but whether that is possible I don't know.
--
David Biddulph

RussG wrote:
Good afternoon. I would like to modify the y-axis units (in log) from
10, 100, 1000 to (for example) 7, 70, 7000. Is this possible? Thanks!





  #4   Report Post  
Old April 29th 09, 11:11 PM posted to microsoft.public.excel.charting
external usenet poster
 
First recorded activity by ExcelBanter: Apr 2009
Posts: 66
Default Log Scale Units

Flexible Log Scale
http://www.tushar-mehta.com/excel/ne...ale/index.html

--
Tushar Mehta
http://www.tushar-mehta.com
Custom business solutions leveraging a multi-disciplinary approach
In Excel 2007 double-click to format may not work; right click and select
from the menu


"RussG" wrote:

Good afternoon. I would like to modify the y-axis units (in log) from 10,
100, 1000 to (for example) 7, 70, 7000. Is this possible? Thanks!



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
Units Produced / (finish time minus start time)=Units Per Hr Gary A Excel Worksheet Functions 1 February 10th 09 01:35 AM
Using "if" function to translate 100 scale into 4.0 scale Robert McN Excel Worksheet Functions 2 May 10th 07 04:57 AM
How to draw chart: log scale on X axis, natural scale on y axis? Pratap D. chavan Charts and Charting in Excel 1 November 16th 06 08:03 AM
units Mindy Excel Discussion (Misc queries) 3 April 20th 05 05:13 PM
Measurement Units Don Bowyer Setting up and Configuration of Excel 2 April 11th 05 08:40 PM


All times are GMT +1. The time now is 01:29 PM.

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

About Us

"It's about Microsoft Excel"

 

Copyright © 2017