PC Review

Thread Tools Rating: Thread Rating: 1 votes, 5.00 average.

Only Some *Minor* Gridlines Showing Up On Line Plot

New Member
Join Date: Sep 2011
Posts: 1
      21st Sep 2011
I've written a series of VBA subs to generate a time series line plot in excel with the horizontal axis being a date axis and the value axis scale logarithmic. The horizontal axis scale is in months, the major unit scale is 6 months, and the minor unit scale is 3 months. Everything has worked out great except that for some reason when I try to add and format the minor gridlines, they don't all show up. I am attaching a screenshot of the plot that shows what I'm talking about. Does anyone have an idea as to why one or more of the minor gridlines do not show up? I have used a lot of code to generate the plot (including a forms sheet for inputs). I'll also attach the data series columns used to make the plot in the image. I realize it's not a huge issue, but I'm pretty frustrated by it nonetheless. Thanks in advance.

Attached Thumbnails
Only Some *Minor* Gridlines Showing Up On Line Plot-plot.jpg  
Attached Files
File Type: txt SeriesData.txt (27.3 KB, 126 views)
Reply With Quote

Thread Tools
Rate This Thread
Rate This Thread:

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are Off

Similar Threads
Thread Thread Starter Forum Replies Last Post
3D Scatter Line Plot in Excel - Wellbore Plot KenN Microsoft Excel Charting 0 12th May 2011 11:21 PM
Removing Plot lines between plot points on a line chart JDKapono24 Microsoft Excel Charting 1 28th Jun 2008 06:06 PM
How to make only some gridlines print and some that wont? Captainbaldy Microsoft Excel Misc 2 20th Dec 2007 08:22 PM
How to add a line plot onto a stacked plot in Excel =?Utf-8?B?VmlqYXk=?= Microsoft Excel Charting 1 14th Nov 2007 02:04 PM
Scatter plot changes to line plot with data gaps Jim Microsoft Excel Charting 13 8th Oct 2003 05:10 PM




All times are GMT +1. The time now is 01:31 AM.