Plotting a fixed level line on a chart

[Guest]

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?

 

[Andy Pope]

Hi,

You could adapted the conditional charting approach.
Create a column chart with 2 series. Set the overlap to 100.
Use formula to selectively display just 1 of the columns in the second
series. For more information see Jon's page on conditional charts.
http://peltiertech.com/Excel/Charts/ConditionalChart1.html

As for the data line see here for suggestions.
http://www.andypope.info/charts/averageline.htm

Cheers
Andy