Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
DiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWord
DirectoryUser Groups
Related Topics
Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ...

MS Office Forum / Excel / New Users / July 2007

Tip: Looking for answers? Try searching our database.

format a single gridline

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
TomCon - 20 Jul 2007 22:26 GMT
Is there any way to format a single gridline differently from the other
gridlines?  There is one i would in particular like to call attention to, by
making it thicker and a different color from the others.

While i could just draw a line over the gridline, then that line would need
to be moved when new data came in and the chart scale changed.  If i could
format a single gridline, then i would not have that issue to deal with.

Thanks,
tom
Rick Rothstein (MVP - VB) - 20 Jul 2007 23:13 GMT
> Is there any way to format a single gridline differently from the other
> gridlines?  There is one i would in particular like to call attention to,
[quoted text clipped - 4 lines]
> could format a single gridline, then i would not have that issue to deal
> with.

Did you try this. Select the two (entire) rows around the grid line you want
to highlight and click on Format/Cells from Excel's menu (or right-click the
highlighted rows an select FormatCells from the popup menu). Click the
Border tab on the dialog box that appears, click on the thick line in the
Style box and select a color from the Color drop down box. Once that is
done, click the 2nd icon down (on the left) in the Border area (a solid red
horizontal line should appear across the middle of the boxed area). Click
OK. That line will move automatically as rows are added or deleted.

Rick
TomCon - 21 Jul 2007 01:16 GMT
I'm sorry this question was ambiguous.  I meant on a chart, not on the
workbook grid.

So, any ideas on formatting a single chart gridline?

Thanks,
tom

>> Is there any way to format a single gridline differently from the other
>> gridlines?  There is one i would in particular like to call attention to,
[quoted text clipped - 16 lines]
>
> Rick
Ken Johnson - 21 Jul 2007 03:06 GMT
> I'm sorry this question was ambiguous.  I meant on a chart, not on the
> workbook grid.
[quoted text clipped - 24 lines]
>
> > Rick

You could add a dummy series consisting of two points so that the line
joining those points lies over the top of the particular gridline you
are wanting to draw attention to.

I'm assuming your chart is XY (Scatter). Say you wanted the horizontal
gridline at Y = 10 to be red and thicker and that the maximum value on
the X axis is 50. After selecting the chart you could go Chart|Source
Data... to bring up the Source Data dialog. Click the Series tab then
click the Add button to add a new series.In the X Values: box type
={0,50}
In the Y Values: box type ={10,10}
Then click OK.
On the chart , select that new series and format it so that there are
no markers and the line is thicker and red (assuming your other
gridlines aren't already the thickest).

If the X axis maximum value is Auto you will need to set it to 50 so
that the dummy series line goes right to the edge of the chart.

Ken Johnson
TomCon - 21 Jul 2007 08:44 GMT
Thanks, yes, this works.  Another kludge to the rescue!
Thanks,
tom

>> I'm sorry this question was ambiguous.  I meant on a chart, not on the
>> workbook grid.
[quoted text clipped - 51 lines]
>
> Ken Johnson
Ken Johnson - 21 Jul 2007 10:39 GMT
> Thanks, yes, this works.  Another kludge to the rescue!
> Thanks,
[quoted text clipped - 55 lines]
>
> > Ken Johnson

Thanks for the feedback Tom.
I had to lookup kludge!
Thanks for expanding my vocabulary.

Ken Johnson
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2008 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.