View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ed Ferrero Ed Ferrero is offline
external usenet poster
 
Posts: 115
Default CHARTS DATATABLE

Hi GILBERT,

The easy way is to use a chart embedded in a worksheet, build your own data
in a worksheet range table below the chart, and use conditional formatting
to highlight cells below a certain value.

You could also try the technique described here
http://www.edferrero.com/DataTab.zip to link an image of a worksheet range
to a chart.

Ed Ferrero
Microsoft Excel MVP
http://www.edferrero.com

Could this be done? I've a chart with a data table I need for the chart
to
highlight only the percentages that are below 93% in red and keep the
higher
percentages with the normal color black...the highlights would be in the
data table


Thanks In Advance