Can I see gridlines above area in chart diagram?
Book1.xls
Can I see gridlines above area in chart diagram?
Book1.xls
Last edited by zbor; 08-23-2009 at 08:17 AM.
If I understand your question, format the chart to have no fill.
Entia non sunt multiplicanda sine necessitate
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....
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.
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
If you are using 2007 then you can adjust the transparency of the area fills.
Nope, it doesn't help me either :-S
You need to explain why making your own gridlines or setting the transparency will not help.
What exactly are you trying to do?
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.
Use a stacked area rather than overlapped
Oh, yes.. working now
I tried in one moment with stacked.. don't know now why I give up
perhaps because the stacked would have given wrong shaded area unless you adjusted the values used by the second area.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks