|
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 |
Chart - Fixed Median Value
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 |
Chart - Fixed Median Value
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 |
Chart - Fixed Median Value
Hi Michael,
Move the line to the secondary axis. Format the secondary x axis to not cross between categories. To be found at the bottom of the step by step sheet in the download file. Cheers Andy Michael wrote: 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 -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info |
| All times are GMT +1. The time now is 08:25 AM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com