Show gridlines above area

**zbor** · 08-22-2009, 04:16 PM

Can I see gridlines above area in chart diagram?

Book1.xls

**shg** · 08-22-2009, 04:21 PM

If I understand your question, format the chart to have no fill.

**zbor** · 08-22-2009, 04:24 PM

I would like to be filled with different colors... But if I don't get how I guess I'll have to make them no fill, only borders....

**Andy Pope** · 08-23-2009, 06:27 AM

Grid lines are on the furthest layer so all chart types appear above them.

In order to see lines above the area you will need to draw them yourself using xy-scatter series.

**zbor** · 08-23-2009, 08:17 AM

I suppose that's it but I asked to be sure. Therefore I can't solve my problem (it's easier to scatter everything else

)
thanks

**Andy Pope** · 08-23-2009, 10:24 AM

If you are using 2007 then you can adjust the transparency of the area fills.

**zbor** · 08-23-2009, 10:36 AM

Nope, it doesn't help me either :-S

**Andy Pope** · 08-23-2009, 10:38 AM

You need to explain why making your own gridlines or setting the transparency will not help.

What exactly are you trying to do?

**zbor** · 08-23-2009, 10:53 AM

Here...
I didn't explain well in first example but here it is now.

Idea was to create range for min and max values.
I know there are many other ways (here mentioned before and usefull web pages) but I've just got idea and wanted to see is it working.

Unfortunally, it doesn't because can't get gridlines over diagram.

Transparency could work for upper diagream (actually, it's nice) but for lower wich is white, can't use it because green starts to appear.

Copy of Book1(1).xls

Oh, yes, making own gridlines would help but that would make diagram more complicated than solving this problem with other ways.