log chart minor gridline values at tick marks

I have an XY scatter graph with log10 scales on both axes.  How can I display 
the minor gridline values at the axes tick marks?  Currently, the axes 
display only the power of 10 values (.1, 1, 10, etc...)

Thanks
0
Utf
1/5/2010 1:53:01 PM
excel.misc 78881 articles. 5 followers. Follow

1 Replies
3806 Views

Similar Articles

[PageSpeed] 6

Excel does not allow for minor tick labels. However, you can add a dummy 
XY series along each axis, with a point at each value where you want a 
label. Hide the points (no line or marker) and add a data label that 
shows the value. Position the label appropriately.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



ExcellerZero wrote:
> I have an XY scatter graph with log10 scales on both axes.  How can I display 
> the minor gridline values at the axes tick marks?  Currently, the axes 
> display only the power of 10 values (.1, 1, 10, etc...)
> 
> Thanks
0
Jon
1/6/2010 6:29:30 PM
Reply:

Similar Artilces:

How to chart a profit & loss statement/Profitability analysis statement in Excel Charts
Hello All I want to chart a profit & loss statement / profitability analysis statement in Excel Chart. Essentially I have the numbers for the following in one of the Excel worksheet: ========================================= Gross Sales A sales & Admin Expenses B COGS (Cost of Goods Sold) C ========================================= Gross Profit D = A-B-C ========================================= Selling Expenses E General & Admin Expenses F ========================================= Total Expenses G = E + F ...

Embed table in Excel Chart
I have inherited a spreadsheet containing a chart. The chart has a "floating" table containing with data from another part of the workbook. When I single-click on the table, the following text is shown in the formula bar... =EMBED("Microsoft Excel Worksheet","") If I double-click on the table the "hidden" table appears. I want to create this same effect in another chart, but I'm puzzled at how to set this up. I know it's possible to create a linked embedded object from excel into word or another application, but how to do this withing...

Print Chart Idea Needed
I have a number of charts "stacked" one over the other - the user can only see one at a time (done by VBA). Now I want to put a feature on the worksheet where the user can select a chart and print it. Need ideas... If only one chart is visible at any given time, it kinda restricts the ability to select any chart. Or am I missing something? -- Regards, Tushar Mehta, MS MVP -- Excel www.tushar-mehta.com Excel, PowerPoint, and VBA add-ins, tutorials Custom MS Office productivity solutions In article <025a01c3c599$d92c1980$a301280a@phx.gbl>, anonymous@discussions.micro...

