View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
txgweedo txgweedo is offline
external usenet poster
 
Posts: 1
Default XL 07 - add color to specific part of plot area

I'm new to XL 07 and I'm trying to add color shading to a specific part of
the plot area based on the y axis. I've tried adding a new series but XL
says my line chart is too complex. I'm charting blood sugar levels taking at
different times each day. I want to color the range from 80 to 120 as a
'target level' across the chart. Please help if you can!