Log-log charts #2

Hi,

I'm using Excel 2002 and am trying to create a simple log-log plot.  Making
the y-axis logarithmic is easy - it's a check-box option under Scale tab of
the Format Axis dialog.  But for the X axis the dialog does not have that
option.  My XY data is valid (all positive values).  There's web sites that
say you can do this (e.g.
http://cstl-cst.semo.edu/venezian/Utilities/graphs.htm).  Why doesn't my
Excel support it???

Any help is appreciated.

Walt


0
4/26/2004 8:26:18 PM
excel.charting 18370 articles. 0 followers. Follow

5 Replies
939 Views

Similar Articles

[PageSpeed] 40

Hi Walt,

Sounds like your chart maybe a line chart (x-axis is category) instead 
of true xy scatter.
Right click the chart and choose chart type...
Make sure its a xy-scatter and then you should be able to specify Log 
scale the same way you have for the y-axis.

Cheers
Andy

Walt Welton-Lair wrote:

> Hi,
> 
> I'm using Excel 2002 and am trying to create a simple log-log plot.  Making
> the y-axis logarithmic is easy - it's a check-box option under Scale tab of
> the Format Axis dialog.  But for the X axis the dialog does not have that
> option.  My XY data is valid (all positive values).  There's web sites that
> say you can do this (e.g.
> http://cstl-cst.semo.edu/venezian/Utilities/graphs.htm).  Why doesn't my
> Excel support it???
> 
> Any help is appreciated.
> 
> Walt
> 
> 

-- 

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
0
andy9699 (3616)
4/26/2004 8:44:02 PM
Never mind...

I just discovered that you can do it if you set the chart type to scatter
plot.  Linear plots don't support it.  You can then change the data series
formatting so that it looks like a linear plot.

So why exactly does Excel not support logarithmic X axes in its linear chart
type?  It's very misleading the way it's set up.


"Walt Welton-Lair" <RemoveThiSweltonwRemoveThiS@mae.cornell.edu> wrote in
message news:uj916y8KEHA.2012@TK2MSFTNGP11.phx.gbl...
> Hi,
>
> I'm using Excel 2002 and am trying to create a simple log-log plot.
Making
> the y-axis logarithmic is easy - it's a check-box option under Scale tab
of
> the Format Axis dialog.  But for the X axis the dialog does not have that
> option.  My XY data is valid (all positive values).  There's web sites
that
> say you can do this (e.g.
> http://cstl-cst.semo.edu/venezian/Utilities/graphs.htm).  Why doesn't my
> Excel support it???
>
> Any help is appreciated.
>
> Walt
>
>


0
4/26/2004 8:46:00 PM
Thanks - that's what I just discovered.

"Andy Pope" <andy@andypope.info> wrote in message
news:e3dv888KEHA.628@TK2MSFTNGP11.phx.gbl...
> Hi Walt,
>
> Sounds like your chart maybe a line chart (x-axis is category) instead
> of true xy scatter.
> Right click the chart and choose chart type...
> Make sure its a xy-scatter and then you should be able to specify Log
> scale the same way you have for the y-axis.
>
> Cheers
> Andy
>
> Walt Welton-Lair wrote:
>
> > Hi,
> >
> > I'm using Excel 2002 and am trying to create a simple log-log plot.
Making
> > the y-axis logarithmic is easy - it's a check-box option under Scale tab
of
> > the Format Axis dialog.  But for the X axis the dialog does not have
that
> > option.  My XY data is valid (all positive values).  There's web sites
that
> > say you can do this (e.g.
> > http://cstl-cst.semo.edu/venezian/Utilities/graphs.htm).  Why doesn't my
> > Excel support it???
> >
> > Any help is appreciated.
> >
> > Walt
> >
> >
>
> -- 
>
> Andy Pope, Microsoft MVP - Excel
> http://www.andypope.info


0
4/26/2004 8:47:50 PM
Walt -

You need to make an XY Scatter chart. In an XY Scatter chart, the X 
values are treated as numerical variables, and therefore they have logs. 
In a Line chart, the X values are treated as non numerical categories. 
Aside from their treatment of the X variable, Scatter and Line charts 
are nearly identical: series can be formatted the same way in either 
type of chart, and the other chart elements also behave the same.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Walt Welton-Lair wrote:

> Hi,
> 
> I'm using Excel 2002 and am trying to create a simple log-log plot.  Making
> the y-axis logarithmic is easy - it's a check-box option under Scale tab of
> the Format Axis dialog.  But for the X axis the dialog does not have that
> option.  My XY data is valid (all positive values).  There's web sites that
> say you can do this (e.g.
> http://cstl-cst.semo.edu/venezian/Utilities/graphs.htm).  Why doesn't my
> Excel support it???
> 
> Any help is appreciated.
> 
> Walt
> 
> 

0
DOjonNOT (619)
4/26/2004 8:52:13 PM
Walt -

To manny who make charts, a scatter chart is a chart with markers only, 
while a line chart has points connected by lines. In Excel, the 
distinction is made between scatter charts with numerical category 
values (X data), and line charts with categorical X values. These 
categorical labels have no numerical values (other than perhaps the 
ordinal numbers 1, 2, 3,...), but instead are merely labels for the 
axis, no matter what value appears to be in the label.

It's plenty confusing at first, though it makes sense after you think 
about it. Too bad they didn't come up with better terminology.

- Jon
-------
Jon Peltier, Microsoft Excel MVP
Peltier Technical Services
Tutorials and Custom Solutions
http://PeltierTech.com/
_______

Walt Welton-Lair wrote:

> Never mind...
> 
> I just discovered that you can do it if you set the chart type to scatter
> plot.  Linear plots don't support it.  You can then change the data series
> formatting so that it looks like a linear plot.
> 
> So why exactly does Excel not support logarithmic X axes in its linear chart
> type?  It's very misleading the way it's set up.
> 
> 
> "Walt Welton-Lair" <RemoveThiSweltonwRemoveThiS@mae.cornell.edu> wrote in
> message news:uj916y8KEHA.2012@TK2MSFTNGP11.phx.gbl...
> 
>>Hi,
>>
>>I'm using Excel 2002 and am trying to create a simple log-log plot.
> 
> Making
> 
>>the y-axis logarithmic is easy - it's a check-box option under Scale tab
> 
> of
> 
>>the Format Axis dialog.  But for the X axis the dialog does not have that
>>option.  My XY data is valid (all positive values).  There's web sites
> 
> that
> 
>>say you can do this (e.g.
>>http://cstl-cst.semo.edu/venezian/Utilities/graphs.htm).  Why doesn't my
>>Excel support it???
>>
>>Any help is appreciated.
>>
>>Walt
>>
>>
> 
> 
> 

0
DOjonNOT (619)
4/27/2004 3:29:31 PM
Reply:

Similar Artilces:

Data Series Labels in Area Chart
Hello- I'm trying to create a combination chart; one data series in an area chart, and three in line format. Got the chart created, but the data series labels for the area chart show up in the middle of the area, which looks awkward. Is there anyway to move them closer to the top edge of the area plot? I don't seem to find any options for moving the labels in an area chart. Hi, The data labels for the area series have no options for alignment. Add another line series to the chart based on the area data. This has the options to align data labels. You can format the line seri...

Advance Security #2
I'm using GP 7.0 on a Citrix Server When I try to user Advance Security it's telling me that some one else is using it and no one is using Advance Security. How can I fix this problem? Also at times while using Advance Security I will get log out of GP. Do anyone know why this happens? Thanks, Try this: Great Plains/Great Plains Standard on Microsoft SQL Server/MSDE 1. Make a backup of the DYNAMICS database. 2. Execute the following script in Query Analyzer or the Support Administrator Console: Delete DYNAMICS..SY00801 "KBrown" wrote: > I'm using GP ...

How do I get rid of header/footer on page 2 of document?
the help menu says to click on header/footer, then toggle to new, then highlight text you want to get rid of, then hit delete key. I did that but all the header/footers throughout the document got deleted. How do I get to keep only the header/footer on page 1? TIA Fay Please see reply to your previous duplicate question. -- Suzanne S. Barnhill Microsoft MVP (Word) Words into Type Fairhope, Alabama USA http://word.mvps.org "Fay Zeller" <fayzee@optonline.net> wrote in message news:4b16f1f1$0$31281$607ed4bc@cv.net... > the help menu says to click...

Copy Pivot Chart
Does anyone know how to copy a pivot chart and paste only its values? You can copy/paste special/value as you would any other cell values. However, you need to navigate from "edit" on the tool bar. These options are not available for a pivot table via the right click. "TK" wrote: > Does anyone know how to copy a pivot chart and paste only its values? ...

How do I add a data series in a combination chart in PPT 2003?
I have a combination bar/line chart showing gross revenues and passengers by month over a 3-year period. The gross revenues are bars on the primary y-axis and passengers are lines on the secondary y-axis. I am trying to add gross revenues and passengers for CY2010. I am able to add a data series for the passengers, but when I try to add a data series for the gross revenues, the chart treats it as a series on the secondary axis as a line. How do I add the series as a bar on the primary axis, or alternatively, change the series from a line on the secondary axis to a bar on th...

Badmail folder #2
Please can somebody tell me how to read the bounced email in the badmail folder, I have tried associating them with outlook and they mail messages are just empty, I have even tried renaming to .eml. There are three different extension, which one should I be looking at for email incomming to a bad address, thank you You should be able to open these files in Notepad and check the email header Regards. Philip wrote: > Please can somebody tell me how to read the bounced email > in the badmail folder, I have tried associating them with > outlook and they mail messages are just e...

2 questions regarding count formula
If I have the following data A B C 1 Personnel group type p't number 2 Melinda 1 4 3 Sean 1 5 4 Melinda 1 6 5 Sean 2 30 6 Fay 3 8 7 Melinda 1 32 1. How shall I contruct my formula to count the number of data that satisfy the following criteria: 1. personnel is Melinda 2. group type is 1 3. ...

Outlook 2003
Here's the problem: Every tiem I open Outlook it displays an error message that my Exchange server is unavailable. What I know: I know the Exchange server is up & running without any problems. The desktop computer is on the network and can browse and ping different devices. DNS is resolving names properly. Does anyone know what I can do to fix this? ...

how I can sum or subtract 2 or 3 field in access in any record
hi I want know that why there is NOT any relationship between access and excel and how I can sum and subtract 2 or 3 filds in access in any record thanks hadi_khodaparast@yahoo.com Hello Hadi - I'm not sure I understand exactly what you are asking, but Excel is *not* a 'front end' for an Access database. You can use Excel to query the db & copy Access data into a workbook in several ways. That copy of the data can be used for calculations, but the data *doesn't* get changed in the Access file. Although the modified results can be imported to Access it may very well be t...

Org Charts
I have 5 people that report to the same person and currently they all show on the same row, the owner of the company wants the 3 VPs to show directly underneath him but the remaining two to have their line drop down lower than the 3 VP's. IS there a way to do this? Everytime I try it just makes the box bigger for all of them. Hi, Are you doing this in Excel? Which version? Which tool the Diagram tool or the AutoShapes tools? -- Thanks, Shane Devenshire "rgoldberg" wrote: > I have 5 people that report to the same person and currently they all show on > the sam...

comparing componants of tables #2
I cannot easily compare data elements of comparative data. Here's what I mean, john smith bill jones mary Dee observation 1 observation 2 observation 1 observation 2 observation 1 observation 2 weight 160 155 128 119 120 129 belt size 40 38 29 28 25 26 shoe size 12 11 8 9 8 9 But, I ha...

My (final) 2 cents on continuous form design
Some days ago I started a thread on this forum regarding the design of a continuous form to be used to show all of the records filled in a table and giving the possibility to the user to select each row and perform action on the record (mine is retrieving all of the information from the record and use them to fill another form where the data can be edited). This can be easily accomplished through regular continuous form but I stated few requirements: a) the form should be unbound and the data should be not editable; b) I hate having that crappy effect of all the text selected whe...

Operation Failed! #2
Hello, Using Outlook 2002 and when attempting to Send/Receive mail I get an immediate error message saying "Operation Failed!" There's no attempt by the program, no timing out - the error msg. pops up immediately. I've tried deleting and reinstalling the mail account to no avail. I'm stumped! Please help... Thanks in advance! -Lee Create a completely new profile to see if that solves the issue and also suggest running a Detect and Repair on the program. If neither issues work create a new .ost file by doing a search and renaming it to .ost1 or something to ...

formatting or moving a radar chart's axis labels
I am attempting to change the orientation of a radar chart's axis labels. Its orientation seems locked in place immediately to the left of the 360=B0 gridline. I would like the ability to display the axis labels directly over the range rings and along other gridlines, such as 180=B0 or 270=B0. With other charts, the formatting option allows one to select "high", "low", or "next to axis" to change the position of the axis. This maneuver seems to have no affect whatsoever on a radar chart. As a final resort, I suppose I could turn the axis labels off...

Outlook 2003 very slow #2
Several people in my office including myself have upgraded to Office 2003 over the last several weeks. Many of us have begun experiencing performance problems. For example, I will click on another message in order to view it in the task pane, and then Outlook will sit there for ages before it gets displayed. The larger the message (including attachments), the worse the problem. However, even a message that is small with only a 100KB attachment seems to take 20-30 seconds to respond... this was never the case before. Also deleting a message takes ages. I checked the Exchange 2000 SP3 server th...

Naming a chart object
When charts are created they are named "chart 1", "chart 2", and so on I need to name a chart in order to update it from vba, but when select the chart I cannot click in the name box? Help -- Message posted from http://www.ExcelForum.com Hi martinu, To rename a chart, hold the shift key down and select the chart. This selects the chart object instead of the chart area. You can then rename as usual. -- Ed Ferrero http://edferrero.m6.net Thanks Ed, so simple when you know how. --- Message posted from http://www.ExcelForum.com/ ...

Comparing 2 Lists
Lets say that I have a Sales Forecast list with Customer Name and Sale Status columns. The number of registries in this list changes every da (some new sales opportunities are created and some are deleted). Questions are: 1) How can I create a report to compare two days in order to know whic registries have been added and/or deleted? 2) If I want to know if a Sales Status have changed from one day t another, what is the best way to do it? Tks!! -- inomat ----------------------------------------------------------------------- inomata's Profile: http://www.excelforum.com/member.php?act...

Business Portal 2.5 #3
Receive error: The Business Portal data in the database you selected is not compatible with this version of the Business Portal. You must select a different database before continuing Hi What version of Great Plains are you using? -- Regards James[MVP] Visit MBS Blog Central http://mbscentral.blogs.com "thebigo9" <thebigo9@discussions.microsoft.com> wrote in message news:491CA957-2C6C-4440-BFD6-CACE94C06584@microsoft.com... > Receive error: The Business Portal data in the database you selected is > not > compatible with this version of the Business Portal. Yo...

Creating users with ADC / Exchange 5.5 #2
I installed the ADC on my DC and created all connection agreements. Now I can go into ADUC and create new users, but I don't see a mailbox being created for a user. Should that happen? If so, how long should it take? I tried sending an email to the user I created and the mailbox isn't found. Also, there are no Exchange tabs for the users name. ...

merged cells and creating charts
I have tried to create a chart with data that is in merged cells where I have put in a formula to calculate the average of 4 cells in the row above. When I create the chart, it recognizes all 4 of the merged cells. So the graph has 4 spaces for the data for each number I am trying to plot. I just got 2007 version and do not recall this problem at all in 2003 version Merged cells are to be avoided at all costs. They can be used for column heading but for little else. best wishes -- Bernard V Liengme Microsoft Excel MVP http://people.stfx.ca/bliengme remove caps from email "Troubled...

Archive file size #2
Yesterday, I decided to split my archive file that is around 1.2gb size. So I created a new archive file (old archive.pst), and archived archive.pst to that. It all seemed to work, but the size of the original file is to all intents and purposes the same! How can that be? I thought archiving MOVED the files rather than copying them. Can anyone tell me what is going on and how to reduce the size of my original archive file? Many thanks rdc You need to compact the PST file after removing items out of it. This is done by right clicking on the top folder ("personal folders&q...

Purchase Order Approvals #2
If you access an Approved Purchase Order and change ANYTHING in the window, such as the Comments, the status of the Purchase Order switches back to Unapproved. Only changes affecting the document Total should switch the status back to Unapproved. ---------------- This post is a suggestion for Microsoft, and Microsoft responds to the suggestions with the most votes. To vote for this suggestion, click the "I Agree" button in the message pane. If you do not see the button, follow this link to open the suggestion in the Microsoft Web-based Newsreader and then click "I Agree...

Excel spread sheet #2
Every time I open ANY excel document on this CP it displays each individual cell as a page.......how do I change this setting? Moving each page break takes too long abd does not alway work. Hi try this macro to remove them all at once: Sub remove_them() ActiveSheet.ResetAllPageBreaks End Sub -- Regards Frank Kabel Frankfurt, Germany "dlam25mmm" <dlam25mmm@discussions.microsoft.com> schrieb im Newsbeitrag news:94BDFE5F-6CB2-4717-BE90-14A4245E0023@microsoft.com... > Every time I open ANY excel document on this CP it displays each individual > cell as a page.......how d...

Chart disappears in Excel 2000 after scale is changed
When the scale of the chart is changed, the chart disappears. The chart and its data are on the same worksheet. ...

Prevent cells with no value from being plotted on chart
I have a chart based on cells that are the result of a calculation. The cells show empty if the data used for the calculation is not yet available (future data). As a result, as my chart shows the whole year, the line drops and remains to zero after the last available set of data. Excel will let me prevent an empty cell of being plotted but since there is a fornmula is the cell, it is not considered empty, and therefore displayed. How can I prevent these cells to be plotted on the chart? Thanks Vince You can use an IF formula with NA(). For example: =IF(B2="",NA(),B...