Top values
Dear friends, need your help again please. I have a table: tbl_Plots (PlotID is the primar key - number byte) and tbl_Data (ID is the primary key - autonumber, PlotID related to tblePlots, height - number byte and diameter - number integer). I need to select the 20 bulkiest trees of each plot, i.e. having the biggest diameter. Also, perhaps in a plot less than 20 trees will be present so I will need all of them. Any suggestions? Thanking you in advance, GeorgeCY hi Geroge, George wrote: > I have a table: tbl_Plots (PlotID is the primar key - number byte) and > tbl_Data (ID is...

Unable to log into my Outlook mail
I can log into my win2k domain, but when I open my outlook I get prompted for username, password,and domain. When I enter the correct info, the system replies that it's incorrect. I have tried changing passwords and many other fixes, including uninstalling and reinstalling office and still can't get it to work. I can log into outlook and my account from a different computer, but not from mine. Scanned my computer with Norton NAV. On the client side, using Outlook 2002, with winXP sp1, office 2002 sp1 & 2. On the server side, using echange 2000 with sp 3, windows 2000 ser...

Problems generating an html link based on worksheet values
Hello Peop's, I am sorry, the fault was in the data not the program. The file \\FDR-server\General Pool\Beatrix\DATA SHEETS\FDR_PDF\4383 DAT 01.pdf does not physically exist (due to a time lag in capturing data sheets in our asset management system). Both macros work fine - so there you all go, spoilt for free choice. Fred. Have you looked at the hyperlink worksheet function? Regards, Tom Ogilvy "Frederik Romanov" <fdr@regus.mailshell.com> wrote in message news:47b1f764.0307010534.69352320@posting.google.com... > Hello Peop's, > > I am sorry, the fault...

Online Log Size
I've got a 40G SS 2005 table without indexes that I need to add a clustered index to. I know that if I do a standard index addition, it will write out about 40G to the log and I was hoping to avoid that. If do the ONLINE option for building this clustered index, will it write out significantly less to the log by any chance? Nope - but, you can try changing the recovery model to BULK-LOGGED and seeing if that reduces the amount of data recorded in the transaction log. Remember to change the recovery model back to full after the index has been rebuilt. Note: the transact...

chart conditional formatting
I have a line chart with 3 lines, red, blue and green. Is there any way I can conditionally format some, but not all, points on the red line to colour white - ie make them invisible. I have looked at Jon Peltier's site - he addresses conditional formatting - but cannot see a solution there. Thanks in advance to all who try to help. -- bob777 ------------------------------------------------------------------------ bob777's Profile: http://www.excelforum.com/member.php?action=getinfo&userid=28504 View this thread: http://www.excelforum.com/showthread.php?threadid=488635 Hi, Ha...

Simple Stock Watchlist Chart
Dear all, Does anyone have a spreadsheet that they could send me that allows you to enter purchase price/date of a paticular stock and quantity purchased, and it will graph/chart the net loss/profits from a paticular stock or portfolio. Any help or direction would be appreciated, benengel14@NOSPAMhotmail.com From Ben {Delete the "NOSPAM" in the email address if you wish to send me an email} I have this in Microsoft Money. "Ben Engel" <benengel14@NOSPAMoptusnet.com.au> wrote in message news:41be70af$0$4533$afc38c87@news.optusnet.com.au... > Dear all, &g...

Circular Logging
Can circular logging in Exchange 2003 really free up 20 GB of hard disk space? I enabled it and I was amazed to see my free space five-fold. yip, not necessarily 20mb but just make sure u backup the transaction logs, u will need when u do a restore of your database. "Josh" <Josh@puzzled.com> wrote in message news:26a701c4aada$a7d2f7b0$a501280a@phx.gbl... > Can circular logging in Exchange 2003 really free up 20 GB > of hard disk space? I enabled it and I was amazed to see > my free space five-fold. Josh wrote: > Can circular logging in Exchange 2003 r...

Getting out of pivot chart view -Help!
I'm working in Excel 2003 and don't know how to get out of the pivot chart view and back to the database. -- white rabbit never mind. I figured it out. Duh. -- white rabbit "white rabbit" wrote: > I'm working in Excel 2003 and don't know how to get out of the pivot chart > view and back to the database. > -- > white rabbit ...

PiVot Table charts
Hi, Data struct. ============= 1) Division/Dept 2) Projects other data.... Scenario =========== Analysing the data relevant to each division & projects having the Dept as Page Field and Projects as Base field thro' Pivot chart Problem ======== Base field (Project) list all the projects irrelevant to that particular division/dept. Please provide a solution ...

