Colouring an area of an Excel Graph?

  TonyV 19:27 07 Apr 07

I have a graph which is showing the results of some medical tests that I do. The graph is made up of the X axis being the date and the Y axis being the average for a day of the results taken. If you consider that the Y axis has a scan of 0 to 14 as the average, what I would like to do is to either colour the 7 grid line red or colour the area between 4 and 7 red. Is there any way this can be done?



  Sandy110 20:41 07 Apr 07

Yes it can be done. What type of graph are you using?

  TonyV 20:48 07 Apr 07

A simple Line Graph.


  VoG II 23:10 07 Apr 07

Have a look at click here and if you still can't find what you want post your query at click here and the chances are that Jon Peltier will solve it for you.

  TonyV 11:03 08 Apr 07

Many thanks for that. I got the hint from the first link you posted. What I have done is to "draw" a box from axis Y4 to axis Y7 the width of the chart, coloured it and then made it transparent. It has done what I wanted and now shows where the results should be and where the major variations are. It gives a quick scan as to where I should be!!



This thread is now locked and can not be replied to.

Surface Pro (2017) vs Surface Pro 4

Where HTML5 is headed next

MacBook Pro v Surface Pro 5