log scale for x axis

I am trying to plot a line graph with a log scale on the x axis, can anyone 
help me with this, is there a way or an add on that can do this for me

Mike
0
Mike1154 (1216)
7/21/2005 5:37:04 PM
excel.charting 18370 articles. 0 followers. Follow

1 Replies
476 Views

Similar Articles

[PageSpeed] 16

Mike  -

> I am trying to plot a line graph with a log scale on the x axis, can 
> anyone help me with this, is there a way or an add on that can do this for 
> me <

Use the XY (Scatter) chart type, not the Line chart type.

Format the data series pattern to show lines.

Format the axis scale to be log.

-  Mike
www.mikemiddleton.com 


0
7/21/2005 5:49:29 PM
Reply:

Similar Artilces:

a ton of transaction logs being generated
Hi, We have a E2k3 sp1 server Message Inspector Anti Spyware Our transaction logs are out of control and have eaten up all of our Hard drive space. This is all in one day. What is causing this?Message logging records all of this spam. But why all of a sudden is this happening. We have a spam filter..but it is a piece of crap. This just started a couple weeks ago. I hate having circular logging on but that is the only way we can get through the day. We have no virus's, public folder replicaton is not an issue. Chris, I;m getting this also, in the same timeframe. Are you also get...

Chart Axis Labels are cutting short in 2002
The Axis labels in Excel 2002 are cutting of before the last letter. I can't size the square, its not an option, and if I change the font, the same thing happens. Only if I add an underscore in the titles will the last letter appear, but also will half the underscore. On Tue, 21 Oct 2003 06:33:38 -0700, Jason <castellanij@mbusa.com> wrote:= > The Axis labels in Excel 2002 are cutting of before the > last letter. I can't size the square, its not an option, > and if I change the font, the same thing happens. Only > if I add an underscore in the titles will the...

OWA Logging / Mailbox
I'm running Exchange 2003 and we have users accessing OWA externally. Besides the default IIS logging (C:\WINDOWS\system32\LogFiles) is there anyway I can tell who's logging in to OWA / or what account is being accessed? I find the C:\WINDOWS\system32\LogFiles to be kind of useless. Thanks! I think that is pretty much your only option. An event 1016 is logged (event logs) if someone accesses another users mailbox but there are many legitimate reasons for this. What are or who are you trying to catch? Nue "Frank G" <frankgrimesjr@gmail.com> wrote in message news:1...

Exchange 2003 Log Entry Time Stamps
My smtp session logs In c:\windows\system32\LogFiles have time entries that appear to be GMT, about 7 hours ahead of my actual time. Is there a way to set this to log the local time instead? On Wed, 18 May 2005 14:55:39 GMT, "NeedHelp" <eckmant@earthlink.net> wrote: >My smtp session logs In c:\windows\system32\LogFiles have time entries that >appear to be GMT, about 7 hours ahead of my actual time. Is there a way to >set this to log the local time instead? > > You can set the rollover for local time, but AFAIK, there is no way to set the time within ...

X-axis on graph
I am graphing some data. I would like to use specific x-axis values. Like say, starting from 0 to 10 and use major increments of 2 and minor of 0.5. Is there a way to do this? Thanks! KJ wrote on Thu, 16 Feb 2006 12:10:32 -0800: K> I am graphing some data. I would like to use specific K> x-axis values. Like say, starting from 0 to 10 and use K> major increments of 2 and minor of 0.5. Is there a way to K> do this? Thanks! I was initially inclined to say RTFM but you know, "Help" on this is hard to find or some people at Microsoft don't think the sa...

Line
I have a table with 4 columns and I want to show three columns as bars on one axis and one as a line on the other axis but the standard format always splits the table into two bars and two lines. Even if I transfer the third column into the primary axis it still stays as a line. Any help will be great. Ta, Michael Hi Michael, Best thing to do is create a Column chart based on all 4 data series. Them select the data series that you want to plot as a line. Right click and pick Chart Type from the popup menu. Pick the appropriate line chart. Michael C wrote: > I have a table with 4 col...

Font Color Conditional Formatting/Color Scaling
tWithin a matrix of data, I want to use two conditional formating/color scaling: one for the background color of the cell, the second for the font color corresponding to a different (but same size) data matrix. I know how to use the conditional formatting/color scaling for the background color--however would it be possible to have a different color scaling for the font color (and applied to one data matrix but referencing a separate data matrix)? Or even, can I at least use the conditional formatting/color scaling but changing the font color instead of the background cell col...