Table fields:- Setting default values to be based on other field values
Greetings, Is it possible to define at a table design level that a default vaule of a field is based on other fields? For example Field "Name" = Field "FirstName" + "SecondName" Thanks Rob It's not possible and, in fact, wanting to do something like that is usually an indication that the table hasn't been properly normalized. In your example, Name shouldn't exist in the table: it's redundant (since it's based solely on values in other fields of the same row). -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails...

log events in the event log
I want to be able to track when a user connects to their mailbox. I have someone who is trying to connect to other mailboxes and I want this to be log in the event log. I would like to show the user name and the mailbox they tried to connect to in the same event. Is there a way to do this? Thanks in advance for your help... Question for you...Does this person who is attempting to connect to the mailboxes have full exchange administrator rights on the Exchange Org? If so, you may want to refer to a previous post as this same question was asked and then answered. Jermaine "faf19...

Object Heirarchy Chart
Is there a way thru which i can get Excel object & collection heirarchy. hi Anupam, I'm not sure exactly what you mean but you may find the Object Browser useful. To see the Object Browser, open the VBE & press [F2]. hth Rob -- broro183 Rob Brockett. Always learning & the best way to learn is to experience... ------------------------------------------------------------------------ broro183's Profile: 333 View this thread: http://www.thecodecage.com/forumz/showthread.php?t=183178 [url=&quot;http://www.thecodecage.com&quot;]Microsoft Offi...

cannot create hyperlink to Chart Sheet
When I try to create a hyperlink to a chart sheet in the same workbook, all sheets are listed to choose from EXCEPT my chart sheets. Anyone know how I can create a hyperlink to my chart sheet? I'll refer you to my Excel Charting FAQ: http://pubs.logicalexpressions.com/Pub0009/LPMArticle.asp?ID=209#jon016 - Jon ------- Jon Peltier, Microsoft Excel MVP http://www.geocities.com/jonpeltier/Excel/index.html _______ ibeetb wrote: > When I try to create a hyperlink to a chart sheet in the same workbook, all > sheets are listed to choose from EXCEPT my chart sheets. Anyone know how I ...

Diagnostics Logging
Some email to some domains can't be delivered showing as "The connection was dropped by the remote host" What type of logging should I enable to troubleshoot this? THanks also, where does it log too be default? "James" <fake@email.com> wrote in message news:uxUhWt9eEHA.1652@TK2MSFTNGP09.phx.gbl... > Some email to some domains can't be delivered > showing as "The connection was dropped by the remote host" > > What type of logging should I enable to troubleshoot this? > > THanks > > ...

floating chart #2
Is their a way to make a chart basically float in the same spot on an excel page while you scroll up and down the page? I often put the chart at the top of the sheet, then freeze the panes at a row just below the chart, so only the bottom half of the window scrolls. - Jon ------- Jon Peltier, Microsoft Excel MVP Tutorials and Custom Solutions Peltier Technical Services, Inc. - http://PeltierTech.com _______ "adambush4242@hotmail.com" <adambush4242hotmailcom@discussions.microsoft.com> wrote in message news:1E3D7619-8069-4019-8AB5-B13EAB254A0E@microsoft.com... > Is th...

Problem with log in to Vista
I've got a problem with my Vista (Home Premium) I tried to log in in the morning and this problem occured - all of my desktop icons (same goes to wallpaper) vanished, my Windows taskbar won't open and I can only browse my computer through one explorer window that popped out during a log in (I can browse all the areas/hdd's of my pc) I scanned my OS with AVG antivir but the problem still occurs. It's been 8 months since I install the system (and i've got all the updates) and I never had a problem like this before. What is it? Is it a virus or any other piece of m...

Boxplot and Whisker chart in Excel
I need to know how to create boxplot and whisker chart in Excel, and boxplot and whisker chart in Pivot table, anyone know where can I get these informations? Anna Try chart guru Jon Peltier's site. http://peltiertech.com/Excel/Charts/BoxWhiskerH.html Gord Dibben Excel MVP On Sat, 4 Sep 2004 14:39:15 -0700, "Anna" <anonymous@discussions.microsoft.com> wrote: >I need to know how to create boxplot and whisker chart in >Excel, and boxplot and whisker chart in Pivot table, >anyone know where can I get these informations? ...

creating a log sheet
Hi all, I've created a method to capture current user (network username) and a date / time stamp. I want this output to be logged on a hidden sheet called 'log' strangely enough! How does it find the next available line in log to output to? tia see if this will help you. you didn't give too specific of a description, so hopefully this is what you're looking for lastRow = Worksheets("log").Cells(Rows.Count, "A").End(xlUp).Row range("A: & lastrow +1) = "your date/time stamp code" -- Gary "sacrum" <sacrum...

pasting charts form excel 2 power point, Chart cutoff right side
I am trying to paste a excel chart that is on its own sheet in excel to powerpoint page. But it cuts the right side of the chart off. usually the legend is cut short. But if you copy a chart thats mixed on a page with other data & charts it works fine. ?????? #$%6& I hate computers! Doug Ramsey Change the location of your chart right click on it, select location, then choose as a new sheet. copy and paste from there and it should work >-----Original Message----- >I am trying to paste a excel chart that is on its own >sheet in excel to powerpoint page. But it cuts ...

How to log internet header of incoming emails?
Hello, I want to log internet header of incoming emails. I want to see the content of the Bcc field. Is it possible? And if yes, how and where I have to config the log settings in exchange server? We use exchange 2000. Thanks. Regards Christian You can create a rudimentary log of incoming mail using the SMTP protocol logging feature of the SMTP virtual server. It will not record the BCC field or any of the message content, though. The BCC field would be inside the RFC 2822 header of the message. To record anything in that you would need an SMTP protocol sink. The Archive sink mig...

Date without true value
Hi, I have a table that lists the invoice dates. On a monthly basis, I need to write a report of how many invoices were issue, let's say, in January. I converted the date mm/dd/yy into just mm/yy, but I still have the true value in the background and when I try to count how many invoices were issued in January, I get "0". Any suggestion? Thank you for your help. Rubem See if this does what you want. As long as the dates are true Excel dates then this should work. Let's assume the dates are in the range A1:A10. To count the number of dates for a ...

charts getting elongated after closing
I have a file that uses VBA to generate charts. It has worked great. Today I noticed the charts, of previously closed files would be elongated when I reopen the file. It hasn't done this in the past. The only thing I can think of is I recently attached my laptop to a proxima that caused my resolution to be altered. Could that have had some influence? Why would the graph be changing from the VBA-directed format? TIA ...