How do i create a log graph in excel



  • 1. Bar Graphing Ranges ie Temps?
    Hi Luke, Expand a bit. Give us an example of the data and what you want the chart to show, Bernard "Luke" < XXXX@XXXXX.COM > wrote in message news:06fe01c3878b$c3354d00$ XXXX@XXXXX.COM ... > I need to figure out how to graph rangesusing a bar > chart. I need to trakc values with a bar from 5 to 7. > Not 0 to 5 and 0 to 7. Any help is appreciated.
  • 2. Columns on 2 Axes
    I know that in MS Excel under Custom types of Charts you get "Lines on 2 Axes", this is perfect but I want to see BARS and not lines. Can anybody assist me or tell me what to do. Yes I know there is the option for "Line Column on 2 Axes", BUT this is not going to work for what we want to do (Me and My Boss) PLEASE help orr assist. Thanx Dirk
  • 3. Subset Charts
    Is there any way to produce a "circle inside a circle" chart that is proportioned correctly? I am using this to show core and fringe proportions of total employment (not a pie chart).
  • 4. Step/Staircase Charts
    Hello, Could someone please adcise me how to get staircase charts to work? I have done these in the past with the XY scatter charts (and without using error bars), but I cant get it to work now. My sample date would be something like 01-Oct-03 4.75 08-Oct-03 5.00 05-Nov-03 5.00 03-Dec-03 5.25 04-Feb-04 5.25 03-Mar-04 5.00 Regards

How do i create a log graph in excel

Postby TWFyayBCZW5uZXR0 » Fri, 10 Dec 2004 02:05:06 GMT

Is there any way of creating a log graph within excel?

Re: How do i create a log graph in excel

Postby Barb Reinhardt » Fri, 10 Dec 2004 02:17:09 GMT

On the Format Axis menu, there is an option to use a Logarithmic scale on
the scale tab.

Re: How do i create a log graph in excel

Postby Jon Peltier » Fri, 10 Dec 2004 03:14:21 GMT

Keep in mind that only an XY Scatter chart offers this option for the X axis.

- Jon
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions

Similar Threads: can i graph with log-log scales?

I wish to graph pricing curves using a logarithmic x-axis.  Is this possible 
with Excel?  If so, how do I do it?

2.Trying to make a log-log graph

I'm trying to make a log-log graph using excel, and I can't figure out how to 
change the x axis to log scale. Its not an option in the "format axis" 
window, and I have no clue how to go about doing it. I'm using Excel 2000, 
and the data range for the x axis is from 9.35E-4 to 2.40E-3.


3.Bar Graphs, Semi-Log Graphs

Dear Friends,

I have the Millennium 2000 edition of Excel and I can't 
figure out how to make
a) bar graphs of one variable vs. time. (all the options 
seem to be for two variables.)
b) semi-logarithmic graphs.

With my previous computer I had the Excel that went with 
Windows 95, and the Chart Wizard had options you could 
check for either one variable bar graphs or for semi-log 
graphs.  In the Millennium 2000 I don't find either of 
these options with the Chart Wizard.

Question No. 1:  At the bookstore I see an expensive 
upgrade I can purchase to upgrade Millennium to Windows 
XP.  Does this upgrade have the charting capabilities at 
least as good as those of Windows 95, or are they degraded 
to the level of those in Millennium 2000?

Question No. 2:  Why would Microsoft degrade a very useful 
Chart Wizard in Windows 95 to the much less useful one of 
Millennium 2000?

With thanks and best wishes, I am,


Albert A. Bartlett
Professor Emeritus of Physics
University of Colorado at Boulder, 80309-0390

4.Excel log graph with PARTIAL CYCLE

I want a x axis log plot with the range of x from say 20 to 200.

I know how to create the log grapgh, no problem there, but Excel seems
to require full cycles..

in other words I can do 10 to 1000,

 but not 20 to 1000
 and not 10 to 200
 and not 20 to 200.

Any ideas?



5.How to plot semi log graph in Excel?

I want to plot a semi log plot in excel along with grid lines. Can anyone 
tell how to do?

6. Excel should have semi-log graph plotting

7. how do i get a log log plot without taking log

8. Create a macro to create excel line graph with coloured pointers and data lables

Return to MS EXCEL


Who is online

Users browsing this forum: No registered users and 77 guest