NLPGERMAN.log on my desk
Hi Guys, ..... and Gals ! I wonder what the file NLPGERMAN.log means and does , whenever I use my liscenced Microsoft Office for Mac Version v.X (in german) It appears on my desk once in a while also in my folders where saved docs are and I don't know if this needs to be, I can stop that process creating them and what are they good for. Never had that with my former office versions and therefore it bothers me a little. Can someone please send me small info as you cracks surely know about it. Thanx so far and enjoy time with the juiciest apples on earth... ;) Lady Mac In article <...

Restricting more than x number of characters in a cell....
I have a macro that refreshes a web query. The data that it pulls changes format quite often. Is there any way to limit the number of characters pulled or shown in a cell/column? Example: (In one column) ABCDEFG ABCDEFG ABCDEFG ABCDEFG ABCDEFG ABCDEFG I only want the first four characters (without running a Left formula in another column) in the column. Example: ABCD ABCD ABCD ABCD ABCD ABCD Let's assume that you already have a routine the does the web refresh: Sub Offer_Refreshments Let's assume that the data refreshed goes in column A. Include a new routine: Sub limitum() Set ...

Changing Side Y-Axis Appears On
Is there a way I can change a line chart I'm working with so that the labels on the Y-axis appear on the right hand side of the chart, and if so, how would I do that. I actually have a workbook in which I've created three line charts on three different tabs. The second chart actually has the data labels on the right hand side of the chart, but it was something Excel defaulted to. I've been through all the chart settings and can't see how I could do this myself. Double click the X axis, and change the status of the Value (Y) Axis Crosses at Maximum checkbox. - Jon ---...

Delete log file
How do I delete these log files that are on my hard drive when I finish updating Office? Thank you. jonlevinson@DELETETHISverizon.net In article <4346797b.0310081925.5b3286eb@posting.google.com>, jonlevinson@verizon.net (Jon Levinson) wrote: > How do I delete these log files that are on my hard drive when I > finish updating Office? You should be able to delete them if you log in as an administrator (or root). ...

Transaction logs building on SMTP gateway
One of our Exchange 2003 servers is configured as our incoming SMTP gateway. Ever since we configured it thus, it has been accumulating transaction logs at 4 or 5 gb per day. It's becoming a chore to back it up and we're a tiny bit nervous about the disk space. There are no mailboxes or Public Folders on that server. it's too soon to convert it to a Front-End server because it's still running an SRS. Is it safe to switch to Circular Logging? Are there any other workarounds? if there are no mailboxes or public folders on the server, it's usually safe to enable circ...

Colour part of a line on an X Y graph
I have an XY graph which connects the series with a line. Lets say the series runs left to right on the chart creating a straight horizontal line. Is it possible to have multiple colours on that line? That is, I want to colour certain portion of the line a certain colour and other portion another colour. Is this possible Hi, You can format the line between points by selecting the series and then selecting the specific line segment. Use CTRL+1 to bring up the format dialog. Note that formatting the line segment will affect the legend so you might be better off plotting additional d...

Transaction Logs #3
I have a big problem My transaction logs will not purge. I have my veritas backup set to purge the logs upon backup but it's not working. It was suggested to me that I try NTbackup. I did that and stil no luck. Can I delete the earlier ones and leave like a month? Or is there a utility I can run to putge the logs? Ntutils? I'm running out of hard drive space and I'd rather not enable circular logging. You really need to get on Online Backup of your Exchange Server. Do NOT start deleting log files! Do you have Veritas Support? For NTBACKUP please verify at, http:...

Text-to-speech in Excel X
I've been reading about Excel X having the ability to "read" text in=20 selected cells. Mac has the capability in Text Edit and the PC world = has=20 a "voice" option under the view+toolbars, but Mac doesn't. Any ideas? Thanks! ...

Avoid Corrupt Transaction logs
Hi Everyone, I have an SBS 2003 R2 box. It's a Dell box with 2 X Xeon 2.0 GHz, 4GB RAM, Power Edge RAID Card 5/i with a RAID 1 on a logical SAS 500GB HDD. System Volume C: is 150GB, Data Volume E: is 350GB. Both Exchange databases reside on the DATA volume. The PERC 5/i controller has a battery backup. It's default setting is "Write-back" cache with a battery backup. The controllers documentation Notes: If Write-back is enable and the system quickly turned off and then on, the controller may pause as the system flushes cache memory. The other setting avail...

x.asp file in Clip Organizer
All of a sudden my search results in the Publ 2002 Clip Organizer shows some thumbnails displayed correctly as usual, but MANY thumnails w/a "x.asp" ID in the middle. No image. MS Publisher 2002, W2000Pro, PaintShop Pro 8. Any ideas where to start? Thanks Richard Empty your cache, right-click your browser icon, properties, delete files or within IE, tools, Internet Options, delete files -- Mary Sauer MS MVP http://dgl.microsoft.com/ http://mvps.org/msauer/ "Richard S." <rstock2@hotmail.com> wrote in message news:5d4b01c35781$7e45fee0$a001280a@phx.gbl... >...

