Excel log graph with PARTIAL CYCLE



  • 1. help with charting in excel
    I am fairly new at this so sorry if this is an obvious answer. I have created a spreadsheet with the following columns: Payee, Date and Amount Paid. It is simple, functional and working fine. I want to be able to create a chart so that i can easily view the amount paid by each Payee, and the percentage that each Payee represents the total amount of revenue. My problem is this: when i set up the chart, i am using a pie graph, and if Joe Smith plumbing is listed 10 different times(all different dates of course), the pie graph will show Joe Smith plumbing 10 separate times. What is what to do is create a chart where each payee is combined under one header, with a summary of the total amount paid by that payee. This is similar to what u can view in Quicken or Money. Does this make sense? Thanks for everyone's help........AL
  • 2. How do I put multiple graphs on one axis?
    I am doing a project for Chemistry. I need to know how to put two graphs on one axis, and how to create the "bars and whiskers" used to show error. Thanks for your help.
  • 3. Time scale axis should be available in PivotChart Report.
    We should be able to time scale the X axis in PivotChart Reports. Pivot Charts are very usefull. I don't see any good reason to lose the time scale propety while doing a PivotChart Report.
  • 4. Blanks chart as zeros
    Hi All...... I have a Line Chart wherein all cells in my source data that are blank, ( as result of a formula resulting in ""), all plot as ZERO, and I would like them to just be nothing, not charted.......I do not want them interpolated and the one before and the one after just joined......I do not want NA in the cells because I use them for other formulas.........I go to Tools > Options > Chart tab, and no matter which option I select under "Plot empty cells as", I STILL get them plotted as ZERO's...... The only way I've been able to get them to plot correctly is to actually copy a "real" blank cell over to it......is this the only way, please? TIA Vaya con Dios, Chuck, CABGx3
  • 5. custom format
    I need to custom format my Y axis the only on the top number of the scale to appear with the $ sign and the rest of the numbers #,###. Thanks

Excel log graph with PARTIAL CYCLE

Postby makolber » Wed, 11 Feb 2009 06:41:05 GMT

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?



Re: Excel log graph with PARTIAL CYCLE

Postby smartin » Wed, 11 Feb 2009 10:40:09 GMT

It's all about mocking up the scales and values.

Check out Tushar Mehta's PDF "flexible-log-scale" here:

Jon Peltier also gives some ideas here:

RE: Excel log graph with PARTIAL CYCLE

Postby U2hhbmUgRGV2ZW5zaGlyZQ » Thu, 12 Feb 2009 10:23:02 GMT


You are going to have to fake it, because this is the way Excel works.

If this helps, please click the Yes button

Shane Devenshire

Re: Excel log graph with PARTIAL CYCLE

Postby makolber » Sat, 14 Feb 2009 04:19:25 GMT

On Feb 10, 8:23爌m, Shane Devenshire

thats what I was afraid of..

thanks and thanks to the other replier


Similar Threads:

1.How do I make a graph with 2-cycle X 3-cycle log-log graph paper?

I need to create a graph that uses 2-cycle by 3-cycle log-log graph paper.  I 
was told that Excel can be used to do this.  However, after fiddling around 
with it for an hour, I have been unable to figure out how to do it.  Any 

2.how 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?

3.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.


4.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

5.Make a graph with for cycle

6. Cycle thru Graphs

7. How do i create a log graph in excel

8. How to plot semi log graph in Excel?

Return to MS EXCEL


Who is online

Users browsing this forum: No registered users and 43 guest