Andy - I like the simplicity of your method. However, is there a way to
stretch the average line for the full width of the plot area?

Michael




"Andy Pope" wrote in message
...
Hi,

Use the column next to salary to store the average figure for each State.
The simply add an extra data series to the chart and plot as a line.

This page contains examples and links to other sites.
http://www.andypope.info/charts/averageline.htm

Cheers
Andy

Michael wrote:
Hi Folks - I have a chart based on the following data:

State Salary
RI 35000
CT 42000
NH 39000
VT 36000
ME 37000

The average salary for all states is 37800.

I'd like to chart this data with the states on the x-axis and the salary
amount on the y-axis.

Here's the catch .. I'd like to chart the average state salary as a fixed
horizontal line on the y-axis. Do-able?

Thanks,

Michael




--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info