View Single Post
  #1  
Old July 28th, 2007, 05:32 AM posted to microsoft.public.excel.charting
BarryL
external usenet poster
 
Posts: 18
Default Plotting a fixed level line on a chart

I have created a bar graph that shows responses to a survey. The survey is
anonymous so the graph does not reveal the ID of repondants against the
individual bars on the graph. However, when I print the graph in a
customized survey report, I want the graph to show each respondant how they
performed against the rest of the group by changing the colour of their
individual data point. I can manually do this by simply selecting and
changing the colour of a specific data point. Is there a way to do this
dynamically?