View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.charting
Michael Michael is offline
external usenet poster
 
Posts: 10
Default Chart - Fixed Median Value

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