Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.charting
|
|||
|
|||
White gridlines that visible over columns?
Does anyone know if or how I can have white major gridlines that are in
effect 'on top of' the columns in a chart? I'm trying to create a white backgrounded histogram, with white horizontal gridlines that are effectively only visible as they 'bisect' the coloured columns. Any help appreciated. Jay |
#2
Posted to microsoft.public.excel.charting
|
|||
|
|||
White gridlines that visible over columns?
Hi,
You can create your own gridlines using an additional data series plotted as an XY scatter chart. then use the X Error bars to draw your lines. Cheers Andy Jay wrote: Does anyone know if or how I can have white major gridlines that are in effect 'on top of' the columns in a chart? I'm trying to create a white backgrounded histogram, with white horizontal gridlines that are effectively only visible as they 'bisect' the coloured columns. Any help appreciated. Jay -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
#3
Posted to microsoft.public.excel.charting
|
|||
|
|||
White gridlines that visible over columns?
Cheers Andy,
I've done what you suggested & with a bit of fiddling have got it just as I wanted. I've been reading Tufte & want to implement some of his avoiding chart-junk & maximising data-ink ideas (not something Excel lends itself to:-) Thanks Jay On 14/6/06 10:09, in article , "Andy Pope" wrote: Hi, You can create your own gridlines using an additional data series plotted as an XY scatter chart. then use the X Error bars to draw your lines. Cheers Andy Jay wrote: Does anyone know if or how I can have white major gridlines that are in effect 'on top of' the columns in a chart? I'm trying to create a white backgrounded histogram, with white horizontal gridlines that are effectively only visible as they 'bisect' the coloured columns. Any help appreciated. Jay |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Gridlines in excel | Excel Discussion (Misc queries) | |||
tried using SUBTOTAL function (XL XP) and it doesn't seem to work | New Users to Excel | |||
making only specified columns visible | Excel Discussion (Misc queries) | |||
Removing Near-Duplicate Rows, Leaving Those w/Most Data in Specific Columns | Excel Discussion (Misc queries) |