format a single gridline

  • Thread starter Thread starter TomCon
  • Start date Start date
T

TomCon

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
 
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.
Click to expand...

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
 
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
 
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
Click to expand...

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
 
Thanks, yes, this works. Another kludge to the rescue!
Thanks,
tom
Click to expand...


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

Ken Johnson
 
Back
Top