loading OS X Microsoft Office on Leopard
Version: v.X Operating System: Mac OS X 10.5 (Leopard) Processor: intel I only occasionally use the office suite on my MAC. Do I need to purchase an upgrade for my new OS 10.5? "ads4miller@officeformac.com" wrote: > I only occasionally use the office suite on my MAC. Do I need to purchase an > upgrade for my new OS 10.5? You can use Office X with Leopard, but it is end of life software and Entourage problems with the daylight saving time change that occurred a couple of years ago. If you don't need Exchange you can get Office 2008 very reasonably. $129.99 <http://t...

X axis lables on a + and
I have a line graph which has both positive and negative numbers. The problem is that I want to show the X axis labels on the graph but the labels get thrown in the middle of the graph on the zero line and I want them on the bottom, is there anyway I can do this (I'm sure there is!) For example if I have profit by month for 12 months I would have 01 100K 02 -500K 03 250K 04 100K 05 -100K etc... And If I wanted to graph that I should show the 01, 02,03 at the very bottom of the graph, not in the middle. Thanks in advance! Chad - Double click on the axis, and on the Patterns tab, sel...

Transcation log file full
How to clear the transcation log file in exchange server 2003 after I perform a full backup of the whole server. It becomes larger and larger...every day. thanks. Hi, A Full Backup of Exchange databases using an Exchange Aware backup Application should clear the committed transacton logs automatically. Please see the following reference: http://www.microsoft.com/technet/prodtechnol/exchange/guides/UseE2k3RecStorGrps/3acd2fc8-0765-43c3-80d5-4d60c131a7d3.mspx Regards -- Nagendra Sitharamaiah MCSE, CCNA, MCT, CISSP Microsoft Use of included script samples are subject to the terms specif...

Sending files to a commercial printer
I'm having some problems getting a book to print with proper shades of gray formatting in tables and text boxes. Long story short, my printer has told me that the formatting for gray can be between 10 & 15 %. Could anyone tell me what the RGB values have to be for grey scale to print with these values (10 or 15%)? I can't find a reference anywhere. Currently, I am using 166,166,166. My best guess is that's around 20%, but when I get the material back from the printer, the gray scale, even at that level is washed out. I know, time to look for a new printer. but for t...

Secondary Axis Annual Units sold on 1 Y Axis
I would like to develop an Excel Chart with the following data. I have a chart for 1. and 2. below.: 1. Total Units Sold (Values) (y-axis) 2. A series of years X Axis But I would like to show corresponding Dollar Volume (Price X Quantity) on a secondary Y Axis. Example below: Units Dollar Volume @ $10.00 per unit 10 100 5 50 1______________________________________________ 10 Years 2000 2001 2002 2003 -- ---------------------------------------------------- This mailbox protected from junk email by MailFrontier Desktop from MailFrontier, Inc. http://i...

I am trying to complete my account and log in?
I can't seem to complete the process for window's mail Please do not use @microsoft.com as your domain unless you are a Microsoft employee. Thank you. Who is your mail server? What type of account? What problems are you having? -- Bruce Hagen MS-MVP [Mail] Imperial Beach, CA "Andrew Withers" <Andro197331@microsoft.com> wrote in message news:%23Y3KIht0KHA.3652@TK2MSFTNGP04.phx.gbl... >I can't seem to complete the process for window's mail "Andrew Withers" <Andro197331@microsoft.com> wrote ...

Error message when launching Office V.X apps
Hi Hope someone can help. I have a new 15" PB. After installing Office V.X (without any apparent problems) I receive the following message after launching any of the apps: "An unexpected error acurred while trying to load the Microsoft Framework X library" I have not used the apps a lot since this started to appear, but they seem to work OK. Does anyone know what this means and how to get rid of it? Thanks in advance! On 10/9/03 07:22 AM, in article db703714.0310090622.7ff46abf@posting.google.com, "Pelao" <steve.mcc@mac.com> wrote: > I have a new 15"...

Limit Total Message Size (Size x Recipients)
Hi All, Please forgive me if this question has already been asked. PROBLEM: I have a recurring issue in that occassionally exchange (2003 - SBS Premium) users send large messages to numerous people - usually 50-500 recipients. Obviously when this happens our 1Mb/1Mb link gets totally stuck attempting to send messages with a total volume size of sometime over 2Gb. - individually the message may only be 3Mb or so but times that by 500 and you can see my problem. FAILED SOLUTIONS: I've attempted changing the various message limits within exchange but these only seem to effect the act...