Colouring an area of an Excel Graph?

  TonyV 19:27 07 Apr 2007

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 2007

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

  TonyV 20:48 07 Apr 2007

A simple Line Graph.


  VoG II 23:10 07 Apr 2007

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 2007

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.

Elsewhere on IDG sites

Xiaomi Mi Mix 2 review

What went wrong at the Designs of the Year 2017

iPhone X news: Release date, price, new features & specs

Comment créer, modifier et réinitialiser un compte Apple ?